Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Workload Management/ GLOBAL_WLM_RESPOOL_CPU_INFO
Updated on 2026-04-08 GMT+08:00
View PDF
Share

GLOBAL_WLM_RESPOOL_CPU_INFO

Views the real-time CPU usage of resource pools on all nodes in a distributed system. Only users 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, they share the same CPU resources. Therefore, their cpu_usage values are the same. If the CN and DN are deployed at different locations, their cpu_usage will be displayed separately.
Example: 
1
2
3
4
5
6
7
8
 
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)
Parent topic: Workload Management