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 and monitor admin permissions 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_sctpcomm_memory: maximum memory allowed for the communications library. sctpcomm_used_memory: memory used by the communications library. sctpcomm_peak_memory: memory peak of the communications library. other_used_memory: other used memory.
memorymbytes	integer	Size of the used memory (unit: MB).