CONFIGURATION_CHANGES

Records the change history of system configuration parameters.

Records the change history of system configuration parameters. This information is useful for identifying:

  • Who changed the configuration parameter value

  • When the configuration parameter was changed

  • Whether nonstandard settings were in effect in the past

Column Name Data Type Description
EVENT_TIMESTAMP TIMESTAMPTZ Time when the row was recorded.
NODE_NAME VARCHAR Name of the node that is reporting the requested information.
USER_ID INTEGER Identifier of the user who changed configuration parameters.
USER_NAME VARCHAR Name of the user who changed configuration parameters at the time Vertica recorded the session.
SESSION_ID VARCHAR Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
PARAMETER VARCHAR Name of the changed parameter. See Configuration parameters for a detailed list of supported parameters.
VALUE VARCHAR New value of the configuration parameter.

Privileges

Superuser