{
  "#operator": "Sequence",
  "#stats": {
    "#phaseSwitches": 1,
    "execTime": "33.256µs"
  },
  "~children": [
    {
      "#operator": "Authorize",
      "#stats": {
        "#phaseSwitches": 3,
        "execTime": "5.107µs",
        "servTime": "1.103561ms"
      },
      "privileges": {
        "List": [
          {
            "Target": "default:temp_bucket",
            "Priv": 7
          }
        ]
      },
      "~child": {
        "#operator": "Sequence",
        "#stats": {
          "#phaseSwitches": 1,
          "execTime": "31.406µs"
        },
        "~children": [
          {
            "#operator": "Sequence",
            "#stats": {
              "#phaseSwitches": 2,
              "execTime": "196.771µs",
              "kernTime": "207ns",
              "state": "running"
            },
            "~children": [
              {
                "#operator": "OrderedIntersectScan",
                "#stats": {
                  "#itemsIn": 258,
                  "#itemsOut": 121,
                  "#phaseSwitches": 763,
                  "execTime": "294.198µs",
                  "kernTime": "3.395907ms"
                },
                "limit": "2",
                "scans": [
                  {
                    "#operator": "IndexScan3",
                    "#stats": {
                      "#itemsOut": 256,
                      "#phaseSwitches": 1029,
                      "execTime": "349.856µs",
                      "kernTime": "51.372µs",
                      "servTime": "2.618315ms"
                    },
                    "index": "xi1",
                    "index_id": "d5af1151888957b3",
                    "index_order": [
                      {
                        "keypos": 0
                      },
                      {
                        "keypos": 1
                      }
                    ],
                    "index_projection": {
                      "primary_key": true
                    },
                    "keyspace": "temp_bucket",
                    "namespace": "default",
                    "spans": [
                      {
                        "exact": true,
                        "range": [
                          {
                            "high": "551",
                            "inclusion": 3,
                            "low": "551"
                          }
                        ]
                      }
                    ],
                    "using": "gsi",
                    "#time_normal": "00:00.0029",
                    "#time_absolute": 0.002968171
                  },
                  {
                    "#operator": "DistinctScan",
                    "#stats": {
                      "#itemsIn": 95,
                      "#itemsOut": 95,
                      "#phaseSwitches": 388,
                      "execTime": "65.648µs",
                      "kernTime": "3.229877ms"
                    },
                    "scan": {
                      "#operator": "IndexScan3",
                      "#stats": {
                        "#itemsOut": 256,
                        "#phaseSwitches": 1029,
                        "execTime": "378.592µs",
                        "kernTime": "54.098µs",
                        "servTime": "2.763855ms"
                      },
                      "index": "ai_SIM",
                      "index_id": "cdeec2476327396e",
                      "index_projection": {
                        "primary_key": true
                      },
                      "keyspace": "temp_bucket",
                      "namespace": "default",
                      "spans": [
                        {
                          "exact": true,
                          "range": [
                            {
                              "high": "[\"CUSTOMER_ID\", 551]",
                              "inclusion": 3,
                              "low": "[\"CUSTOMER_ID\", 551]"
                            }
                          ]
                        }
                      ],
                      "using": "gsi",
                      "#time_normal": "00:00.0031",
                      "#time_absolute": 0.003142447
                    },
                    "#time_normal": "00:00.0000",
                    "#time_absolute": 0.00006564799999999999
                  }
                ],
                "#time_normal": "00:00.0002",
                "#time_absolute": 0.00029419799999999996
              },
              {
                "#operator": "Fetch",
                "#stats": {
                  "#itemsIn": 33,
                  "#itemsOut": 16,
                  "#phaseSwitches": 109,
                  "execTime": "456.937µs",
                  "kernTime": "3.703964ms",
                  "servTime": "2.88767ms",
                  "state": "running"
                },
                "keyspace": "temp_bucket",
                "namespace": "default",
                "#time_normal": "00:00.0033",
                "#time_absolute": 0.0033446070000000003
              },
              {
                "#operator": "Sequence",
                "#stats": {
                  "#phaseSwitches": 2,
                  "execTime": "413.74µs",
                  "kernTime": "185ns",
                  "state": "running"
                },
                "~children": [
                  {
                    "#operator": "Filter",
                    "#stats": {
                      "#itemsIn": 16,
                      "#itemsOut": 16,
                      "#phaseSwitches": 69,
                      "execTime": "131.794µs",
                      "kernTime": "6.579216ms"
                    },
                    "condition": "((`temp_bucket`.`CUSTOMER_ID`) = 551)",
                    "#time_normal": "00:00.0001",
                    "#time_absolute": 0.00013179400000000002
                  },
                  {
                    "#operator": "InitialProject",
                    "#stats": {
                      "#itemsIn": 3,
                      "#itemsOut": 2,
                      "#phaseSwitches": 13,
                      "execTime": "106.415µs",
                      "kernTime": "6.28664ms"
                    },
                    "result_terms": [
                      {
                        "expr": "(`temp_bucket`.`TIM_ID`)"
                      },
                      {
                        "expr": "(`temp_bucket`.`MSISDN`)"
                      }
                    ],
                    "#time_normal": "00:00.0001",
                    "#time_absolute": 0.000106415
                  },
                  {
                    "#operator": "FinalProject",
                    "#stats": {
                      "#itemsIn": 2,
                      "#itemsOut": 2,
                      "#phaseSwitches": 8,
                      "execTime": "3.61µs",
                      "kernTime": "116ns"
                    },
                    "#time_normal": "00:00.0000",
                    "#time_absolute": 0.0000036099999999999997
                  }
                ],
                "#time_normal": "00:00.0004",
                "#time_absolute": 0.00041374
              }
            ],
            "#time_normal": "00:00.0001",
            "#time_absolute": 0.000196771
          },
          {
            "#operator": "Limit",
            "#stats": {
              "#itemsIn": 2,
              "#itemsOut": 2,
              "#phaseSwitches": 8,
              "execTime": "9.829µs",
              "kernTime": "302.031µs"
            },
            "expr": "2",
            "#time_normal": "00:00.0000",
            "#time_absolute": 0.000009829
          }
        ],
        "#time_normal": "00:00.0000",
        "#time_absolute": 0.000031406
      },
      "#time_normal": "00:00.0011",
      "#time_absolute": 0.0011086680000000002
    },
    {
      "#operator": "Stream",
      "#stats": {
        "#itemsIn": 2,
        "#itemsOut": 2,
        "#phaseSwitches": 11,
        "execTime": "6.181µs",
        "kernTime": "7.869644ms"
      },
      "#time_normal": "00:00.0000",
      "#time_absolute": 0.000006181
    }
  ],
  "~versions": [
    "2.0.0-N1QL",
    "6.5.0-1340-enterprise"
  ],
  "#time_normal": "00:00.0000",
  "#time_absolute": 0.000033256
}