View partition information

InfluxDB Clustered stores partition information in InfluxDB 3 system tables. Query partition information to view partition templates and verify partitions are working as intended.

• Query partition information from system tables
• Partition-related queries

Query partition information from system tables

Use the influxctl query command and SQL to query partition-related information from InfluxDB system tables. Provide the following:

• Enable system tables with the --enable-system-tables command flag.

• Database token: A database token with read permissions on the specified database. Uses the token setting from the influxctl connection profile or the --token command flag.

• Database name: The name of the database to query information about. Uses the database setting from the influxctl connection profile or the --database command flag.

• SQL query: The SQL query to execute. Pass the query in one of the following ways:

  • a string on the command line
  • a path to a file that contains the query
  • a single dash (-) to read the query from stdin

influxctl query \
  --enable-system-tables \
  --database 
DATABASE_NAME
 \
  --token 
DATABASE_TOKEN
 \
  "
SQL_QUERY
"

Replace the following:

• DATABASE_TOKEN: A database token with read access to the specified database
• DATABASE_NAME: The name of the database to query information about.
• SQL_QUERY: The SQL query to execute. For examples, see System query examples.

When prompted, enter y to acknowledge the potential impact querying system tables may have on your cluster.

Partition-related queries

Use the following queries to return information about partitions in your InfluxDB cluster.

• View partition templates of all tables
• View the partition template of a specific table
• View all partitions for a table
• View the number of partitions per table
• View the number of partitions for a specific table

In the examples below, replace TABLE_NAME with the name of the table you want to query information about.

View the partition template of a specific table

SELECT * FROM system.tables WHERE table_name = '
TABLE_NAME
'

Example results

View all partitions for a table

SELECT * FROM system.partitions WHERE table_name = '
TABLE_NAME
'

Example results

View the number of partitions per table

SELECT
  table_name,
  COUNT(*) AS partition_count
FROM
  system.partitions
WHERE
  table_name IN ('
TABLE_NAME_1
', '
TABLE_NAME_2
', '
TABLE_NAME_3
')
GROUP BY
  table_name

Example results

View the number of partitions for a specific table

SELECT
  COUNT(*) AS partition_count
FROM
  system.partitions
WHERE
  table_name = '
TABLE_NAME
'

Example results