Updated on 2025-05-29 GMT+08:00

GLOBAL_WLM_RESPOOL_MEMORY_INFO

This view is used to view the real-time memory 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_memory_info() to query the memory usage.

Table 1 GLOBAL_WLM_RESPOOL_MEMORY_INFO columns

Name

Type

Description

node_name

name

Node name.

respool_name

name

Name of a resource pool.

max_dynamic_memory

integer

Maximum dynamic memory that can be used.

current_dynamic_memory

integer

Used dynamic memory.

max_shared_memory

integer

Maximum shared memory that can be used.

current_shared_memory

integer

Shared memory that has been used.

shared_memory_hits_percent

integer

This function is unavailable and is reserved for future evolution. This column is reserved and the value is 0.

Example:
1
2
3
4
5
6
7
8
gaussdb=# SELECT * FROM GLOBAL_WLM_RESPOOL_CONCURRENCY_INFO;
 node_name   | respool_name | max_dynamic_memory | current_dynamic_memory | max_shared_memory | current_shared_memory | shared_memory_hits_percent 
--------------+--------------+--------------------+------------------------+-------------------+-----------------------+----------------------------
 coordinator1 | default_pool | -1                 | 9415kB                 | -1                | 3856kB                |                         0
 datanode1    | default_pool | -1                 | 10724kB                | -1                | 2808kB                |                        0
 datanode2    | default_pool | -1                 | 10724kB                | -1                | 2808kB                |                        0
 datanode3    | default_pool | -1                 | 10724kB                | -1                | 560kB                 |                        0
(4 rows)