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. |
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) |
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* (19 rows)