Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ DWS Resource Monitoring/ Monitoring Memory Resources
Updated on 2025-10-09 GMT+08:00
View PDF

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 message is returned during the query, enable the memory management function. 
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 set max_process_memory on the DWS console to enable memory management. The procedure is as follows:
  1. Log in to the DWS console.
  2. Choose Dedicated Clusters > Clusters in the navigation tree on the left.
  3. In the cluster list, find the target cluster and click the cluster name to go to the cluster details page.
  4. Click the Parameter Modifications tab and change the value of max_process_memory to a proper one. For details about the modification suggestions, see max_process_memory. After it is done, click Save.
  5. In the Modification Preview dialog box, confirm the modifications and click Save. After the modification, restart the cluster for the modification to take effect.
Parent Topic: DWS Resource Monitoring