doc-exports/docs/dws/dev/dws_04_0714.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +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