Help Center/Data Warehouse Service/Standard Data Warehouse (9.1.0.x)/DWS System Catalogs and Views/System Views/GS_TOTAL_NODEGROUP_MEMORY_DETAIL
Updated on 2025-10-09 GMT+08:00
View PDF

GS_TOTAL_NODEGROUP_MEMORY_DETAIL

GS_TOTAL_NODEGROUP_MEMORY_DETAIL displays statistics about memory usage of the logical cluster that the current database belongs to in the unit of MB.

Table 1 GS_TOTAL_NODEGROUP_MEMORY_DETAIL columns

Column

Type

Description

ngname

Text

Logical cluster name

memorytype

Text

Memory type. The value can be:

  • ng_total_memory: total memory of the logical cluster
  • ng_used_memory: memory usage of the logical cluster
  • ng_estimate_memory: estimated memory usage of the logical cluster
  • ng_foreignrp_memsize: total memory of the external resource pool of the logical cluster
  • ng_foreignrp_usedsize: memory usage of the external resource pool of the logical instance
  • ng_foreignrp_peaksize: peak memory usage of the external resource pool of the logical cluster
  • ng_foreignrp_mempct: percentage of the external resource pool of the logical cluster to the total memory of the logical cluster
  • ng_foreignrp_estmsize: estimated memory usage of the external resource pool of the logical cluster

memorymbytes

Integer

Size of allocated memory-typed memory

Parent Topic: System Views