Displays the memory usage on all normal nodes in the cluster.
Table 1 GLOBAL_MEMORY_NODE_DETAIL columns
Name |
Type |
Description |
nodename |
text |
Node name. |
memorytype |
text |
Memory name.
- max_process_memory: maximum available memory of the database node.
- process_used_memory: memory occupied by a process.
- max_dynamic_memory: maximum dynamic memory.
- dynamic_used_memory: used dynamic memory.
- dynamic_peak_memory: dynamic memory peak.
- dynamic_used_shrctx: context of the used dynamic shared memory.
- 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 TCP proxy communications.
- sctpcomm_used_memory: used memory for TCP proxy communications.
- sctpcomm_peak_memory: memory peak of TCP proxy communications.
- other_used_memory: other used memory.
- gpu_max_dynamic_memory: maximum dynamic GPU memory.
- gpu_dynamic_used_memory: used dynamic GPU memory.
- gpu_dynamic_peak_memory: dynamic GPU memory peak.
- pooler_conn_memory: memory allocated to 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 user-defined functions.
|
memorymbytes |
integer |
Size of the used memory (unit: MB). |