Updated on 2025-07-15 GMT+08:00

GS_TOTAL_NODEGROUP_MEMORY_DETAIL

GS_TOTAL_NODEGROUP_MEMORY_DETAIL returns the memory usage (in MB) of the current node group of the database. If the GUC parameter enable_memory_limit is set to off, this view is unavailable.

Table 1 GS_TOTAL_NODEGROUP_MEMORY_DETAIL columns

Name

Type

Description

ngname

text

Node group name.

memorytype

text

Memory type. The value must be one of the following:
  • ng_total_memory: total memory size of the node group.
  • ng_used_memory: memory used by the node group.
  • ng_estimate_memory: estimated memory used by the node group.
  • ng_foreignrp_memsize: total memory of the external resource pool of the node group.
  • ng_foreignrp_usedsize: memory used by the external resource pool of the node group.
  • ng_foreignrp_peaksize: peak memory used by the external resource pool of the node group.
  • ng_foreignrp_mempct: percentage of the external resource pool of the node group to the total memory of the node group.
  • ng_foreignrp_estmsize: estimated memory used by the external resource pool of the node group.

memorymbytes

integer

Size of allocated memory-typed memory.