PG_RESOURCE_POOL¶
PG_RESOURCE_POOL records information about database resource pools.
Name | Type | Description |
|---|---|---|
respool_name | name | Name of the resource pool |
mem_percent | integer | Percentage of the memory configuration |
cpu_affinity | bigint | Reserved column without an actual meaning |
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 number of concurrent simple jobs allowed by the resource pool. -1 and 0 indicate that there are no limitations. |
memory_limit | name | Maximum memory of resource pool |
parentid | oid | OID of the parent resource pool |
io_limits | integer | Reserved column without an actual meaning |
io_priority | text | Reserved column without an actual meaning |
is_foreign | boolean | Indicates whether the resource pool can be used for users outside the logical cluster. If it is set to true, the resource pool controls the resources of common users who do not belong to the current resource pool. |
short_acc | boolean | Whether to enable short query acceleration for a resource pool. This function is enabled by default.
|
except_rule | text | Exception rule associated with a resource pool. There can be multiple associated rules, which are separated by commas (,). |