influxdb3 show retention

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

Usage

# Syntax
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
• Export retention data to Parquet format

In the examples below, replace AUTH_TOKEN with your authentication token.

Show retention for all tables

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

Show retention for a specific database

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

Show retention in JSON format

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

Export retention data to Parquet format

Parquet is a binary format. When using the parquet format, data is written to standard output by default. Use output redirection or the --output option to save the data to a file.

influxdb3 show retention \
  --host http://localhost:8181 \
  --token 
AUTH_TOKEN
 \
  --format parquet \
  --output retention-data.parquet

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.