Updated on 2023-10-23 GMT+08:00

GS_CLUSTER_RESOURCE_INFO

GS_CLUSTER_RESOURCE_INFO displays all DNs resource summaries. This view can be queried only when enable_dynamic_workload is set to on and the view cannot be executed on DNs. Only the user with sysadmin permission can query this view.

Table 1 GS_CLUSTER_RESOURCE_INFO columns

Name

Type

Description

min_mem_util

integer

Minimum memory usage of a DN

max_mem_util

integer

Maximum memory usage of the DN

min_cpu_util

integer

Minimum CPU usage of the DN

max_cpu_util

integer

Maximum CPU usage of the DN

min_io_util

integer

Minimum I/O usage of the DN

max_io_util

integer

Maximum I/O usage of the DN

used_mem_rate

integer

Maximum physical memory usage