doc-exports/docs/dws/dev/dws_04_0714.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

5.2 KiB

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