MONITORING_EVENTS
Reports significant events that can affect database performance and functionality if you do not address their root causes.
Reports significant events that can affect database performance and functionality if you do not address their root causes.
See Monitoring events 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 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. |
Privileges
Superuser