Hi
I have measurement that query on it take long time, I run below query on it to investigate issue:
EXPLAIN SELECT COUNT(*) FROM “mymeasurment”
FYI: about 70k per minute datapoints write on this measurement.
Here is the result (number of shards is normal?):
┏━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ index ┃ QUERY PLAN ┃
┣━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┫
┃ 1┃EXPRESSION: count(transactionDateTime::string) ┃
┃ 2┃NUMBER OF SHARDS: 2 ┃
┃ 3┃NUMBER OF SERIES: 350284 ┃
┃ 4┃CACHED VALUES: 0 ┃
┃ 5┃NUMBER OF FILES: 350284 ┃
┃ 6┃NUMBER OF BLOCKS: 371717 ┃
┃ 7┃SIZE OF BLOCKS: 291748308 ┃
┃ 8┃ ┃
┃ 9┃EXPRESSION: count(responseTime::integer) ┃
┃ 10┃NUMBER OF SHARDS: 2 ┃
┃ 11┃NUMBER OF SERIES: 350284 ┃
┃ 12┃CACHED VALUES: 0 ┃
┃ 13┃NUMBER OF FILES: 350284 ┃
┃ 14┃NUMBER OF BLOCKS: 371717 ┃
┃ 15┃SIZE OF BLOCKS: 127891409 ┃
┃ 16┃ ┃
┃ 17┃EXPRESSION: count(trace::string) ┃
┃ 18┃NUMBER OF SHARDS: 2 ┃
┃ 19┃NUMBER OF SERIES: 350284 ┃
┃ 20┃CACHED VALUES: 0 ┃
┃ 21┃NUMBER OF FILES: 350284 ┃
┃ 22┃NUMBER OF BLOCKS: 371717 ┃
┃ 23┃SIZE OF BLOCKS: 314134371 ┃
┣━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┫
┃ 2 Columns, 23 Rows, Page 1/1┃
┃ Table 1/1, Statement 1/1┃
┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛
