"metrics": {
"elapsedTime": "7.461507251s",
"executionTime": "7.461275462s",
"resultCount": 2871,
"resultSize": 172260
},
"profile": {
"phaseTimes": {
"authorize": "2.751461ms",
"fetch": "2.671758013s",
"filter": "90.968181ms",
"indexScan": "4.732661267s",
"instantiate": "117.112µs",
"nestedLoopJoin": "398.156511ms",
"parse": "4.242657ms",
"plan": "45.178928ms",
"run": "7.411668435s"
},
"phaseCounts": {
"fetch": 27311,
"filter": 2871,
"indexScan": 8175
},
"phaseOperators": {
"authorize": 1,
"fetch": 2872,
"filter": 1,
"indexScan": 2873,
"nestedLoopJoin": 1
},
"executionTimings": {
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "3.171µs"
},
"~children": [
{
"#operator": "Authorize",
"#stats": {
"#phaseSwitches": 3,
"execTime": "6.63µs",
"servTime": "2.744831ms"
},
"privileges": {
"List": [
{
"Target": "default:cms-data",
"Priv": 7
},
{
"Target": "default:cms-deploy-dev",
"Priv": 7
}
]
},
"~child": {
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "4.346µs"
},
"~children": [
{
"#operator": "IntersectScan",
"#stats": {
"#itemsIn": 5303,
"#itemsOut": 2871,
"#phaseSwitches": 16355,
"execTime": "12.50442ms",
"kernTime": "4.765514716s"
},
"scans": [
{
"#operator": "IndexScan3",
"#stats": {
"#itemsOut": 2871,
"#phaseSwitches": 11489,
"execTime": "8.957573ms",
"kernTime": "5.163049ms",
"servTime": "3.911908ms"
},
"as": "col_data",
"index": "Index_Type_scope",
"index_id": "dea2c57da430025b",
"index_projection": {
"primary_key": true
},
"keyspace": "cms-data",
"namespace": "default",
"spans": [
{
"exact": true,
"range": [
{
"high": "\"game\"",
"inclusion": 3,
"low": "\"game\""
},
{
"high": "\"rollingslots\"",
"inclusion": 3,
"low": "\"rollingslots\""
}
]
}
],
"using": "gsi"
},
{
"#operator": "IndexScan3",
"#stats": {
"#itemsOut": 2432,
"#phaseSwitches": 9735,
"execTime": "9.410368ms",
"kernTime": "4.023204ms",
"servTime": "4.971099ms"
},
"as": "col_data",
"index": "Index_id",
"index_id": "53d698339581e545",
"index_projection": {
"primary_key": true
},
"keyspace": "cms-data",
"namespace": "default",
"spans": [
{
"exact": true,
"range": [
{
"inclusion": 0,
"low": "null"
}
]
}
],
"using": "gsi"
}
]
},
{
"#operator": "Fetch",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 11847,
"execTime": "32.444076ms",
"kernTime": "5.583459862s",
"servTime": "514.495667ms"
},
"as": "col_data",
"keyspace": "cms-data",
"namespace": "default"
},
{
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "2.758µs"
},
"~children": [
{
"#operator": "NestedLoopJoin",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 28713,
"execTime": "398.156511ms",
"kernTime": "7.010492603s"
},
"alias": "dex",
"on_clause": "((((((`dex`.`id`) = (`col_data`.`id`)) and ((`dex`.`status`) in [\"active\", \"old\"])) and ((`dex`.`hash`) = (`col_data`.`hash`))) and ((`dex`.`_scope`) = \"rollingslots\")) and ((`dex`.`_type`) = \"game\"))",
"~child": {
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 5742,
"execTime": "493.665169ms",
"kernTime": "3.383161ms",
"state": "running"
},
"~children": [
{
"#operator": "IndexScan3",
"#stats": {
"#itemsOut": 2871,
"#phaseSwitches": 20097,
"execTime": "57.832505ms",
"kernTime": "11.313996ms",
"servTime": "4.647577814s"
},
"as": "dex",
"index": "Index_status_id_hash",
"index_id": "42422e314b93442c",
"index_projection": {
"primary_key": true
},
"keyspace": "cms-deploy-dev",
"namespace": "default",
"nested_loop": true,
"spans": [
{
"exact": true,
"range": [
{
"high": "\"active\"",
"inclusion": 3,
"low": "\"active\""
},
{
"high": "(`col_data`.`id`)",
"inclusion": 3,
"low": "(`col_data`.`id`)"
},
{
"high": "(`col_data`.`hash`)",
"inclusion": 3,
"low": "(`col_data`.`hash`)"
}
]
},
{
"exact": true,
"range": [
{
"high": "\"old\"",
"inclusion": 3,
"low": "\"old\""
},
{
"high": "(`col_data`.`id`)",
"inclusion": 3,
"low": "(`col_data`.`id`)"
},
{
"high": "(`col_data`.`hash`)",
"inclusion": 3,
"low": "(`col_data`.`hash`)"
}
]
}
],
"using": "gsi"
},
{
"#operator": "Fetch",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 25839,
"execTime": "64.464853ms",
"kernTime": "4.782144686s",
"servTime": "2.060353417s"
},
"as": "dex",
"keyspace": "cms-deploy-dev",
"namespace": "default",
"nested_loop": true
}
]
}
},
{
"#operator": "Filter",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 11487,
"execTime": "90.968181ms",
"kernTime": "7.317758618s"
},
"condition": "(((`col_data`.`_scope`) = \"rollingslots\") and ((`col_data`.`_type`) = \"game\"))"
},
{
"#operator": "InitialProject",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 8618,
"execTime": "37.9022ms",
"kernTime": "7.340155793s"
},
"result_terms": [
{
"as": "_k",
"expr": "(`dex`.`id`)"
}
]
},
{
"#operator": "FinalProject",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 8614,
"execTime": "12.546979ms",
"kernTime": "15.361705ms"
}
}
]
}
]
}
},
{
"#operator": "Stream",
"#stats": {
"#itemsIn": 2871,
"#itemsOut": 2871,
"#phaseSwitches": 5745,
"execTime": "58.629513ms",
"kernTime": "7.352970315s"
}
}
],
"~versions": [
"6.5.0-N1QL",
"6.6.1-9213-enterprise"
]
}