SHOW

Show the current value of a configuration parameter or show the values for all parameters.

SHOW parameter | ALL
For example:
premdb=> show search_path;
    search_path    
-------------------
 public, allpremdb
(1 row)
premdb=# show yb_server_version;
 yb_server_version 
-------------------
 5.2.4
(1 row)
SHOW ALL includes a description of each parameter.
premdb=# show all;
                name                 |       setting       |                              description                              
-------------------------------------+---------------------+-----------------------------------------------------------------------
 application_name                    | ybsql               | Sets the application name to be reported in statistics and logs.
 client_encoding                     | UTF8                | Sets the client's character set encoding.
 DateStyle                           | ISO, MDY            | Sets the display format for date and time values.
 extra_float_digits                  | 0                   | Sets the number of digits displayed for floating-point values.
 idle_in_transaction_session_timeout | 0                   | Sets the maximum allowed duration of any idling transaction.
 idle_session_timeout                | 0                   | Sets the maximum allowed session duration after any statement.
 lc_collate                          | C                   | Shows the collation order locale.
 lc_ctype                            | C                   | Shows the character classification and case conversion locale.
 lc_time                             | C                   | Sets the locale for formatting date and time values.
 max_index_keys                      | 32                  | Shows the maximum number of index keys.
 search_path                         | "$user", public     | Sets the schema search order for names that are not schema-qualified.
 server_encoding                     | LATIN9              | Sets the server (database) character set encoding.
 statement_timeout                   | 0                   | Sets the maximum allowed duration in milliseconds of any statement.
 TimeZone                            | America/Los_Angeles | Sets the time zone for displaying and interpreting time stamps.
 transaction_isolation               | read committed      | Sets the current transaction's isolation level.
 yb_last_execid                      | 1661546             | Shows the execution-id of the last backend query run in this session.
 yb_server_version                   | 5.2.4               | Shows the Yellowbrick Database server version.
 yb_server_version_num               | 50204               | Shows the Yellowbrick Database server version as an integer.
 ybd_query_tags                      |                     | Sets the optional query tags to be stored in query history.
(19 rows)

Note that running show idle_session_timeout or show idle_in_transaction_session_timeout as a superuser will always return unlimited (0), which is the superuser's setting, not the default setting for the appliance.

The following parameters cannot be changed (by superusers or regular users):
  • lc_collate
  • lc_ctype
  • lc_time
  • server_encoding
  • yb_last_execid
  • yb_server_version
  • yb_server_version_num