Comandă SHOW in Vertica

Afișează parametrii de execution. Nu e nevoie de nici o permisiune specială pentru a putea face aceasta actiune.

Sintaxa:
SHOW { name | ALL }
Parametri
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
Lista de parametri și descrierea lor:

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.

Exemple de cum putem folosi comanda "SHOW", în Vertica:
  • Vezi valoare parametru timezone:
  • dbadmin=> show timezone;
       name   |   setting
    ----------+-------------
     timezone | Brazil/East
    (1 row)
  • Vezi resource_pool căre este utilizat de către esiune:
  • dbadmin=> show resource_pool;
         name      | setting
    ---------------+---------
     resource_pool | general
    (1 row)