shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/explain <<EOF
{
"query" : "FOR i IN 1..10 RETURN 1 / 0"
}
EOF
HTTP/1.1 OK
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
{
"plan" : {
"nodes" : [
{
"type" : "SingletonNode",
"dependencies" : [ ],
"id" : 1,
"estimatedCost" : 1,
"estimatedNrItems" : 1
},
{
"type" : "CalculationNode",
"dependencies" : [
1
],
"id" : 2,
"estimatedCost" : 2,
"estimatedNrItems" : 1,
"expression" : {
"type" : "range",
"typeID" : 49,
"subNodes" : [
{
"type" : "value",
"typeID" : 40,
"value" : 1,
"vType" : "int",
"vTypeID" : 2
},
{
"type" : "value",
"typeID" : 40,
"value" : 10,
"vType" : "int",
"vTypeID" : 2
}
]
},
"outVariable" : {
"id" : 2,
"name" : "1"
},
"canThrow" : false,
"expressionType" : "simple"
},
{
"type" : "CalculationNode",
"dependencies" : [
2
],
"id" : 4,
"estimatedCost" : 3,
"estimatedNrItems" : 1,
"expression" : {
"type" : "value",
"typeID" : 40,
"value" : null,
"vType" : "null",
"vTypeID" : 0
},
"outVariable" : {
"id" : 4,
"name" : "3"
},
"canThrow" : false,
"expressionType" : "json"
},
{
"type" : "EnumerateListNode",
"dependencies" : [
4
],
"id" : 3,
"estimatedCost" : 13,
"estimatedNrItems" : 10,
"inVariable" : {
"id" : 2,
"name" : "1"
},
"outVariable" : {
"id" : 0,
"name" : "i"
}
},
{
"type" : "ReturnNode",
"dependencies" : [
3
],
"id" : 5,
"estimatedCost" : 23,
"estimatedNrItems" : 10,
"inVariable" : {
"id" : 4,
"name" : "3"
},
"count" : true
}
],
"rules" : [
"move-calculations-up",
"move-calculations-up-2"
],
"collections" : [ ],
"variables" : [
{
"id" : 4,
"name" : "3"
},
{
"id" : 2,
"name" : "1"
},
{
"id" : 0,
"name" : "i"
}
],
"estimatedCost" : 23,
"estimatedNrItems" : 10,
"initialize" : true,
"isModificationQuery" : false
},
"cacheable" : false,
"warnings" : [
{
"code" : 1562,
"message" : "division by zero"
}
],
"stats" : {
"rulesExecuted" : 34,
"rulesSkipped" : 0,
"plansCreated" : 1
},
"error" : false,
"code" : 200
}