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 flex profile is activated in this case:

premdb=# select * from sys.wlm_active_profile;
   name     | active | default_pool 
-------------+--------+--------------
 bar         | f      | bar: mix
 default     | f      | large
 flex        | t      | mix
 maintenance | f      | maintenance
(4 rows)

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

Parent topic:System Views