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

FlagDescriptionInput Type
—cWorker concurrency (default is 1).integer
—db-path(Required) Path to InfluxDB data directory.string
—detailedInclude field and tag counts in output.
—exactReport exact counts.
-h—helpView help for the report-db command.
—rollupRollup 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>
  3. # Example
  4. 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>
  3. # Example
  4. 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
  5. # Example
  6. influxd inspect report-db \
  7. --db-path ~/.influxdbv2/engine/data \
  8. --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
  5. # Example
  6. influxd inspect report-db \
  7. --db-path ~/.influxdbv2/engine/data \
  8. --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
  5. # Example
  6. influxd inspect report-db \
  7. --db-path ~/.influxdbv2/engine/data \
  8. --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
  5. # Example
  6. influxd inspect report-db \
  7. --db-path ~/.influxdbv2/engine/data \
  8. --detailed

cardinality inspect