Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
STV_WLM_QMR_CONFIG
Records the configuration for WLM query monitoring rules (QMR). For more information, see WLM query monitoring rules.
STV_WLM_QMR_CONFIG is visible only to superusers. For more information, see Visibility of data in system tables and views.
Table columns
Column name | Data type | Description |
---|---|---|
service_class | integer | ID for the WLM query queue (service class). Query queues are defined in the WLM configuration. Rules can be defined only for user-defined queues. For a list of service class IDs, see WLM service class IDs. |
rule_name | character(256) | Name of the query monitoring rule. |
action | character(256) | Rule action. Possible values
are log , hop , abort , and change_query_priority .
|
metric_name | character(256) | Name of the metric. |
metric_operator | character(256) | The metric operator. Possible values are >, =, <. |
metric_value | double | The threshold value for the specified metric that triggers an action. |
action_value | character(256) | If action is change_query_priority , then possible values are highest , high , normal , low , and lowest .
If |
Sample query
To view the QMR rule definitions for all service classes greater than 5 (which includes user-defined queues), run the following query. For a list of service class IDs, see WLM service class IDs.
Select * from stv_wlm_qmr_config where service_class > 5 order by service_class;