STV_WLM_CLASSIFICATION_CONFIG - Amazon Redshift

STV_WLM_CLASSIFICATION_CONFIG

Contains the current classification rules for WLM.

STV_WLM_CLASSIFICATION_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
id integer Service class ID. For a list of service class IDs, see WLM service class IDs.
condition character(128) Query conditions.
action_seq integer Reserved for system use.
action character(64) Reserved for system use.
action_service_class integer The service class where the action takes place.

Sample query

select * from STV_WLM_CLASSIFICATION_CONFIG; id | condition | action_seq | action | action_service_class ---+---------------------------------------------+------------+--------+--------------------- 1 | (system user) and (query group: health) | 0 | assign | 1 2 | (system user) and (query group: metrics) | 0 | assign | 2 3 | (system user) and (query group: cmstats) | 0 | assign | 3 4 | (system user) | 0 | assign | 4 5 | (super user) and (query group: superuser) | 0 | assign | 5 6 | (query group: querygroup1) | 0 | assign | 6 7 | (user group: usergroup1) | 0 | assign | 6 8 | (user group: usergroup2) | 0 | assign | 7 9 | (query group: querygroup3) | 0 | assign | 8 10 | (query group: querygroup4) | 0 | assign | 9 11 | (user group: usergroup4) | 0 | assign | 9 12 | (query group: querygroup*) | 0 | assign | 10 13 | (user group: usergroup*) | 0 | assign | 10 14 | (querytype: any) | 0 | assign | 11 (4 rows)