How to get the shard start/end date?


I can use influxdb_inspect tool to get shard start/end time :

influx_inspect report /opt/influxdb/data/telegraf/default/945

DB RP Shard File Series New (est) Min Time Max Time Load Time
telegraf default 945 000002029-000000002.tsm 3110884 3089977 2018-06-05T00:00:00Z 2018-06-05T23:59:59Z 182.009847ms

Files: 1
Time Range: 2018-06-05T00:00:00Z - 2018-06-05T23:59:59Z
Duration: 23h59m59s

- telegraf (est): 3089977 (100%)
Total (est): 3089977
Completed in 724.4954ms

Is it possible to get start/end time by influxdb query and not use influxdb_inspect ?


You can use the command SHOW SHARDS to get the shard information by querying InfluxDB.