influxdb3 show system table
The influxdb3 show system table command queries data from a system table.
Usage
influxdb3 show system --database <DATABASE_NAME> table [OPTIONS] <SYSTEM_TABLE>
Arguments
- SYSTEM_TABLE: the system table to query
Options
| Option | Description | |
|---|---|---|
-l | --limit | Maximum number of tables entries to display (default is 10, 0 indicates no limit) |
-o | --order-by | Order by the specified columns |
-s | --select | Select specific columns from the system table |
--format | Output format (pretty (default), json, jsonl, csv, or parquet) | |
--tls-ca | Path to a custom TLS certificate authority (for testing or self-signed certificates) | |
-h | --help | Print help information |
--help-all | Print detailed help information |
Examples
- Query a system table
- Query specific columns from a system table
- Query a system table and order by a specific column
- Query a system table and return JSON-formatted output
In the examples below, replace
DATABASE_NAME with
the name of the database to operate on.
Query a system table
# Query the parquet_files system table
influxdb3 show system --database DATABASE_NAME table parquet_files
Query specific columns from a system table
# Select specific columns from the parquet_files system table
influxdb3 show system \
--database DATABASE_NAME \
table \
--select table_name,size_bytes,row_count \
parquet_files
Query a system table and order by a specific column
influxdb3 show system \
--database DATABASE_NAME \
table \
--order-by size_bytes,row_count \
parquet_files
Query a system table and return JSON-formatted output
influxdb3 show system \
--database DATABASE_NAME \
table \
--format json \
parquet_files
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 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.