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.
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. |
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) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot