Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.0.x)/ DWS Resource Monitoring/ Monitoring Memory Resources
Updated on 2026-09-23 GMT+08:00
View PDF
Share

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 Monitoring Panel (DMS).

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:
  1. Log in to the DWS console.
  2. In the navigation pane on the left, choose Cluster > Cluster List.
  3. In the cluster list, find the target cluster and click the cluster name to go to the Cluster Information page.
  4. Click the Parameter Modifications tab and change the value of max_process_memory by referring to max_process_memory. Then, click Save.
  5. In the Modification Preview dialog box, confirm the modification and click Save.
Parent Topic: DWS Resource Monitoring