Vertica SHOW command
Displays run-time parameters for the current. No special permision is required to be able to do this action.
Syntax
SHOW { name | ALL }dbadmin=> show all;
name | setting
-----------------------------+---------------------------------------------------
locale | en_US@collation=binary (LEN_KBINARY)
autocommit | off
standard_conforming_strings | on
escape_string_warning | on
datestyle | ISO, MDY
intervalstyle | plain
timezone | Brazil/East
search_path | "$user", public, v_catalog, v_monitor, v_internal
transaction_isolation | READ COMMITTED
transaction_read_only | false
resource_pool | general
memorycap | UNLIMITED
tempspacecap | UNLIMITED
runtimecap | UNLIMITED
enabled roles | dbadmin*, pseudosuperuser*
available roles | dbadmin*, pseudosuperuser*
(16 rows)
Time: First fetch (16 rows): 1,496 ms. All rows formatted: 1,603 ms
| AUTOCOMMIT | Displays whether statements automatically commit their transactions when they complete. |
| AVAILABLE_ROLES | Lists all roles available to the user. |
| DATESTYLE | Displays the current style of date values |
| ENABLED_ROLES | Displays the roles enabled for the current session. |
| ESCAPE_STRING_WARNING | Displays whether warnings are issued when backslash escapes are found in strings. |
| INTERVALSTYLE | Displays whether units are output when printing intervals. |
| LOCALE | Displays the current locale. |
| MEMORYCAP | Displays the maximum amount of memory that any request use. |
| RESOURCE_POOL | Displays the resource pool that the session is using. |
| RUNTIMECAP | Displays the maximum amount of time that queries can run in the session. |
| SEARCH_PATH | Displays the order in which Vertica searches schemas. |
| SESSION_CHARACTERISTICS | Displays the transaction characteristics. |
| STANDARD_CONFORMING_STRINGS | Displays whether backslash escapes are enabled for the session.. |
| TEMPSPACECAP | Displays the maximum amount of temporary file space that queries can use in the session. |
| TIMEZONE | Displays the timezone set in the current session. |
| TRANSACTION_ISOLATION | Displays the current transaction isolation setting. |
| TRANSACTION_READ_ONLY | Displays the current setting. |
| ALL | Shows all run-time parameters. |
dbadmin=> show timezone;
name | setting
----------+-------------
timezone | Brazil/East
(1 row)dbadmin=> show resource_pool;
name | setting
---------------+---------
resource_pool | general
(1 row)