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


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 (service classes greater than 5).
rule_name character(256) Name of the query monitoring rule.
action character(256) Rule action. Possible values are log, hop, abort.
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.

Sample Query

To view the QMR rule definitions for all user-defined queues (service classes greater than 5), run the following query.

Select * from stv_wlm_qmr_config where service_class > 5 order by service_class;

On this page: