Documentation

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

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)
--tls-caPath to a custom TLS certificate authority (for testing or self-signed certificates)
-h--helpPrint help information
--help-allPrint detailed 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

New in InfluxDB 3.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: