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.