Viewing Configuration Parameter Values
You can view active configuration parameter values in two ways:
SHOW Statements
Use the following SHOW
statements to view active configuration parameters:
SHOW CURRENT
: Returns settings of active configuration parameter values. Vertica checks settings at all levels, in the following ascending order of precedence:- session
- node
- database
If no values are set at any scope,
SHOW CURRENT
returns the parameter's default value.SHOW DATABASE
: Displays configuration parameter values set for the database.SHOW SESSION
: Displays configuration parameter values set for the current session.SHOW NODE
: Displays configuration parameter values set for a node.
If a configuration parameter requires a restart to take effect, the values in a SHOW CURRENT
statement might differ from values in other SHOW
statements. To see which parameters require restart, query the CONFIGURATION_PARAMETERS
system table.
System Tables
You can query two system tables for configuration parameters:
SESSION_PARAMETERS
returns session-scope parameters.CONFIGURATION_PARAMETERS
returns parameters for all scopes: database, node, and session.