Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

STL_WLM_RULE_ACTION

Records details about actions resulting from WLM query monitoring rules associated with user-defined queues. For more information, see WLM Query Monitoring Rules.

This table is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of Data in System Tables and Views.

Table Columns

Column Name Data Type Description
userid integer User that ran the query.
query integer Query ID.
service_class integer ID for the WLM query queue (service class). Query queues are defined in the WLM configuration. Service classes greater than 5 are user-defined queues.
rule character(256) Name of a query monitoring rule.
action character(256)

Resulting action. Possible values are:

  • log

  • hop(reassign)

  • hop(restart)

  • abort

  • none

A value of none indicates that the rule’s predicates were met but the action was superseded by another rule with a higher severity action.

recordtime timestamp Time the action was logged.

Sample Queries

The following example finds queries that were aborted by a query monitoring rule.

Copy
Select query, rule from stl_wlm_rule_action where action = 'abort' order by query;