Minor Description
In the query engine, there is a profile parameter called phases which returns parse, plan, and run time among other things. It would be nice to have something similar to this in the analytics engine.
Query engine output:
cbq> \set -profile "phases";
|
cbq> select count(*) from KS1;
|
{
|
"requestID": "5c1daf41-d304-4b44-8c49-63a6f694d032",
|
"signature": {
|
"$1": "number"
|
},
|
"results": [
|
{
|
"$1": 100000
|
}
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "4.99312ms",
|
"executionTime": "4.911644ms",
|
"resultCount": 1,
|
"resultSize": 28,
|
"serviceLoad": 2
|
},
|
"profile": {
|
"phaseTimes": {
|
"authorize": "16.325µs",
|
"count": "4.295219ms",
|
"instantiate": "15.363µs",
|
"parse": "432.993µs",
|
"plan": "45.055µs",
|
"run": "4.403276ms"
|
},*
|
"phaseOperators": {
|
"authorize": 1,
|
"count": 1
|
}
|
}
|
}
|