When attempting explain on query with subquery, I note that the explain plan does NOT explain the subquery.
With that I would like to know if it is correct to assume that I can somewhat piece together the plan if i were to
explain select raw COUNT(number) from default where id = 1234
explain select * from data where (select raw COUNT(number) from default where id = 1234)[0] = 1
E.g.
explain select * from data where (select raw COUNT(number) from default where id = 1234)[0] = 1
Result as follow
{
“requestID”: “b0bf4871-e1d6-4262-a69f-b6ecf647600a”,
“clientContextID”: “372f5494-b79c-4f56-acfa-42bfe36656ee”,
“signature”: “json”,
“results”: [
{
“plan”: {
"#operator": “Sequence”,
"~children": [
{
"#operator": “PrimaryScan”,
“index”: “#primary”,
“keyspace”: “data”,
“namespace”: “default”,
“using”: “gsi”
},
{
"#operator": “Fetch”,
“keyspace”: “data”,
“namespace”: “default”
},
{
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [
{
"#operator": “Filter”,
“condition”: “(((select raw count((default
.number
)) from default
where ((default
.id
) = 1234))[0]) = 1)”
},
{
"#operator": “InitialProject”,
“result_terms”: [
{
“expr”: “self”,
“star”: true
}
]
},
{
"#operator": “FinalProject”
}
]
}
}
]
},
“text”: “select * from data where (select raw COUNT(number) from default where id = 1234)[0] = 1”
}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “13.181418ms”,
“executionTime”: “13.134162ms”,
“resultCount”: 1,
“resultSize”: 1950
}
}