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 USER: Displays configuration parameters set for the specified user, and for all users.
-
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 several system tables for configuration parameters:
-
SESSION_PARAMETERS returns session-scope parameters.
-
CONFIGURATION_PARAMETERS returns parameters for all scopes: database, node, and session.
-
USER_CONFIGURATION_PARAMETERS provides information about user-level configuration parameters that are in effect for database users.