The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Reset Your Session

The SHOW commands “shows” run-time parameters for the current session.

dbadmin=> SHOW all;
            name             |                      setting
locale                      | [email protected]=binary (LEN_KBINARY)
autocommit                  | off
standard_conforming_strings | on
escape_string_warning       | on
multipleactiveresultsets    | off
datestyle                   | ISO, MDY
intervalstyle               | plain
timezone                    | US/Eastern
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
idlesessiontimeout          | UNLIMITED
graceperiod                 | UNLIMITED
enabled roles               | dbduser*, dbadmin*, pseudosuperuser*
available roles             | dbduser*, dbadmin*, pseudosuperuser*
(19 rows)

You can modify one or more of these parameters with the SET command.

dbadmin=> SET LOCALE TO en_GB;
INFO 2567:  Canonical locale: 'en_GB'
Standard collation: 'LEN'
English (United Kingdom)

dbadmin=> SET RUNTIMECAP = '1M';

dbadmin=> SHOW locale;
  name  |   setting
locale | en_GB (LEN)
(1 row)

dbadmin=> SHOW runtimecap;
    name    | setting
runtimecap | 00:01
(1 row)

To quickly reset all of the run-time parameters back to their default values, execute the RESET_SESSION function!

dbadmin=> SELECT reset_session();
Reset session: done.
(1 row)

dbadmin=> SHOW locale;
  name  |               setting
locale | [email protected]=binary (LEN_KBINARY)
(1 row)

dbadmin=> SHOW runtimecap;
    name    |  setting
runtimecap | UNLIMITED
(1 row)

Helpful Links:

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.