Documentation

influxdb3 show system table

InfluxDB 3 Core is in Public Alpha

InfluxDB 3 Core 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.

Alpha expectations and recommendations

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

OptionDescription
-l--limitMaximum number of tables entries to display (default is 10, 0 indicates no limit)
-o--order-byOrder by the specified columns
-s--selectSelect specific columns from the system table
--formatOutput format (pretty (default), json, jsonl, csv, or parquet)
-h--helpPrint help information

Examples

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!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

InfluxDB 3 Open Source Now in Public Alpha

InfluxDB 3 Open Source is now available for alpha testing, licensed under MIT or Apache 2 licensing.

We are releasing two products as part of the alpha.

InfluxDB 3 Core, is our new open source product. It is a recent-data engine for time series and event data. InfluxDB 3 Enterprise is a commercial version that builds on Core’s foundation, adding historical query capability, read replicas, high availability, scalability, and fine-grained security.

For more information on how to get started, check out: