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

GLOBAL_MEMORY_NODE_DETAIL

The memory usage of all normal nodes in the database is displayed.

Table 1 GLOBAL_MEMORY_NODE_DETAIL fields

Name

Type

Description

nodename

text

Node name

memorytype

text

Memory name.
  • max_process_memory: memory occupied by the database 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 that can be used for SCTP TCP proxy communication.
  • sctpcomm_used_memory: used memory for TCP proxy communication
  • sctpcomm_peak_memory: memory peak of TCP proxy communication
  • other_used_memory: other used memory
  • gpu_max_dynamic_memory: maximum dynamic memory of GPU
  • 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.