Inspect TSI indexes
This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.
Use the influxd inspect command to inspect the InfluxDB time series index (TSI).
- Output information about TSI index files
- Export TSI index data as SQL
- Report the cardinality of TSI files
Output information about TSI index files
Use the influxd inspect dump-tsi command
to output low-level details about TSI index (tsi1) files.
Provide the following:
- (Required)
--series-fileflag with the path to bucket’s_seriesdirectory. - (Required) Path to the shard’s
indexdirectory
influxd inspect dump-tsi \
--series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
Output raw series data stored in the index
To output raw series data stored in index files, include the --series flag with
the influxd inspect dump-tsi command:
influxd inspect dump-tsi \
--series \
--series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
Output measurement data stored in the index
To output measurement information stored in index files, include the --measurement
flag with the influxd inspect dump-tsi command:
influxd inspect dump-tsi \
--measurements \
--series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
Export TSI index data as SQL
Use the influxd inspect export-index command
to export an index in SQL format for easier inspection and debugging.
Provide the following:
--series-pathflag with the path to the bucket’s_seriesdirectory.--index-pathflag with the path to the shard’sindexdirectory.
influxd inspect export-index \
--series-path ~/.influxdbv2/engine/data/056d83f962a08461/_series \
--index-path ~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
Report the cardinality of TSI files
Use the influxd inspect report-tsi command
to output information about the cardinality of data in a bucket’s index.
Provide the following:
--bucket-idwith the ID of the bucket.
influxd inspect report-tsi --bucket-id 056d83f962a08461
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.