PG_RESOURCE_POOL
PG_RESOURCE_POOL provides information about database resource pools.
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 |
Reserved column. |
max_dop |
integer |
Maximum scanning concurrency during data redistribution. This column is used only for scaling. |
memory_limit |
name |
Maximum memory of the resource pool. |
parentid |
oid |
OID of the parent resource pool. |
io_limits |
integer |
Upper limit of IOPS. It is counted by 10,000 per second for row store. |
nodegroup |
name |
Indicates the name of the node group to which the resource pool belongs. |
io_priority |
name |
I/O priority set for jobs that consume many I/O resources. It takes effect when the I/O usage reaches 90%. |
max_worker |
integer |
Concurrency in a table during data redistribution. This column is used only for scaling. |
max_connections |
integer |
Maximum number of connections that can be used by a resource pool. |
max_dynamic_memory |
name |
Maximum dynamic memory that can be used by a resource pool. |
max_shared_memory |
name |
Maximum shared memory that can be used by a resource pool. |
max_concurrency |
integer |
Maximum number of concurrent requests that can be used by a resource pool. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot