GS_TOTAL_MEMORY_DETAIL

GS_TOTAL_MEMORY_DETAIL collects statistics about memory usage of the current database node. This view is unavailable when enable_memory_limit is set to off.

Table 1 GS_TOTAL_MEMORY_DETAIL columns

Name	Type	Description
nodename	text	Node name
memorytype	text	Memory type. The value must be one of the following: - max_process_memory: memory occupied by a MogDB instance - process_used_memory: memory occupied by a MogDB 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 by the column - 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 allocated memory-typed memory