influxdb3 show system table
InfluxDB 3 Enterprise is in Public Alpha
InfluxDB 3 Enterprise is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.
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 ) | |
-h | --help | Print 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 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.