Product DocumentationAppearance
sys.log_query_alert
Log alerts that are triggered specifically by WLM rules that have a Log ERROR or Log WARN action.
| Column Name | Data Type | Description |
|---|---|---|
| alert_id | uuid | Unique ID for the alert. |
| query_id | bigint | Unique query ID associated with this alert. |
| alert_time | timestamptz | Timestamp when the alert occurred. |
| acknowledged | boolean | Whether the user has acknowledged the alert on the SMC Manage Query Alerts screen, where this data is also visible. |
| source | varchar(255) | The name of the WLM rule that triggered the alert. |
| severity | integer | Severity gradient, where 0=OK, 25=Informational, 50=Minor, 75=Major, 100=Critical. |
| message | varchar(63488) | Text of the alert. |
For example:
premdb=# select * from sys.log_query_alert;
alert_id | query_id | alert_time | acknowledged | source | severity | message
--------------------------------------+----------+----------------------------+--------------+-------------------+----------+---------------
e44d60f0-5cab-48da-b0d0-77e7262cf809 | 49040 | 2018-09-11 14:55:04.421-07 | f | Bob's premdb rule | 50 | premdb query!
17e4a5d0-c985-4627-8397-0b0691e3a6f4 | 48998 | 2018-09-11 14:55:04.356-07 | f | Bob's premdb rule | 50 | premdb query!
6830c650-a5a8-4c33-af7e-705fbdd6ee0e | 52054 | 2018-09-11 14:57:20.431-07 | f | Bob's premdb rule | 50 | premdb query!
02fb578d-bb94-4324-9af1-5e58c11c61c2 | 49029 | 2018-09-11 14:55:04.394-07 | f | Bob's premdb rule | 50 | premdb query!
(4 rows)Parent topic:System Views