Product Documentation

Appearance

sys.wlm_active_profile ​

This view returns the current list of available WLM profiles, identifies the currently active profile, and names the default pool for each profile. For example, the shortquerybias profile is activated in this case:

yellowbrick=# select * from sys.wlm_active_profile;
           name            | active |       default_pool       
----------------------------+--------+--------------------------
 maintenance                | f      | maintenance
 default                    | f      | large
 throttling_testing_profile | f      | throttling_resource_pool
 flex                       | f      | mix
 profile_one                | f      | profile_one_pool_a
 verification_profile       | f      | verification_pool_a
 shortquerybias             | t      | shortquerypool
(7 rows)

Note: This view always returns rows for the default, flex, and maintenance profiles.

Parent topic:System Views