SHOW

Shows run-time parameters for the current session.

Syntax

SHOW { parameter | ALL }

Parameters

ALL

Shows all run-time settings.

AUTOCOMMIT

Returns on/off to indicate whether statements automatically commit their transactions when they complete.

AVAILABLE ROLES

Lists all roles available to the user.

AVAILABLE WORKLOADS

Returns the workloads available to the user and their enabled roles.

DATESTYLE

Shows the current style of date values. See SET DATESTYLE.

ENABLED ROLES

Shows the roles enabled for the current session. See SET ROLE.

ESCAPE_STRING_WARNING

Returns on/off to indicate whether warnings are issued when backslash escapes are found in strings. See SET ESCAPE_STRING_WARNING.

GRACEPERIOD

Shows the session GRACEPERIOD set by SET SESSION GRACEPERIOD.

IDLESESSIONTIMEOUT

Shows how long the session can remain idle before it times out.

INTERVALSTYLE

Shows whether units are output when printing intervals. See SET INTERVALSTYLE.

LOCALE

Shows the current locale. See SET LOCALE.

MEMORYCAP

Shows the maximum amount of memory that any request use. See SET MEMORYCAP.

MULTIPLEACTIVERESULTSETS

Returns on/off to indicate whether multiple active result sets on one connection are allowed. See SET SESSION MULTIPLEACTIVERESULTSETS.

RESOURCE POOL

Shows the resource pool that the session is using. See SET RESOURCE POOL.

RUNTIMECAP

Shows the maximum amount of time that queries can run in the session. See SET RUNTIMECAP.

SEARCH_PATH

Shows the order in which Vertica searches schemas. See SET SEARCH_PATH. For example:

=> SHOW SEARCH_PATH;
    name     |                      setting
-------------+---------------------------------------------------
 search_path | "$user", public, v_catalog, v_monitor, v_internal
(1 row)
  

STANDARD_CONFORMING_STRINGS

Shows whether backslash escapes are enabled for the session. See SET STANDARD_CONFORMING_STRINGS.

TEMPSPACECAP

Shows the maximum amount of temporary file space that queries can use in the session. See SET TEMPSPACECAP.

TIMEZONE

Shows the timezone set in the current session. See SET TIMEZONE.

TRANSACTION_ISOLATION

Shows the current transaction isolation setting, as described in SET SESSION CHARACTERISTICS AS TRANSACTION. For example:

=> SHOW TRANSACTION_ISOLATION;
         name          |    setting
-----------------------+----------------
 transaction_isolation | READ COMMITTED
(1 row)
  

TRANSACTION_READ_ONLY

Returns true/false to indicate the current read-only setting, as described in SET SESSION CHARACTERISTICS AS TRANSACTION. For example:

=> SHOW TRANSACTION_READ_ONLY;
         name          | setting
-----------------------+---------
 transaction_read_only | false
(1 row)
  

WORKLOAD

Shows the workloads associated with the current session.

Privileges

None

Examples

Display all current runtime parameter settings:

=> SHOW ALL;
            name             |                          setting
-----------------------------+-----------------------------------------------------------
 locale                      | en_US@collation=binary (LEN_KBINARY)
 autocommit                  | off
 standard_conforming_strings | on
 escape_string_warning       | on
 multipleactiveresultsets    | off
 datestyle                   | ISO, MDY
 intervalstyle               | plain
 timezone                    | America/New_York
 search_path                 | "$user", public, v_catalog, v_monitor, v_internal, v_func
 transaction_isolation       | READ COMMITTED
 transaction_read_only       | false
 resource_pool               | general
 memorycap                   | UNLIMITED
 tempspacecap                | UNLIMITED
 runtimecap                  | UNLIMITED
 idlesessiontimeout          | UNLIMITED
 graceperiod                 | UNLIMITED
 enabled roles               | dbduser*, dbadmin*, pseudosuperuser*
 available roles             | dbduser*, dbadmin*, pseudosuperuser*
 tcp_keepalive               | idle_time: [7200], probe_interval: [75], probe_count: [9]
 workload                    | analytics
(21 rows)