influxdb3 show retention

The influxdb3 show retention command displays effective retention periods for tables in your InfluxDB 3 Core server.

Usage

influxdb3 show retention [OPTIONS]

Options

Option environment variables

You can use the following environment variables to set command options:

Examples

• Show retention for all tables
• Show retention for a specific database
• Show retention in JSON format

Show retention for all tables

influxdb3 show retention \
  --host http://localhost:8181 \
  --token YOUR_AUTH_TOKEN

Show retention for a specific database

influxdb3 show retention \
  --host http://localhost:8181 \
  --token YOUR_AUTH_TOKEN \
  --database mydb

Show retention in JSON format

influxdb3 show retention \
  --host http://localhost:8181 \
  --token YOUR_AUTH_TOKEN \
  --format json

Output

The command displays the following information for each table:

• Database: The database name
• Table: The table name
• Retention: The effective retention period in human-readable format (for example, “7d” for 7 days, “24h” for 24 hours, “infinite” for no retention)
• Source: Where the retention is defined (table, database, or infinite)

Example output

Database | Table       | Retention | Source
---------|-------------|-----------|----------
mydb     | cpu         | 7d        | database
mydb     | mem         | 24h       | table
mydb     | disk        | infinite  | infinite

Tables with table-level retention policies override the database-level retention. Tables without explicit retention policies inherit the database retention or have infinite retention if none is set.