Documentation

Inspect TSI indexes

This page documents an earlier version of InfluxDB. InfluxDB v2.5 is the latest stable version. View this page in the v2.5 documentation.

Use the influxd inspect command to inspect the InfluxDB time series index (TSI).

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:

influxd inspect dump-tsi \
  --series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
  ~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index

View example output

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

View example output

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

View example output

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:

influxd inspect export-index \
  --series-path ~/.influxdbv2/engine/data/056d83f962a08461/_series \
  --index-path ~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index

View example output

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-id with the ID of the bucket.
influxd inspect report-tsi --bucket-id 056d83f962a08461

View example output


Was this page helpful?

Thank you for your feedback!


Set your InfluxDB URL

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.