SHOW SESSION
Displays configuration parameter values that are set for the current session. If you specify a parameter that is not set, SHOW SESSION
returns an empty row for that parameter.
If the configuration parameter is set but requires a database restart to take effect, the value shown might differ from the active value.
Syntax
SHOW SESSION { ALL | UDPARAMETER ALL }
Parameters
ALL |
Shows all Vertica configuration parameters set at the session level. |
UDPARAMETER ALL | Shows all parameters defined by user-defined extensions. These parameters are not shown in the CONFIGURATION_PARAMETERS table. |
Privileges
None
Examples
View all Vertica configuration parameters and their settings for the current session. User-defined parameters are not included:
=> SHOW SESSION 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 | America/New_York 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 | dbduser*, dbadmin*, pseudosuperuser* available roles | dbduser*, dbadmin*, pseudosuperuser* ForceUDxFencedMode | 1 (17 rows)