PGXC_TOTAL_MEMORY_DETAIL

PGXC_TOTAL_MEMORY_DETAIL displays memory usage in the cluster. The query can be performed only on the CN. The execute direct on (dn)'select * from PGXC_TOTAL_MEMORY_DETAIL'; statement is not supported. Only users with the sysadmin or monitor admin permission can query this view.

**Table 1** PGXC_TOTAL_MEMORY_DETAIL columns
Name	Type	Description
nodename	text	Node name
memorytype	text	Memory name max_process_memory: memory occupied by a GaussDB cluster instance process_used_memory: memory occupied by a GaussDB process max_dynamic_memory: maximum dynamic memory dynamic_used_memory: used dynamic memory dynamic_peak_memory: dynamic memory peak dynamic_used_shrctx: maximum dynamic shared memory context dynamic_peak_shrctx: dynamic peak value of the shared memory context max_shared_memory: maximum shared memory shared_used_memory: used shared memory max_cstore_memory: maximum memory allowed by column-storage cstore_used_memory: memory used in column-storage max_sctpcomm_memory: maximum memory allowed for the communication library sctpcomm_used_memory: memory used by the communication library sctpcomm_peak_memory: memory peak of the communication library other_used_memory: other used memory
memorymbytes	integer	Size of the used memory, in MB