Details
-
Bug
-
Resolution: Cannot Reproduce
-
Major
-
5.0.0
-
spock: 5.0.0-1752
-
Untriaged
-
Unknown
Description
|
Index created:
CREATE INDEX `myidx1` ON `beer-sample`((distinct (array `v` for `v` in pairs(self) end))) WITH { "nodes":"dd:c9:23:92:30:4a:48:2b” }
Query issued:
select *
from `beer-sample` b
where any t in tokens(description) satisfies t = 'beer' end
and
b.type = 'beer' and
b.state = 'California’;
Explain plan should be:
{
"explain": {
"#operator": "Sequence",
"#stats": {
"execTime": "5.143µs",
"kernTime": "6.694233ms"
},
"~children": [
{
"#operator": "Authorize",
"#stats": {
"execTime": "10.82µs",
"kernTime": "4.557122ms",
"servTime": "2.105111ms"
},
"privileges": {
"default:beer-sample": 1
},
"~child": {
"#operator": "Sequence",
"#stats": {
"execTime": "11.224µs",
"kernTime": "4.539895ms"
},
"~children": [
{
"#operator": "IntersectScan",
"#stats": {
"#itemsIn": 9,
"#itemsOut": 8,
"execTime": "401.444µs",
"kernTime": "1.349783ms"
},
"scans": [
{
"#operator": "DistinctScan",
"#stats": {
"#itemsIn": 8,
"#itemsOut": 8,
"execTime": "119.98µs",
"kernTime": "36.652µs",
"servTime": "1.162037ms"
},
"scan": {
"#operator": "IndexScan",
"#stats": {
"execTime": "46.393µs",
"kernTime": "1.095733ms"
},
"index": "mytknindex",
"index_id": "3f775c177cbcac13",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"\"beer\""
],
"Inclusion": 3,
"Low": [
"\"beer\""
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 8,
"execTime": "34.714µs",
"kernTime": "9.623µs",
"servTime": "1.044061ms"
},
"index": "mytknindex",
"index_id": "3f775c177cbcac13",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"\"beer\""
],
"Inclusion": 3,
"Low": [
"\"beer\""
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000046393
},
"#time_normal": "00:00.0012",
"#time_absolute": 0.0012820169999999999
},
{
"#operator": "IndexScan",
"#stats": {
"execTime": "43.967µs",
"kernTime": "1.272331ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"execTime": "7.07µs",
"kernTime": "1.093µs",
"servTime": "1.254822ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000043967
},
{
"#operator": "IndexScan",
"#stats": {
"execTime": "30.668µs",
"kernTime": "1.178907ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 1,
"execTime": "17.212µs",
"kernTime": "4.052µs",
"servTime": "1.150037ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000030668
}
],
"#time_normal": "00:00.0004",
"#time_absolute": 0.00040144400000000004
},
{
"#operator": "Fetch",
"#stats": {
"#itemsIn": 8,
"#itemsOut": 8,
"execTime": "141.479µs",
"kernTime": "1.776266ms",
"servTime": "987.85µs"
},
"as": "b",
"keyspace": "beer-sample",
"namespace": "default",
"#time_normal": "00:00.0011",
"#time_absolute": 0.001129329
},
{
"#operator": "Sequence",
"#stats": {
"execTime": "6.524µs",
"kernTime": "4.527958ms"
},
"~children": [
{
"#operator": "Filter",
"#stats": {
"#itemsIn": 8,
"execTime": "1.564929ms",
"kernTime": "2.925054ms"
},
"condition": "((any `t` in tokens((`b`.`description`)) satisfies (`t` = \"beer\") end and ((`b`.`type`) = \"beer\")) and ((`b`.`state`) = \"California\"))",
"#time_normal": "00:00.0015",
"#time_absolute": 0.001564929
},
{
"#operator": "InitialProject",
"#stats": {
"execTime": "7.981µs",
"kernTime": "4.497734ms"
},
"result_terms": [
{
"expr": "self",
"star": true
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000007981
},
{
"#operator": "FinalProject",
"#stats": {
"execTime": "7.715µs",
"kernTime": "4.513501ms"
},
"#time_normal": "00:00.0000",
"#time_absolute": 0.000007715
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000006524
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000011224
},
"#time_normal": "00:00.0021",
"#time_absolute": 0.0021159309999999997
},
{
"#operator": "Stream",
"#stats": {
"execTime": "6.997µs",
"kernTime": "6.681011ms"
},
"#time_normal": "00:00.0000",
"#time_absolute": 0.000006997
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000005143
},
"analysis": {
"buckets": {
"beer-sample": true
},
"fields": {
"beer-sample.description": true,
"beer-sample.type": true,
"beer-sample.state": true,
"beer-sample.*": true
},
"indexes": {
"beer-sample.mytknindex": true,
"beer-sample.myidx1": true
},
"aliases": [],
"total_time": 0.006660261999999999,
"currentKeyspace": "beer-sample"
},
"plan_nodes": {
"predecessor": {
"predecessor": {
"predecessor": {
"predecessor": {
"predecessor": {
"predecessor": [
0.006660261999999999,
{
"predecessor": null,
"operator": {
"#operator": "IndexScan",
"#stats": {
"execTime": "43.967µs",
"kernTime": "1.272331ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"execTime": "7.07µs",
"kernTime": "1.093µs",
"servTime": "1.254822ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000043967
},
"subsequence": null,
"time_percent": 0.7
},
{
"predecessor": null,
"operator": {
"#operator": "IndexScan",
"#stats": {
"execTime": "30.668µs",
"kernTime": "1.178907ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 1,
"execTime": "17.212µs",
"kernTime": "4.052µs",
"servTime": "1.150037ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000030668
},
"subsequence": null,
"time_percent": 0.5
}
],
"operator": {
"#operator": "IntersectScan",
"#stats": {
"#itemsIn": 9,
"#itemsOut": 8,
"execTime": "401.444µs",
"kernTime": "1.349783ms"
},
"scans": [
{
"#operator": "DistinctScan",
"#stats": {
"#itemsIn": 8,
"#itemsOut": 8,
"execTime": "119.98µs",
"kernTime": "36.652µs",
"servTime": "1.162037ms"
},
"scan": {
"#operator": "IndexScan",
"#stats": {
"execTime": "46.393µs",
"kernTime": "1.095733ms"
},
"index": "mytknindex",
"index_id": "3f775c177cbcac13",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"\"beer\""
],
"Inclusion": 3,
"Low": [
"\"beer\""
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 8,
"execTime": "34.714µs",
"kernTime": "9.623µs",
"servTime": "1.044061ms"
},
"index": "mytknindex",
"index_id": "3f775c177cbcac13",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"\"beer\""
],
"Inclusion": 3,
"Low": [
"\"beer\""
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000046393
},
"#time_normal": "00:00.0012",
"#time_absolute": 0.0012820169999999999
},
{
"#operator": "IndexScan",
"#stats": {
"execTime": "43.967µs",
"kernTime": "1.272331ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"execTime": "7.07µs",
"kernTime": "1.093µs",
"servTime": "1.254822ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000043967
},
{
"#operator": "IndexScan",
"#stats": {
"execTime": "30.668µs",
"kernTime": "1.178907ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 1,
"execTime": "17.212µs",
"kernTime": "4.052µs",
"servTime": "1.150037ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000030668
}
],
"#time_normal": "00:00.0004",
"#time_absolute": 0.00040144400000000004
},
"subsequence": null,
"time_percent": 6
},
"operator": {
"#operator": "Fetch",
"#stats": {
"#itemsIn": 8,
"#itemsOut": 8,
"execTime": "141.479µs",
"kernTime": "1.776266ms",
"servTime": "987.85µs"
},
"as": "b",
"keyspace": "beer-sample",
"namespace": "default",
"#time_normal": "00:00.0011",
"#time_absolute": 0.001129329
},
"subsequence": null,
"time_percent": 17
},
"operator": {
"#operator": "Filter",
"#stats": {
"#itemsIn": 8,
"execTime": "1.564929ms",
"kernTime": "2.925054ms"
},
"condition": "((any `t` in tokens((`b`.`description`)) satisfies (`t` = \"beer\") end and ((`b`.`type`) = \"beer\")) and ((`b`.`state`) = \"California\"))",
"#time_normal": "00:00.0015",
"#time_absolute": 0.001564929
},
"subsequence": null,
"time_percent": 23.5
},
"operator": {
"#operator": "InitialProject",
"#stats": {
"execTime": "7.981µs",
"kernTime": "4.497734ms"
},
"result_terms": [
{
"expr": "self",
"star": true
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000007981
},
"subsequence": null,
"time_percent": 0.1
},
"operator": {
"#operator": "Authorize",
"#stats": {
"execTime": "10.82µs",
"kernTime": "4.557122ms",
"servTime": "2.105111ms"
},
"privileges": {
"default:beer-sample": 1
},
"~child": {
"#operator": "Sequence",
"#stats": {
"execTime": "11.224µs",
"kernTime": "4.539895ms"
},
"~children": [
{
"#operator": "IntersectScan",
"#stats": {
"#itemsIn": 9,
"#itemsOut": 8,
"execTime": "401.444µs",
"kernTime": "1.349783ms"
},
"scans": [
{
"#operator": "DistinctScan",
"#stats": {
"#itemsIn": 8,
"#itemsOut": 8,
"execTime": "119.98µs",
"kernTime": "36.652µs",
"servTime": "1.162037ms"
},
"scan": {
"#operator": "IndexScan",
"#stats": {
"execTime": "46.393µs",
"kernTime": "1.095733ms"
},
"index": "mytknindex",
"index_id": "3f775c177cbcac13",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"\"beer\""
],
"Inclusion": 3,
"Low": [
"\"beer\""
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 8,
"execTime": "34.714µs",
"kernTime": "9.623µs",
"servTime": "1.044061ms"
},
"index": "mytknindex",
"index_id": "3f775c177cbcac13",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"\"beer\""
],
"Inclusion": 3,
"Low": [
"\"beer\""
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000046393
},
"#time_normal": "00:00.0012",
"#time_absolute": 0.0012820169999999999
},
{
"#operator": "IndexScan",
"#stats": {
"execTime": "43.967µs",
"kernTime": "1.272331ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"execTime": "7.07µs",
"kernTime": "1.093µs",
"servTime": "1.254822ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"type\", \"beer\"]"
],
"Inclusion": 3,
"Low": [
"[\"type\", \"beer\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000043967
},
{
"#operator": "IndexScan",
"#stats": {
"execTime": "30.668µs",
"kernTime": "1.178907ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi",
"~children": [
{
"#operator": "IndexScan",
"#stats": {
"#itemsOut": 1,
"execTime": "17.212µs",
"kernTime": "4.052µs",
"servTime": "1.150037ms"
},
"index": "myidx1",
"index_id": "7534cb4d93464d32",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Exact": true,
"Range": {
"High": [
"[\"state\", \"California\"]"
],
"Inclusion": 3,
"Low": [
"[\"state\", \"California\"]"
]
}
}
],
"using": "gsi"
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000030668
}
],
"#time_normal": "00:00.0004",
"#time_absolute": 0.00040144400000000004
},
{
"#operator": "Fetch",
"#stats": {
"#itemsIn": 8,
"#itemsOut": 8,
"execTime": "141.479µs",
"kernTime": "1.776266ms",
"servTime": "987.85µs"
},
"as": "b",
"keyspace": "beer-sample",
"namespace": "default",
"#time_normal": "00:00.0011",
"#time_absolute": 0.001129329
},
{
"#operator": "Sequence",
"#stats": {
"execTime": "6.524µs",
"kernTime": "4.527958ms"
},
"~children": [
{
"#operator": "Filter",
"#stats": {
"#itemsIn": 8,
"execTime": "1.564929ms",
"kernTime": "2.925054ms"
},
"condition": "((any `t` in tokens((`b`.`description`)) satisfies (`t` = \"beer\") end and ((`b`.`type`) = \"beer\")) and ((`b`.`state`) = \"California\"))",
"#time_normal": "00:00.0015",
"#time_absolute": 0.001564929
},
{
"#operator": "InitialProject",
"#stats": {
"execTime": "7.981µs",
"kernTime": "4.497734ms"
},
"result_terms": [
{
"expr": "self",
"star": true
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000007981
},
{
"#operator": "FinalProject",
"#stats": {
"execTime": "7.715µs",
"kernTime": "4.513501ms"
},
"#time_normal": "00:00.0000",
"#time_absolute": 0.000007715
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000006524
}
],
"#time_normal": "00:00.0000",
"#time_absolute": 0.000011224
},
"#time_normal": "00:00.0021",
"#time_absolute": 0.0021159309999999997
},
"subsequence": null,
"time_percent": 31.8
},
"operator": {
"#operator": "Stream",
"#stats": {
"execTime": "6.997µs",
"kernTime": "6.681011ms"
},
"#time_normal": "00:00.0000",
"#time_absolute": 0.000006997
},
"subsequence": null,
"time_percent": 0.1
}
}
|