Documentation

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.

Querying system tables may impact overall cluster performance

Partition information is stored in InfluxDB 3 system tables. Querying system tables may impact the overall write and query performance of your InfluxDB cluster.

System tables are subject to change

System tables are not part of InfluxDB’s stable API and may change with new releases. The provided schema information and query examples are valid as of September 24, 2024. If you detect a schema change or a non-functioning query example, please submit an issue.

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.

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


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

table_namepartition_template
weather{"parts":[{"timeFormat":"%Y-%m-%d"},{"bucket":{"tagName":"location","numBuckets":250}}]}

If a table doesn’t include a partition template in the output of this command, the table uses the default (1 day) partition strategy and doesn’t partition by tags or tag buckets.

View all partitions for a table

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

Example results

partition_idtable_namepartition_keylast_new_file_created_atnum_filestotal_size_mb
1362weather43 | 2020-05-27168374741876381371310
800weather234 | 2021-08-02168374742189940079610
630weather325 | 2022-03-17168374741761668903610
1401weather12 | 2021-01-09168374741778612229510
1012weather115 | 2022-07-04168374741761421914810

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

table_namepartition_count
weather1096
home24
numbers1

View the number of partitions for a specific table

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

Example results

table_namepartition_count
weather1096

Was this page helpful?

Thank you for your feedback!


New in InfluxDB 3.5

Key enhancements in InfluxDB 3.5 and the InfluxDB 3 Explorer 1.3.

See the Blog Post

InfluxDB 3.5 is now available for both Core and Enterprise, introducing custom plugin repository support, enhanced operational visibility with queryable CLI parameters and manual node management, stronger security controls, and general performance improvements.

InfluxDB 3 Explorer 1.3 brings powerful new capabilities including Dashboards (beta) for saving and organizing your favorite queries, and cache querying for instant access to Last Value and Distinct Value caches—making Explorer a more comprehensive workspace for time series monitoring and analysis.

For more information, check out:

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On November 3, 2025, the latest tag for InfluxDB Docker images will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments.

If using Docker to install and run InfluxDB, the latest tag will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments. For example, if using Docker to run InfluxDB v2, replace the latest version tag with a specific version tag in your Docker pull command–for example:

docker pull influxdb:2