Details
-
Bug
-
Resolution: Fixed
-
Critical
-
7.0.1
-
None
-
Untriaged
-
1
-
Unknown
Description
The same query using `EXPLAIN`:
The full `EXPLAIN` output:
[
|
{
|
"plan": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "IndexScan3", |
"bucket": "devportal-api", |
"covers": [ |
"cover ((`tmp`.`youtubeId`))", |
"cover ((meta(`tmp`).`id`))" |
],
|
"index": "tmp_youtubeId", |
"index_id": "6c222a4b9bea1d", |
"index_projection": { |
"entry_keys": [ |
0 |
]
|
},
|
"keyspace": "tmp", |
"namespace": "default", |
"scope": "_default", |
"spans": [ |
{
|
"range": [ |
{
|
"inclusion": 0, |
"low": "null" |
}
|
]
|
}
|
],
|
"using": "gsi" |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "Filter", |
"condition": "(cover ((`tmp`.`youtubeId`)) in (select (`video`.`youtubeId`) from `default`:`devportal-api`.`_default`.`video`))" |
},
|
{
|
"#operator": "InitialGroup", |
"aggregates": [ |
"count(*)" |
],
|
"group_keys": [] |
}
|
]
|
}
|
},
|
{
|
"#operator": "IntermediateGroup", |
"aggregates": [ |
"count(*)" |
],
|
"group_keys": [] |
},
|
{
|
"#operator": "FinalGroup", |
"aggregates": [ |
"count(*)" |
],
|
"group_keys": [] |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "InitialProject", |
"result_terms": [ |
{
|
"expr": "count(*)" |
}
|
]
|
}
|
]
|
}
|
}
|
]
|
},
|
"text": "select count(*) from tmp where youtubeId IN (select video.youtubeId from video)" |
}
|
]
|