GLOBAL_WLM_RESPOOL_CPU_INFO

This view is used to view the real-time CPU usage of resource pools on all nodes in a distributed system. Only the user with the SYSADMIN or MONADMIN permission can query this view.

This view can be used to query only the data on the primary DN. You need to log in to the standby node and use the system function gs_wlm_respool_cpu_info() to query the usage of CPU.

**Table 1** GLOBAL_WLM_RESPOOL_CPU_INFO columns
Name	Type	Description
node_name	name	Node name.
respool_name	name	Name of a resource pool.
control_group	name	Cgroup name.
cpu_affinity	name	Value of cores bound to the CPU.
cpu_usage	integer	CPU usage of a resource pool. NOTE: If the CN and DN are deployed together, the CN and DN share the same CPU resources. Therefore, the cpu_usage values of the CN and DN are the same. If the CN and DN are independently deployed, the cpu_usage values of the CN and DN are displayed separately.

Example:

    
         gaussdb=# SELECT * FROM GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO;
 node_name   | respool_name |    control_group    | cpu_affinity | cpu_usage 
--------------+--------------+---------------------+--------------+-----------
 coordinator1 | default_pool | DefaultClass:Medium | 0-71         |         0
 datanode1    | default_pool | DefaultClass:Medium | 0-71         |         0
 datanode2    | default_pool | DefaultClass:Medium | 0-71         |         0
 datanode3    | default_pool | DefaultClass:Medium | 0-71         |         0
(4 rows)