Inspect TSI indexes

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:

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

View example output

  1. [LOG FILE] L0-00000006.tsl
  2. Series:        0
  3. Measurements:    0
  4. Tag Keys:    0
  5. Tag Values:    0
  7. [INDEX FILE] L3-00000008.tsi
  8. Measurements:        3
  9.   Series data size:    0 (0.0b)
  10.   Bytes per series:    0.0b
  11. Tag Keys:        15
  12. Tag Values:        1025
  13.   Series:        1700
  14.   Series data size:    0 (0.0b)
  15.   Bytes per series:    0.0b
  17. [LOG FILE] L0-00000010.tsl
  18. Series:        0
  19. Measurements:    0
  20. Tag Keys:    0
  21. Tag Values:    0
  23. [INDEX FILE] L2-00000011.tsi
  24. Measurements:        1
  25.   Series data size:    0 (0.0b)
  26.   Bytes per series:    0.0b
  27. Tag Keys:        5
  28. Tag Values:        9
  29.   Series:        10
  30.   Series data size:    0 (0.0b)
  31.   Bytes per series:    0.0b

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:

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

View example output

  1. earthquake,code=6000iuad,id=us6000iuad,magType=mww,net=us,title=M\ 5.2\ -\ 101\ km\ SE\ of\ Palca\,\ Peru
  2. earthquake,code=71377273,id=pr71377273,magType=md,net=pr,title=M\ 1.9\ -\ Puerto\ Rico\ region
  3. earthquake,code=73794611,id=nc73794611,magType=md,net=nc,title=M\ 0.6\ -\ 13km\ ESE\ of\ Mammoth\ Lakes\,\ CA
  4. earthquake,code=40361800,id=ci40361800,magType=ml,net=ci,title=M\ 1.3\ -\ 12km\ SE\ of\ Olancha\,\ CA
  5. earthquake,code=6000itfk,id=us6000itfk,magType=mb,net=us,title=M\ 4.4\ -\ Mindanao\,\ Philippines
  6. earthquake,code=2022ucrr,id=ok2022ucrr,magType=ml,net=ok,title=M\ 1.4\ -\ 4\ km\ SSE\ of\ Dover\,\ Oklahoma
  7. earthquake,code=73792706,id=nc73792706,magType=md,net=nc,title=M\ 0.6\ -\ 7km\ W\ of\ Cobb\,\ CA
  8. earthquake,code=6000isjn,id=us6000isjn,magType=mww,net=us,title=M\ 5.5\ -\ 69\ km\ E\ of\ Hualien\ City\,\ Taiwan
  9. earthquake,code=022d8mp4dd,id=ak022d8mp4dd,magType=ml,net=ak,title=M\ 1.3\ -\ Southern\ Alaska
  10. earthquake,code=022dbrb8vb,id=ak022dbrb8vb,magType=ml,net=ak,title=M\ 1.6\ -\ 37\ km\ NE\ of\ Paxson\,\ Alaska
  11. earthquake,code=6000iu2e,id=us6000iu2e,magType=mb,net=us,title=M\ 4.1\ -\ 81\ km\ WSW\ of\ San\ Antonio\ de\ los\ Cobres\,\ Argentina

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:

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

View example output

  1. Measurement
  2. earthquake
  3. explosion
  4. quarry blast
  7. Measurement
  8. earthquake
  9. explosion
  10. ice quake
  11. quarry blast
  14. Measurement
  15. earthquake
  16. explosion

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:

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

View example output

  1. CREATE TABLE IF NOT EXISTS measurement_series (
  2.     name      TEXT NOT NULL,
  3.     series_id INTEGER NOT NULL
  4. );
  6. CREATE TABLE IF NOT EXISTS tag_value_series (
  7.     name      TEXT NOT NULL,
  8.     key       TEXT NOT NULL,
  9.     value     TEXT NOT NULL,
  10.     series_id INTEGER NOT NULL
  11. );
  13. BEGIN TRANSACTION;
  14. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26920);
  15. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26928);
  16. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26936);
  17. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26944);
  18. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26952);
  19. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26960);
  20. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26968);
  21. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26976);
  22. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26984);
  23. INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26992);
  24. COMMIT;

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.
  1. influxd inspect report-tsi --bucket-id 056d83f962a08461

View example output

  1. Summary
  2. Database Path: /Users/scottanderson/.influxdbv2/engine/data/056d83f962a08461
  3. Cardinality (exact): 101698
  5. Measurement    Cardinality (exact)
  7. "earthquake"        99876
  8. "quarry blast"        1160
  9. "explosion"        589
  10. "ice quake"        58
  11. "other event"        10
  12. "chemical explosion"    2
  13. "rock burst"        1
  14. "sonic boom"        1
  15. "volcanic eruption"    1
  18. ===============
  19. Shard ID: 452
  20. Path: /Users/scottanderson/.influxdbv2/engine/data/056d83f962a08461/autogen/452
  21. Cardinality (exact): 1644
  23. Measurement    Cardinality (exact)
  25. "earthquake"    1607
  26. "quarry blast"    29
  27. "explosion"    7
  28. "sonic boom"    1
  29. ===============
  31. ===============
  32. Shard ID: 453
  33. Path: /Users/scottanderson/.influxdbv2/engine/data/056d83f962a08461/autogen/453
  34. Cardinality (exact): 2329
  36. Measurement    Cardinality (exact)
  38. "earthquake"    2298
  39. "quarry blast"    24
  40. "explosion"    7
  41. ===============

storage internals