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)