{ "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "1.812µs" }, "~children": [ { "#operator": "Authorize", "#stats": { "#phaseSwitches": 3, "execTime": "4.124µs", "servTime": "10.086076ms" }, "privileges": { "List": [ { "Target": "default:test", "Priv": 7 } ] }, "~child": { "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "3.232µs" }, "~children": [ { "#operator": "DistinctScan", "#stats": { "#phaseSwitches": 5, "execTime": "19.297µs", "kernTime": "1.00742ms" }, "scan": { "#operator": "IndexScan3", "#stats": { "#phaseSwitches": 5, "execTime": "19.421µs", "kernTime": "1.585µs", "servTime": "976.164µs" }, "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.0009", "#time_absolute": 0.000995585 }, "#time_normal": "00:00.0000", "#time_absolute": 0.000019297000000000002 }, { "#operator": "Unnest", "#stats": { "#phaseSwitches": 3, "execTime": "3.388µs", "kernTime": "1.030301ms" }, "as": "doc", "expr": "cover (((`data`.`test_array`).`test_doc`))", "#time_normal": "00:00.0000", "#time_absolute": 0.000003388 }, { "#operator": "InitialGroup", "#stats": { "#phaseSwitches": 3, "execTime": "2.619µs", "kernTime": "1.035939ms" }, "aggregates": [ "count(cover ((meta(`data`).`id`)))" ], "group_keys": [ "(`doc`.`field_1`)", "(`doc`.`Id`)" ], "#time_normal": "00:00.0000", "#time_absolute": 0.0000026190000000000003 }, { "#operator": "IntermediateGroup", "#stats": { "#phaseSwitches": 3, "execTime": "2.364µs", "kernTime": "1.040764ms" }, "aggregates": [ "count(cover ((meta(`data`).`id`)))" ], "group_keys": [ "(`doc`.`field_1`)", "(`doc`.`Id`)" ], "#time_normal": "00:00.0000", "#time_absolute": 0.0000023639999999999997 }, { "#operator": "FinalGroup", "#stats": { "#phaseSwitches": 3, "execTime": "3.127µs", "kernTime": "1.048721ms" }, "aggregates": [ "count(cover ((meta(`data`).`id`)))" ], "group_keys": [ "(`doc`.`field_1`)", "(`doc`.`Id`)" ], "#time_normal": "00:00.0000", "#time_absolute": 0.000003127 }, { "#operator": "Sequence", "#stats": { "#phaseSwitches": 1, "execTime": "818ns" }, "~children": [ { "#operator": "InitialProject", "#stats": { "#phaseSwitches": 5, "execTime": "399.583µs", "kernTime": "1.054283ms" }, "result_terms": [ { "expr": "(`doc`.`field_1`)" }, { "expr": "(`doc`.`Id`)" }, { "as": "cnt", "expr": "count(cover ((meta(`data`).`id`)))" } ], "#time_normal": "00:00.0003", "#time_absolute": 0.000399583 }, { "#operator": "FinalProject", "#stats": { "#phaseSwitches": 1, "execTime": "455ns" }, "#time_normal": "00:00", "#time_absolute": 0 } ], "#time_normal": "00:00", "#time_absolute": 0 } ], "#time_normal": "00:00.0000", "#time_absolute": 0.000003232 }, "#time_normal": "00:00.0100", "#time_absolute": 0.0100902 }, { "#operator": "Stream", "#stats": { "#phaseSwitches": 3, "execTime": "28.885µs", "kernTime": "11.585636ms" }, "#time_normal": "00:00.0000", "#time_absolute": 0.000028885000000000002 } ], "~versions": [ "2.0.0-N1QL", "6.0.1-2037-enterprise" ], "#time_normal": "00:00.0000", "#time_absolute": 0.000001812 }