arangosh> db._profileQuery(`
........> FOR doc IN acollection
........> FILTER doc.value < 10
........> RETURN doc`, {}, {colors: false}
........> );
Query String:
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.00004 - FOR doc IN acollection
5 ReturnNode 1 10 0.00000 - RETURN doc
Indexes used:
By Type Collection Unique Sparse Selectivity Fields Ranges
6 skiplist acollection false false n/a [ `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.00039
Query Profile:
Query Stage Duration [s]
initializing 0.00000
parsing 0.00005
optimizing ast 0.00001
loading collections 0.00001
instantiating plan 0.00003
optimizing plan 0.00014
executing 0.00006
finalizing 0.00009