

 Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# STL\_WLM\_RULE\_ACTION
<a name="r_STL_WLM_RULE_ACTION"></a>

Records details about actions resulting from WLM query monitoring rules associated with user-defined queues. For more information, see [WLM query monitoring rules](cm-c-wlm-query-monitoring-rules.md).

STL\_WLM\_RULE\_ACTION 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](cm_chap_system-tables.md#c_visibility-of-data).

## Table columns
<a name="r_STL_WLM_RULE_ACTION-table-columns"></a>


| Column name  | Data type  | Description  | 
| --- | --- | --- | 
| userid | integer | User that ran the query. | 
| query  | integer  | Query ID.  | 
| service\_class  | integer  | ID for the 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 as follows:[See the AWS documentation website for more details](http://docs.aws.amazon.com/redshift/latest/dg/r_STL_WLM_RULE_ACTION.html)<br />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 in UTC. | 
| action\_value | character(256) | If action is change\_query\_priority, then possible values are highest, high, normal, low, and lowest. If `action` is `log`, `hop`, or `abort` then the value is empty.  | 
| service\_class\_name | character(64) | The name of the service class.  | 

## Sample queries
<a name="r_STL_WLM_RULE_ACTION-sample-queries"></a>

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

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