v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

SHOW

Synopsis

Use the SHOW statement to display the value of a run-time parameter.

Syntax

show_stmt ::= SHOW { run_time_parameter | ALL }

show_stmt

SHOWrun_time_parameterALL

Semantics

The parameter values in YSQL can be set and typically take effect the same way as in PostgreSQL. However, because YugabyteDB uses a different storage engine (DocDB), many configurations related to the storage layer will not have the same effect in YugabyteDB as in PostgreSQL. For example, configurations related to connection and authentication, query planning, error reporting and logging, run-time statistics, client connection defaults, and so on, should work as in PostgreSQL.

However, configurations related to write ahead log, vacuuming, or replication, may not apply to Yugabyte. Instead related configuration can be set using yb-tserver (or yb-master) configuration flags.

run_time_parameter

Specify the name of the parameter to be displayed.

ALL

Show the values of all configuration parameters, with descriptions.

See also