Updated on 2025-05-29 GMT+08:00

GS_RESOURCE_PLAN_DIRECTIVES

GS_RESOURCE_PLANS is an instance-level system catalog. As a resource plan command table, GS_RESOURCE_PLANS records resource quotas and status of plan instructions.

Column

Type

Description

plan_name

name

Plan name.

pdb_name

name

PDB name.

min_cpu

real

Number of CPU cores that can be used by the PDB.

max_cpu

real

Reserved and cannot be set in the current version. The value is -1.

max_dynamic_memory

integer

Upper limit of the dynamic memory that can be used by the PDB, in KB. The value -1 indicates that the dynamic memory is not limited.

max_shared_memory

integer

Upper limit of the shared cache that can be used by the PDB, in KB. The value -1 indicates that the shared cache is not limited.

max_connections

integer

Maximum number of connections allowed by the PDB. The value -1 indicates that the number of connections is not limited.

io_limits

integer

Upper limit of IOPS.

The unit of row store is specified by io_control_unit (default: 6000 per second). The value 0 indicates there is no limit.

io_priority

name

When the disk I/O usage reaches 50%, this column takes effect to restrict I/Os. The I/O upper limits of high, medium, and low priorities are as follows:

  • High: When this column takes effect, the value is 50% of the average I/O speed in the last 3 seconds. The minimum value is 50.
  • Medium: When this column takes effect, the value is 20% of the average I/O speed in the last 3 seconds. The minimum value is 20.
  • Low: When this column takes effect, the value is 10% of the average I/O speed in the last 3 seconds. The minimum value is 10.

    Note: The unit of row store is specified by io_control_unit (default: 6000 per second). The value 0 indicates there is no limit.

status

name

Plan status.

  • pending: The plan is in the pending area and does not take effect.
  • active: The plan takes effect.

node_name

name

Reserved and cannot be set in the current version. The value is all.

comments

text

Remarks of a resource plan.