Product Documentation

Appearance

All platforms

sys.wlm_active_rule ​

This view returns the currently active WLM rules and identifies the JavaScript expression for each rule, rule type, and other attributes. See sys.wlm_pending_rule for a description of the columns.

Example ​

For example:

yellowbrick=# select * from sys.wlm_active_rule where rule_type='submit';
  profile_name  |     rule_name     | rule_type | order | enabled | superuser |                             expression                             
----------------+-------------------+-----------+-------+---------+-----------+--------------------------------------------------------------------
 shortquerybias | limit_concurrency | submit    |     1 | t       | f         | if (w.user === 'sqb') {                                           +
               |                   |           |       |         |           |         wlm.throttle(2, w.application);                           +
               |                   |           |       |         |           | }
 shortquerybias | log_premdb        | submit    |   100 | t       | f         |  if (w.database === 'premdb') {log.info('premdb query executed');}
(2 rows)