Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ Schemas/ DBE_PERF Schema/ Memory/ GLOBAL_MEMORY_NODE_DETAIL
Updated on 2025-08-19 GMT+08:00
View PDF

GLOBAL_MEMORY_NODE_DETAIL

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).
Parent topic: Memory