Inspect TSI indexes
API token hashing is enabled by default in InfluxDB OSS 2.9.0
Stronger token security: tokens are stored as hashes on disk, so a copy of the database file doesn’t expose usable tokens. Existing tokens are hashed on first startup and the original strings can’t be recovered afterward — capture any plaintext tokens you still need before you upgrade.
For more information, see Token hashing.
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/indexOutput 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/indexOutput 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/indexExport 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/indexReport 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 056d83f962a08461Was 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 OSS v2 and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.