Product Documentation

Appearance

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.

yellowbrick=# 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                            | UTC             | Sets the time zone for displaying and interpreting time stamps.
 transaction_isolation               | read committed  | Sets the current transaction's isolation level.
 yb_last_execid                      | 3204465         | Shows the execution-id of the last backend query run in this session.
 yb_server_version                   | 5.2.13          | Shows the Yellowbrick Database server version.
 yb_server_version_num               | 50213           | Shows the Yellowbrick Database server version as an integer.
 ybd_analyze_after_loads             | on              | Enable or disable immediate ANALYZE after a successful load (default is on)
 ybd_analyze_after_writes            | on              | Enable or disable immediate ANALYZE after write operations such as INSERT INTO SELECT and CTAS
 ybd_query_tags                      |                 | Sets the optional query tags to be stored in query history.
(21 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

Parent topic:SQL Commands