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)