GS_TOTAL_NODEGROUP_MEMORY_DETAIL

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 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

GS_TOTAL_NODEGROUP_MEMORY_DETAIL returns the memory usage (in MB) of the current logical cluster of the database. If enable_memory_limit is set to off, this function cannot be used. (The current feature is a lab feature. Contact Huawei technical support before using it.)

**Table 1** GS_TOTAL_NODEGROUP_MEMORY_DETAIL columns
Name	Type	Description
ngname	text	Name of the logical cluster (The current feature is a lab feature. Contact Huawei technical support before using it.)
memorytype	text	Memory type. The value must be one of the following: 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 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