influxd inspect report-db

The influxd inspect report-db command analyzes an InfluxDB bucket and reports the cardinality of data stored in the bucket.

Usage

1. influxd inspect report-db [flags]

Flags

Flag Description Input Type
—c Worker concurrency (default is 1). integer
—db-path (Required) Path to InfluxDB data directory. string
—detailed Include field and tag counts in output.
—exact Report exact counts.
-h —help View help for the report-db command.
—rollup Rollup level: t (total), b (bucket), r (retention policy), or m (measurement) (default). string

Examples

Report the cardinality of measurements in all buckets

1. # Syntax
2. influxd inspect report-db --db-path <influxdb-data-directory>

4. # Example
5. influxd inspect report-db --db-path ~/.influxdbv2/engine/data

Report the cardinality of measurements in a specific bucket

1. # Syntax
2. influxd inspect report-db --db-path <influxdb-data-directory>/<bucket-id>

4. # Example
5. influxd inspect report-db --db-path ~/.influxdbv2/engine/data/000xX00xxXx000x0

Report the cardinality of all buckets

  • Use the --db-path flag to provide the path to your InfluxDB data directory.
  • Use the --rollup flag with the value, b, to return a bucket-level summary of cardinality.
1. # Syntax
2. influxd inspect report-db \
3. --db-path <influxdb-data-directory> \
4. --rollup b

6. # Example
7. influxd inspect report-db \
8. --db-path ~/.influxdbv2/engine/data \
9. --rollup b

Report the cardinality of all retention policies

  • Use the --db-path flag to provide the path to your InfluxDB data directory.
  • Use the --rollup flag with the value, r, to return a retention-policy-level summary of cardinality.
1. # Syntax
2. influxd inspect report-db \
3. --db-path <influxdb-data-directory> \
4. --rollup r

6. # Example
7. influxd inspect report-db \
8. --db-path ~/.influxdbv2/engine/data \
9. --rollup r

Report the total cardinality of your InfluxDB instance

  • Use the --db-path flag to provide the path to your InfluxDB data directory.
  • Use the --rollup flag with the value, t, to return a summary of total cardinality.
1. # Syntax
2. influxd inspect report-db \
3. --db-path <influxdb-data-directory> \
4. --rollup t

6. # Example
7. influxd inspect report-db \
8. --db-path ~/.influxdbv2/engine/data \
9. --rollup t

Include tag and field counts in your cardinality summary

  • Use the --db-path flag to provide the path to your InfluxDB data directory.
  • Include the --detailed flag to return detailed cardinality summaries with tag and field counts.
1. # Syntax
2. influxd inspect report-db \
3. --db-path <influxdb-data-directory> \
4. --detailed

6. # Example
7. influxd inspect report-db \
8. --db-path ~/.influxdbv2/engine/data \
9. --detailed

cardinality inspect