GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO

GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO is used to view the real-time concurrency 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_concurrency_info() to query the usage of concurrent tasks.

**Table 1** GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO columns
Name	Type	Description
node_name	name	Node name.
respool_name	name	Name of a resource pool.
max_concurrency	integer	Maximum number of concurrent queries allowed by the resource pool.
running_conurrency	integer	Number of concurrent tasks that are being executed in the current resource pool.
waiting_concurrency	integer	Number of concurrent tasks that are waiting in the current resource pool.

Example:

    
         gaussdb=# SELECT * FROM GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO;
 node_name   | respool_name | max_concurrency | running_concurrency | waiting_concurrency 
--------------+--------------+-----------------+---------------------+---------------------
 coordinator1 | default_pool |              -1 |                   1 |                   0
 datanode3    | default_pool |              -1 |                   1 |                   0
 datanode1    | default_pool |              -1 |                   1 |                   0
 datanode2    | default_pool |              -1 |                   1 |                   0
(4 rows)