MONITORING_EVENTS
Reports significant events that can affect database performance and functionality if you do not address their root causes.
See Monitoring Events in the Administrator's Guide for details.
Column Name | Data Type | Description |
---|---|---|
NODE_NAME |
VARCHAR |
Name of the node that is reporting the requested information. |
EVENT_CODE |
INTEGER |
Numeric identifier that indicates the type of event. See Event Types in Monitoring Events in the Administrator's Guide for a list of event type codes. |
EVENT_ID |
INTEGER |
Unique numeric ID that identifies the specific event. |
EVENT_SEVERITY |
VARCHAR |
Severity of the event from highest to lowest. These events are based on standard syslog severity types:
|
EVENT_POSTED_TIMESTAMP |
TIMESTAMPTZ |
When this event was posted. |
EVENT_CLEARED_TIMESTAMP |
TIMESTAMPTZ |
When this event was cleared. Note: You can also query the ACTIVE_EVENTS system table to see events that have not been cleared. |
EVENT_EXPIRATION |
TIMESTAMPTZ |
Time at which this event expires. If the same event is posted again prior to its expiration time, this field gets updated to a new expiration time. |
EVENT_CODE_DESCRIPTION |
VARCHAR |
Brief description of the event and details pertinent to the specific situation. |
EVENT_PROBLEM_DESCRIPTION |
VARCHAR |
Generic description of the event. |