Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> GS_TOTAL_NODEGROUP_MEMORY_DETAIL
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

Name

Type

Description

ngname

text

Name of a logical cluster

memorytype

text

Memory type. Its 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_memsize: memory usage of the external resource pool of the logical cluster
  • 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