[v1 shell] EXPLAIN not supported

samhld commented 2 years ago

EXPLAIN ANALYZE is supported but EXPLAIN is not. Is this due to a v2 storage constraint?

sanderson commented 1 year ago

Both EXPLAIN and EXPLAIN ANALYZE are working for me.

EXPLAIN select * from example.autogen.m
QUERY PLAN
----------
EXPRESSION: <nil>
AUXILIARY FIELDS: f::float
NUMBER OF SHARDS: 1
NUMBER OF SERIES: 1
CACHED VALUES: 0
NUMBER OF FILES: 1
NUMBER OF BLOCKS: 1
SIZE OF BLOCKS: 51

EXPLAIN ANALYZE select * from example.autogen.m
EXPLAIN ANALYZE
---------------
.
└── select
    ├── execution_time: 12.455µs
    ├── planning_time: 214.113µs
    ├── total_time: 226.568µs
    └── create_iterator
        ├── labels
        │   ├── measurement: m
        │   └── shard_id: 1910
        ├── cursors_ref: 0
        ├── cursors_aux: 1
        ├── cursors_cond: 0
        ├── float_blocks_decoded: 1
        ├── float_blocks_size_bytes: 51
        ├── integer_blocks_decoded: 0
        ├── integer_blocks_size_bytes: 0
        ├── unsigned_blocks_decoded: 0
        ├── unsigned_blocks_size_bytes: 0
        ├── string_blocks_decoded: 0
        ├── string_blocks_size_bytes: 0
        ├── boolean_blocks_decoded: 0
        ├── boolean_blocks_size_bytes: 0
        └── planning_time: 75.321µs

@samhld @candrewlee14, are we good to close this issue?

samhld commented 1 year ago

@sanderson Appears to have been a heisenbug in a previous build. Work for me too now.

influxdata / influx-cli

[v1 shell] EXPLAIN not supported #406