PG_RESOURCE_POOL

PG_RESOURCE_POOL provides information about database resource pools.

Table 1 PG_RESOURCE_POOL columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

respool_name

name

Name of a resource pool

mem_percent

integer

Percentage of the memory configuration

cpu_affinity

bigint

Value of cores bound to the CPU

control_group

name

Name of the Cgroup where the resource pool is located

active_statements

integer

Maximum number of concurrent statements in the resource pool

max_dop

integer

Maximum degree of parallelism

memory_limit

name

Maximum memory of the resource pool

parentid

oid

OID of the parent resource pool

io_limits

integer

Upper limit of I/O operations per second. It is counted by ones for column storage and by 10 thousands for row storage.

io_priority

name

I/O priority set for jobs that consume many I/O resources. It takes effect when I/O usage reaches 90%.

nodegroup

name

Name of the logical openGauss to which the resource pool belongs

is_foreign

boolean

Whether the resource pool can be used for users outside the logical openGauss. If it is set to true, the resource pool controls the resources of common users who do not belong to the current resource pool.

Feedback
编组 3备份
    openGauss 2024-05-25 00:45:01
    cancel