Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/influxdb/v2/admin/internals/tsi/inspect.md

252 lines
7.7 KiB
Markdown
Raw Permalink Blame History

---
title: Inspect TSI indexes
description: >
Use the `influxd inspect` command to inspect the InfluxDB TSI index.
menu:
influxdb_v2:
parent: Manage TSI indexes
related:
- /influxdb/v2/reference/internals/storage-engine/
- /influxdb/v2/reference/internals/file-system-layout/
- /influxdb/v2/reference/cli/influxd/inspect/dump-tsi/
- /influxdb/v2/reference/cli/influxd/inspect/export-index/
- /influxdb/v2/reference/cli/influxd/inspect/report-tsi/
---
Use the `influxd inspect` command to inspect the InfluxDB [time series index (TSI)](/influxdb/v2/reference/internals/storage-engine/#time-series-index-tsi).
- [Output information about TSI index files](#output-information-about-tsi-index-files)
- [Output raw series data stored in the index](#output-raw-series-data-stored-in-the-index)
- [Output measurement data stored in the index](#output-measurement-data-stored-in-the-index)
- [Export TSI index data as SQL](#export-tsi-index-data-as-sql)
- [Report the cardinality of TSI files](#report-the-cardinality-of-tsi-files)
## Output information about TSI index files
Use the [`influxd inspect dump-tsi` command](/influxdb/v2/reference/cli/influxd/inspect/dump-tsi/)
to output low-level details about TSI index (`tsi1`) files.
Provide the following:
- ({{< req >}}) `--series-file` flag with the path to bucket's
[`_series` directory](/influxdb/v2/reference/internals/file-system-layout/#tsm-directories-and-files-layout).
- ({{< req >}}) Path to the shard's
[`index` directory](/influxdb/v2/reference/internals/file-system-layout/#tsm-directories-and-files-layout)
```sh
influxd inspect dump-tsi \
--series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
```
{{< expand-wrapper >}}
{{% expand "View example output" %}}
```
[LOG FILE] L0-00000006.tsl
Series: 0
Measurements: 0
Tag Keys: 0
Tag Values: 0
[INDEX FILE] L3-00000008.tsi
Measurements: 3
Series data size: 0 (0.0b)
Bytes per series: 0.0b
Tag Keys: 15
Tag Values: 1025
Series: 1700
Series data size: 0 (0.0b)
Bytes per series: 0.0b
[LOG FILE] L0-00000010.tsl
Series: 0
Measurements: 0
Tag Keys: 0
Tag Values: 0
[INDEX FILE] L2-00000011.tsi
Measurements: 1
Series data size: 0 (0.0b)
Bytes per series: 0.0b
Tag Keys: 5
Tag Values: 9
Series: 10
Series data size: 0 (0.0b)
Bytes per series: 0.0b
```
{{% /expand %}}
{{< /expand-wrapper >}}
### 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:
```sh
influxd inspect dump-tsi \
--series \
--series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
```
{{< expand-wrapper >}}
{{% expand "View example output" %}}
```
earthquake,code=6000iuad,id=us6000iuad,magType=mww,net=us,title=M\ 5.2\ -\ 101\ km\ SE\ of\ Palca\,\ Peru
earthquake,code=71377273,id=pr71377273,magType=md,net=pr,title=M\ 1.9\ -\ Puerto\ Rico\ region
earthquake,code=73794611,id=nc73794611,magType=md,net=nc,title=M\ 0.6\ -\ 13km\ ESE\ of\ Mammoth\ Lakes\,\ CA
earthquake,code=40361800,id=ci40361800,magType=ml,net=ci,title=M\ 1.3\ -\ 12km\ SE\ of\ Olancha\,\ CA
earthquake,code=6000itfk,id=us6000itfk,magType=mb,net=us,title=M\ 4.4\ -\ Mindanao\,\ Philippines
earthquake,code=2022ucrr,id=ok2022ucrr,magType=ml,net=ok,title=M\ 1.4\ -\ 4\ km\ SSE\ of\ Dover\,\ Oklahoma
earthquake,code=73792706,id=nc73792706,magType=md,net=nc,title=M\ 0.6\ -\ 7km\ W\ of\ Cobb\,\ CA
earthquake,code=6000isjn,id=us6000isjn,magType=mww,net=us,title=M\ 5.5\ -\ 69\ km\ E\ of\ Hualien\ City\,\ Taiwan
earthquake,code=022d8mp4dd,id=ak022d8mp4dd,magType=ml,net=ak,title=M\ 1.3\ -\ Southern\ Alaska
earthquake,code=022dbrb8vb,id=ak022dbrb8vb,magType=ml,net=ak,title=M\ 1.6\ -\ 37\ km\ NE\ of\ Paxson\,\ Alaska
earthquake,code=6000iu2e,id=us6000iu2e,magType=mb,net=us,title=M\ 4.1\ -\ 81\ km\ WSW\ of\ San\ Antonio\ de\ los\ Cobres\,\ Argentina
```
{{% /expand %}}
{{< /expand-wrapper >}}
### 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:
```sh
influxd inspect dump-tsi \
--measurements \
--series-file ~/.influxdbv2/engine/data/056d83f962a08461/_series \
~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
```
{{< expand-wrapper >}}
{{% expand "View example output" %}}
```
Measurement
earthquake
explosion
quarry blast
Measurement
earthquake
explosion
ice quake
quarry blast
Measurement
earthquake
explosion
```
{{% /expand %}}
{{< /expand-wrapper >}}
## Export TSI index data as SQL
Use the [`influxd inspect export-index` command](/influxdb/v2/reference/cli/influxd/inspect/export-index/)
to export an index in SQL format for easier inspection and debugging.
Provide the following:
- `--series-path` flag with the path to the bucket's
[`_series` directory](/influxdb/v2/reference/internals/file-system-layout/#tsm-directories-and-files-layout).
- `--index-path` flag with the path to the shard's
[`index` directory](/influxdb/v2/reference/internals/file-system-layout/#tsm-directories-and-files-layout).
```sh
influxd inspect export-index \
--series-path ~/.influxdbv2/engine/data/056d83f962a08461/_series \
--index-path ~/.influxdbv2/engine/data/056d83f962a08461/autogen/1023/index
```
{{< expand-wrapper >}}
{{% expand "View example output" %}}
```sql
CREATE TABLE IF NOT EXISTS measurement_series (
name TEXT NOT NULL,
series_id INTEGER NOT NULL
);
CREATE TABLE IF NOT EXISTS tag_value_series (
name TEXT NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
series_id INTEGER NOT NULL
);
BEGIN TRANSACTION;
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26920);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26928);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26936);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26944);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26952);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26960);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26968);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26976);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26984);
INSERT INTO measurement_series (name, series_id) VALUES ('earthquake', 26992);
COMMIT;
```
{{% /expand %}}
{{< /expand-wrapper >}}
## Report the cardinality of TSI files
Use the [`influxd inspect report-tsi` command](/influxdb/v2/reference/cli/influxd/inspect/report-tsi/)
to output information about the cardinality of data in a bucket's index.
Provide the following:
- `--bucket-id` with the ID of the bucket.
```sh
influxd inspect report-tsi --bucket-id 056d83f962a08461
```
{{< expand-wrapper >}}
{{% expand "View example output" %}}
```
Summary
Database Path: /Users/scottanderson/.influxdbv2/engine/data/056d83f962a08461
Cardinality (exact): 101698
Measurement Cardinality (exact)
"earthquake" 99876
"quarry blast" 1160
"explosion" 589
"ice quake" 58
"other event" 10
"chemical explosion" 2
"rock burst" 1
"sonic boom" 1
"volcanic eruption" 1
===============
Shard ID: 452
Path: /Users/scottanderson/.influxdbv2/engine/data/056d83f962a08461/autogen/452
Cardinality (exact): 1644
Measurement Cardinality (exact)
"earthquake" 1607
"quarry blast" 29
"explosion" 7
"sonic boom" 1
===============
===============
Shard ID: 453
Path: /Users/scottanderson/.influxdbv2/engine/data/056d83f962a08461/autogen/453
Cardinality (exact): 2329
Measurement Cardinality (exact)
"earthquake" 2298
"quarry blast" 24
"explosion" 7
===============
```
{{% /expand %}}
{{< /expand-wrapper >}}
Reference in New Issue View Git Blame Copy Permalink