Skip to content

SHOW

Show the current value of a configuration parameter or show the current 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.4.0
(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.
 block_size                          | 32768                            | Shows the size of a disk block.
 bytea_output                        | hex                              | Sets the output format for bytea.
 client_encoding                     | UTF8                             | Sets the client's character set encoding.
 client_min_messages                 | warning                          | Sets the message levels that are sent to the client.
 DateStyle                           | ISO, MDY                         | Sets the display format for date and time values.
 enable_alternative_round            | on                               | Translates round to round_var which allows for a non const second argument
 enable_silent_coerce                | off                              | Enables silent and lossy coerces.
 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.
 listen_addresses                    | *                                | Sets the host name or IP address(es) to listen to.
 log_timezone                        | UTC                              | Sets the time zone to use in log messages.
 max_connections                     | 2300                             | Sets the maximum number of concurrent connections.
 max_index_keys                      | 32                               | Shows the maximum number of index keys.
 max_user_connections                | 2000                             | Sets the maximum number of concurrent user connections.
 max_wal_size                        | 16GB                             | Sets the WAL size that triggers a checkpoint.
 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.
 ssl                                 | on                               | Enables SSL connections.
 ssl_ca_dir                          | /mnt/ybdata/certs/trust-database | Location of the SSL certificate authority directory.
 ssl_cert_file                       | /mnt/ybdata/certs/ybd.crt        | Location of the SSL server certificate file.
 ssl_ciphers                         | ECDHE:!3DES:!DES:!NULL:!RC4      | Sets the list of allowed SSL ciphers.
 ssl_key_file                        | /mnt/ybdata/certs/ybd.key        | Location of the SSL server private key file.
 ssl_prefer_server_ciphers           | on                               | Give priority to server ciphersuite order.
 statement_timeout                   | 0                                | Sets the maximum allowed duration in milliseconds of any statement.
 tcp_keepalives_count                | 10                               | Maximum number of TCP keepalive retransmits.
 tcp_keepalives_idle                 | 10                               | Time between issuing TCP keepalives.
 tcp_keepalives_interval             | 1                                | Time between TCP keepalive retransmits.
 TimeZone                            | UTC                              | Sets the time zone for displaying and interpreting time stamps.
 transaction_isolation               | read committed                   | Sets the current transaction's isolation level.
 wal_block_size                      | 8192                             | Shows the block size in the write ahead log.
 wal_level                           | minimal                          | Set the level of information written to the WAL.
 yb_last_execid                      |                                  | Shows the execution-id of the last backend query run in this session.
 yb_server_version                   | 5.4.0                            | Shows the Yellowbrick Database server version.
 yb_server_version_num               | 50400                            | Shows the Yellowbrick Database server version as an integer.
 ybd_query_tags                      |                                  | Sets the optional query tags to be stored in query history.
(40 rows)

For more details about each parameter, see Configuration Parameters.

In This Section

Parent topic:SQL Commands