Vertica SHOW command

Displays run-time parameters for the current. No special permission 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)