arangosh> db._profileQuery(`
........> FOR doc IN acollection
........> FILTER doc.value < 10
........> RETURN doc`, {}, {colors: false}
........> );
Query String (58 chars, cacheable: false):
FOR doc IN acollection
FILTER doc.value < 10
RETURN doc
Execution plan:
Id NodeType Calls Items Runtime [s] Comment
1 SingletonNode 1 1 0.00000 * ROOT
6 IndexNode 1 10 0.00009 - FOR doc IN acollection
5 ReturnNode 1 10 0.00000 - RETURN doc
Indexes used:
By Name Type Collection Unique Sparse Selectivity Fields Ranges
6 idx_1646382028474548226 skiplist acollection false false 100.00 % [ `value` ] (doc.`value` < 10)
Optimization rules applied:
Id RuleName
1 use-indexes
2 remove-filter-covered-by-index
3 remove-unnecessary-calculations-2
Query Statistics:
Writes Exec Writes Ign Scan Full Scan Index Filtered Exec Time [s]
0 0 0 10 0 0.00037
Query Profile:
Query Stage Duration [s]
initializing 0.00000
parsing 0.00004
optimizing ast 0.00000
loading collections 0.00001
instantiating plan 0.00001
optimizing plan 0.00010
executing 0.00011
finalizing 0.00007