pg_resgroupcapability

The pg_resgroupcapability system catalog table contains information about the capabilities and limits of defined Greengage DB resource groups. You can join this table to the pg_resgroup table by resource group object ID.

The pg_resgroupcapability table, defined in the pg_global tablespace, is globally shared across all databases in the system.

Column Type References Description

Column	Type	References	Description
resgroupid	oid	pg_resgroup.oid	The object ID of the associated resource group
reslimittype	smallint	—	The resource group limit type: `0` — unknown. `1` — concurrency. `2` — CPU. `3` — memory. `4` — memory shared quota. `5` — memory spill ratio. `6` — memory auditor. `7` — CPU set.
value	text	—	The specific value set for the resource limit referenced in this record. This value has the fixed type `text`, and will be converted to a different data type depending upon the limit referenced

resgroupid

oid

pg_resgroup.oid

The object ID of the associated resource group

reslimittype

smallint

—

The resource group limit type:

0 — unknown.
1 — concurrency.
2 — CPU.
3 — memory.
4 — memory shared quota.
5 — memory spill ratio.
6 — memory auditor.
7 — CPU set.

value

text

—

The specific value set for the resource limit referenced in this record. This value has the fixed type text, and will be converted to a different data type depending upon the limit referenced

pg_resgroup

pg_resourcetype