SHOW CURRENT
Displays active configuration parameter values that are set at all levels. Vertica first checks values set at the session level. If a value is not set for a configuration parameter at the session level, Vertica next checks if the value is set for the node where you are logged in, and then checks the database level. If no values are set, SHOW CURRENT shows the default value for the configuration parameter. If the configuration parameter requires a restart to take effect, the active values shown might differ from the set values.
Syntax
SHOW CURRENT { parameter‑name[,…] | ALL }
Parameters
| parameter‑name |
Names of any configuration parameters you want to show. |
|
|
Shows all configuration parameters set at all levels. |
Privileges
- Superusers only
- Non-superusers:
SHOW CURRENT ALLreturns masked parameter settings. Attempts to view specific parameter settings return an error.
Examples
Show configuration parameters and their settings at all levels.
=> SHOW CURRENT ALL;
level | name |setting ---------+---------------------------+--------- DEFAULT | ActivePartitionCount | 1 DEFAULT | AdvanceAHMInterval | 180 DEFAULT | AHMBackupManagement | 0 DATABASE | AnalyzeRowCountInterval | 3600 SESSION | ForceUDxFencedMode | 1 NODE | MaxClientSessions | 0 ...
