1
0
Fork 0
arangodb/Documentation/Examples/01_workWithAQL_databaseProf...

36 lines
1.3 KiB
Plaintext

arangosh> db._profileQuery("LET s = SLEEP(0.25) LET t = SLEEP(0.5) RETURN 1", {}, {colors: false});
Query String (47 chars, cacheable: false):
LET s = SLEEP(0.25) LET t = SLEEP(0.5) RETURN 1
Execution plan:
Id NodeType Calls Items Runtime [s] Comment
1 SingletonNode 1 1 0.00000 * ROOT
4 CalculationNode 1 1 0.00000 - LET #2 = 1 /* json expression */ /* const assignment */
2 CalculationNode 1 1 0.27105 - LET s = SLEEP(0.25) /* simple expression */
3 CalculationNode 1 1 0.51186 - LET t = SLEEP(0.5) /* simple expression */
5 ReturnNode 1 1 0.00000 - RETURN #2
Indexes used:
none
Optimization rules applied:
Id RuleName
1 move-calculations-up
Query Statistics:
Writes Exec Writes Ign Scan Full Scan Index Filtered Exec Time [s]
0 0 0 0 0 0.78316
Query Profile:
Query Stage Duration [s]
initializing 0.00000
parsing 0.00003
optimizing ast 0.00001
loading collections 0.00002
instantiating plan 0.00001
optimizing plan 0.00007
executing 0.78294
finalizing 0.00008