{ "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "12.629µs" }, "~children": [ { "#operator": "Authorize", "#stats": { "#phaseSwitches": 3, "execTime": "3.948µs", "servTime": "8.636075ms" }, "privileges": { "List": [ { "Target": "default:test", "Priv": 7 } ] }, "~child": { "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "4.437µs" }, "~children": [ { "#operator": "DistinctScan", "#stats": { "#phaseSwitches": 5, "execTime": "8.339µs", "kernTime": "2.694579ms" }, "scan": { "#operator": "IndexScan3", "#stats": { "#phaseSwitches": 5, "execTime": "24.521µs", "kernTime": "1.144µs", "servTime": "2.663924ms" }, "as": "data", "covers": [ "cover ((all (array (`doc`.`Id`) for `doc` in ((`data`.`test_array`).`test_doc`) end)))", "cover (((`data`.`test_array`).`test_doc`))", "cover ((`data`.`field`))", "cover ((meta(`data`).`id`))" ], "filter_covers": { "cover ((((`data`.`test_array`).`test_doc`) < {}))": true, "cover (([] <= ((`data`.`test_array`).`test_doc`)))": true, "cover ((`data`.`type`))": "type", "cover (is_array(((`data`.`test_array`).`test_doc`)))": true }, "index": "test_index", "index_id": "59a941b3677c8d8a", "index_projection": { "entry_keys": [ 1, 2 ], "primary_key": true }, "keyspace": "test", "namespace": "default", "spans": [ { "exact": true, "range": [ { "inclusion": 1, "low": "\"0\"" }, { "high": "{}", "inclusion": 1, "low": "[]" }, { "high": "\"field\"", "inclusion": 3, "low": "\"field\"" } ] } ], "using": "gsi", "#time_normal": "00:00.0026", "#time_absolute": 0.0026884450000000002 }, "#time_normal": "00:00.0000", "#time_absolute": 0.000008339000000000001 }, { "#operator": "Unnest", "#stats": { "#phaseSwitches": 3, "execTime": "2.545µs", "kernTime": "2.70759ms" }, "as": "doc", "expr": "cover (((`data`.`test_array`).`test_doc`))", "#time_normal": "00:00.0000", "#time_absolute": 0.0000025449999999999998 }, { "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "1.935µs" }, "~children": [ { "#operator": "Filter", "#stats": { "#phaseSwitches": 3, "execTime": "2.536µs", "kernTime": "2.712886ms" }, "condition": "((((cover ((`data`.`type`)) = \"type\") and (cover ((`data`.`field`)) = \"field\")) and (\"0\" <= (`doc`.`Id`))) and ((`doc`.`Type`) = \"doc_type\"))", "#time_normal": "00:00.0000", "#time_absolute": 0.000002536 }, { "#operator": "InitialGroup", "#stats": { "#phaseSwitches": 3, "execTime": "3.038µs", "kernTime": "2.718719ms" }, "aggregates": [ "count(cover ((meta(`data`).`id`)))" ], "group_keys": [ "(`doc`.`field_1`)", "(`doc`.`Id`)" ], "#time_normal": "00:00.0000", "#time_absolute": 0.000003038 } ], "#time_normal": "00:00.0000", "#time_absolute": 0.000001935 }, { "#operator": "IntermediateGroup", "#stats": { "#phaseSwitches": 3, "execTime": "2.204µs", "kernTime": "2.727155ms" }, "aggregates": [ "count(cover ((meta(`data`).`id`)))" ], "group_keys": [ "(`doc`.`field_1`)", "(`doc`.`Id`)" ], "#time_normal": "00:00.0000", "#time_absolute": 0.000002204 }, { "#operator": "FinalGroup", "#stats": { "#phaseSwitches": 3, "execTime": "1.926µs", "kernTime": "2.731709ms" }, "aggregates": [ "count(cover ((meta(`data`).`id`)))" ], "group_keys": [ "(`doc`.`field_1`)", "(`doc`.`Id`)" ], "#time_normal": "00:00.0000", "#time_absolute": 0.000001926 }, { "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "2.051µs" }, "~children": [ { "#operator": "InitialProject", "#stats": { "#phaseSwitches": 5, "execTime": "10.65µs", "kernTime": "2.73881ms" }, "result_terms": [ { "expr": "(`doc`.`field_1`)" }, { "expr": "(`doc`.`Id`)" }, { "as": "cnt", "expr": "count(cover ((meta(`data`).`id`)))" } ], "#time_normal": "00:00.0000", "#time_absolute": 0.00001065 }, { "#operator": "FinalProject", "#stats": { "#phaseSwitches": 1, "execTime": "541ns" }, "#time_normal": "00:00", "#time_absolute": 0 } ], "#time_normal": "00:00.0000", "#time_absolute": 0.0000020510000000000004 } ], "#time_normal": "00:00.0000", "#time_absolute": 0.000004437 }, "#time_normal": "00:00.0086", "#time_absolute": 0.008640023 }, { "#operator": "Stream", "#stats": { "#phaseSwitches": 3, "execTime": "974ns", "kernTime": "11.404088ms" }, "#time_normal": "00:00", "#time_absolute": 0 } ], "~versions": [ "2.0.0-N1QL", "6.0.1-2037-enterprise" ], "#time_normal": "00:00.0000", "#time_absolute": 0.000012628999999999999 }