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
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.