docs-v2/content/shared/influxdb3-cli/show/system/table.md

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 {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}} with the name of the database to operate on.

{{% code-placeholders "DATABASE_NAME" %}}

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

{{% /code-placeholders %}}