Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS Resource Monitoring/ Monitoring Memory Resources
Updated on 2026-11-12 GMT+08:00
Monitoring Memory Resources
Monitoring the Memory
DWS allows you to view cluster memory usage on the monitoring panel (DMS). For details, see Viewing DWS Cluster Monitoring Information on the DMS Monitoring Panel.
DWS provides a view for monitoring the memory usage of the entire cluster.
Query the pgxc_total_memory_detail view as a user with the sysadmin permission.
1 | SELECT * FROM pgxc_total_memory_detail; |
If the following error occurs when you query the view, enable the memory management function. This function is controlled by the GUC parameter enable_memory_limit, which is enabled by default. If the parameter is disabled, contact technical support to enable it.
1 2 3 | SELECT * FROM pgxc_total_memory_detail; ERROR: unsupported view for memory protection feature is disabled. CONTEXT: PL/pgSQL function pgxc_total_memory_detail() line 12 at FOR over EXECUTE statement |
You can change the value of max_process_memory on the DWS console to adjust the maximum physical memory available for the database node. The procedure is as follows:
- Log in to the DWS console.
- In the navigation pane on the left, choose Cluster > Cluster List.
- In the cluster list, find the target cluster and click the cluster name to go to the Cluster Information page.
- Click the Parameter Modifications tab and change the value of max_process_memory by referring to max_process_memory. Then, click Save.
- In the Modification Preview dialog box, confirm the modification and click Save.
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.