Previous Next JavaScript must be enabled to correctly display this content

## show query

    show query <statement>

Displays the query plan for a query.

For example:

    sql-> show query SELECT * from Users;
    RECV([6], 0, 1, 2, 3, 4)
    [
      DistributionKind : ALL_PARTITIONS,
      Number of Registers :7,
      Number of Iterators :12,
      SFW([6], 0, 1, 2, 3, 4)
      [
        FROM:
        BASE_TABLE([5], 0, 1, 2, 3, 4)
        [Users via primary index] as $$Users

        SELECT:
        *
      ]
    ]