PGXC_TOTAL_MEMORY_DETAIL

Updated on 2023-10-31 GMT+08:00

View PDF

PGXC_TOTAL_MEMORY_DETAIL displays the memory usage in the cluster. Only the system administrator or the preset role gs_role_read_all_stats can access this view.

**Table 1** PGXC_TOTAL_MEMORY_DETAIL columns
Name	Type	Description
nodename	text	Node name
memorytype	text	Memory name, which can be set to any of the following values: max_process_memory: memory used by a GaussDB(DWS) cluster instance process_used_memory: memory used by a GaussDB(DWS) process max_dynamic_memory: maximum dynamic memory dynamic_used_memory: used dynamic memory dynamic_peak_memory: dynamic peak value of the memory 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 for column store cstore_used_memory: memory used for column store max_sctpcomm_memory: maximum memory allowed for the communication library sctpcomm_used_memory: memory used for the communication library sctpcomm_peak_memory: memory peak of the communication library other_used_memory: other used memory gpu_max_dynamic_memory: maximum GPU memory gpu_dynamic_used_memory: sum of the available GPU memory and temporary GPU memory gpu_dynamic_peak_memory: maximum memory used for GPU pooler_conn_memory: memory used for pooler connections pooler_freeconn_memory: memory used for idle pooler connections storage_compress_memory: memory used for column-store compression and decompression udf_reserved_memory: memory reserved for the UDF Worker process mmap_used_memory: memory used for mmap
memorymbytes	integer	Size of the used memory (MB)