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.