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 }
Parameters
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
Table of parameters and their description:
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.
Examples of use of "SHOW" command in Vertica:
  • See timezone parameter value:
  • dbadmin=> show timezone;
       name   |   setting
    ----------+-------------
     timezone | Brazil/East
    (1 row)
  • See resource_pool that is in use by it's session:
  • dbadmin=> show resource_pool;
         name      | setting
    ---------------+---------
     resource_pool | general
    (1 row)