MEMORY_NODE_DETAIL

MEMORY_NODE_DETAIL displays memory usage of a node in the database.

Table 1 MEMORY_NODE_DETAIL columns

Name	Type	Description
nodename	text	Node name
memorytype	text	Memory name - max_process_memory: memory occupied by the MogDB instance - process_used_memory: memory occupied by a 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 size allowed for the SCTP communications - sctpcomm_used_memory: memory used for SCTP communications - sctpcomm_peak_memory: memory peak of SCTP communications - other_used_memory: other used memory - gpu_max_dynamic_memory: maximum dynamic GPU memory - gpu_dynamic_used_memory: used dynamic memory of GPU - gpu_dynamic_peak_memory: dynamic peak value of the GPU memory - pooler_conn_memory: applied memory in the connection pool - pooler_freeconn_memory: memory occupied by idle connections in the connection pool - storage_compress_memory: memory used by the storage module for compression - udf_reserved_memory: reserved memory for the UDF
memorymbytes	integer	Size of the used memory in the unit of MB.