View partition information
InfluxDB Cloud Dedicated stores partition information in InfluxDB v3 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 v3 system tables. Querying system tables may impact the overall write and query performance of your InfluxDB Cloud Dedicated 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 August 22, 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-tablescommand flag.Database token: A database token with read permissions on the specified database. Uses the
tokensetting from theinfluxctlconnection profile or the--tokencommand flag.Database name: The name of the database to query information about. Uses the
databasesetting from theinfluxctlconnection profile or the--databasecommand 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 databaseDATABASE_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 Cloud Dedicated 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 partition templates of all tables
SELECT * FROM system.tables
Example results
| table_name | partition_template |
|---|---|
| weather | {"parts":[{"timeFormat":"%Y-%m-%d"},{"bucket":{"tagName":"location","numBuckets":250}}]} |
| home | {"parts":[{"timeFormat":"%Y-%m-%d"},{"tagValue":"room"},{"tagValue":"sensor_id"}]} |
| numbers | {"parts":[{"timeFormat":"%Y"}]} |
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 the partition template of a specific table
SELECT * FROM system.tables WHERE table_name = 'TABLE_NAME'
Example results
| table_name | partition_template |
|---|---|
| weather | {"parts":[{"timeFormat":"%Y-%m-%d"},{"bucket":{"tagName":"location","numBuckets":250}}]} |
View all partitions for a table
SELECT * FROM system.partitions WHERE table_name = 'TABLE_NAME'
Example results
| partition_id | table_name | partition_key | last_new_file_created_at | num_files | total_size_mb |
|---|---|---|---|---|---|
| 1362 | weather | 43 | 2020-05-27 | 1683747418763813713 | 1 | 0 |
| 800 | weather | 234 | 2021-08-02 | 1683747421899400796 | 1 | 0 |
| 630 | weather | 325 | 2022-03-17 | 1683747417616689036 | 1 | 0 |
| 1401 | weather | 12 | 2021-01-09 | 1683747417786122295 | 1 | 0 |
| 1012 | weather | 115 | 2022-07-04 | 1683747417614219148 | 1 | 0 |
View the number of partitions per table
SELECT
table_name,
COUNT(*) AS partition_count
FROM
system.partitions
GROUP BY
table_name
Example results
| table_name | partition_count |
|---|---|
| weather | 1096 |
| home | 24 |
| numbers | 1 |
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_name | partition_count |
|---|---|
| weather | 1096 |
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.