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 }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)