plan.json

{
  "plan": {
    "#operator": "Sequence",
    "~children": [
      {
        "#operator": "DistinctScan",
        "scan": {
          "#operator": "IndexScan3",
          "index": "segments_idx",
          "index_id": "87ffa977b0319b31",
          "index_projection": {
            "primary_key": true
          },
          "keyspace": "sample",
          "namespace": "default",
          "spans": [
            {
              "range": [
                {
                  "high": "\"membes\"",
                  "inclusion": 1,
                  "low": "\"member\""
                },
                {
                  "high": "\"segmenu\"",
                  "inclusion": 1,
                  "low": "\"segment\""
                }
              ]
            }
          ],
          "using": "gsi"
        }
      },
      {
        "#operator": "Fetch",
        "keyspace": "sample",
        "namespace": "default"
      },
      {
        "#operator": "Parallel",
        "~child": {
          "#operator": "Sequence",
          "~children": [
            {
              "#operator": "Filter",
              "condition": "(((0 < (`sample`.`count`)) and ((`sample`.`member_id`) like \"member_%\")) and any `segment` in (`sample`.`segments`) satisfies (`segment` like \"segment_0\") end)"
            },
            {
              "#operator": "InitialGroup",
              "aggregates": [
                "count(*)"
              ],
              "group_keys": []
            }
          ]
        }
      },
      {
        "#operator": "IntermediateGroup",
        "aggregates": [
          "count(*)"
        ],
        "group_keys": []
      },
      {
        "#operator": "FinalGroup",
        "aggregates": [
          "count(*)"
        ],
        "group_keys": []
      },
      {
        "#operator": "Parallel",
        "~child": {
          "#operator": "Sequence",
          "~children": [
            {
              "#operator": "InitialProject",
              "result_terms": [
                {
                  "expr": "count(*)"
                }
              ]
            },
            {
              "#operator": "FinalProject"
            }
          ]
        }
      }
    ]
  },
  "text": "SELECT count(*) FROM sample\nWHERE count > 0 AND member_id LIKE \"member_%\"\nAND ANY segment IN segments SATISFIES segment LIKE \"segment_0\" END;"
}