mirror of https://gitee.com/bigwinds/arangodb
41 lines
1.4 KiB
Plaintext
41 lines
1.4 KiB
Plaintext
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
|
|
2 EnumerateCollectionNode 10 10000 0.00418 - FOR doc IN acollection /* full collection scan */
|
|
3 CalculationNode 10 10000 0.00256 - LET #1 = (doc.`value` < 10) /* simple expression */ /* collections used: doc : acollection */
|
|
4 FilterNode 1 10 0.00136 - FILTER #1
|
|
5 ReturnNode 1 10 0.00000 - RETURN doc
|
|
|
|
Indexes used:
|
|
none
|
|
|
|
Optimization rules applied:
|
|
none
|
|
|
|
Query Statistics:
|
|
Writes Exec Writes Ign Scan Full Scan Index Filtered Exec Time [s]
|
|
0 0 10000 0 9990 0.00868
|
|
|
|
Query Profile:
|
|
Query Stage Duration [s]
|
|
initializing 0.00000
|
|
parsing 0.00007
|
|
optimizing ast 0.00001
|
|
loading collections 0.00001
|
|
instantiating plan 0.00002
|
|
optimizing plan 0.00019
|
|
executing 0.00814
|
|
finalizing 0.00022
|
|
|
|
|