pg_resgroupcapability system catalog table is valid only when resource group-based resource management is active.
pg_resgroupcapability system catalog table contains information about the capabilities and limits of defined Greenplum Database resource groups. You can join this table to the pg_resgroup table by resource group object ID.
pg_resgroupcapability table, defined in the
pg_global tablespace, is globally shared across all databases in the system.
||The object ID of the associated resource group.|
||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
||opaque type||The specific value set for the resource limit referenced in this record. This value has the fixed type
Parent topic: System Catalogs Definitions