SHOW

Shows run-time parameters for the current session.

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)