A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.
The 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.
The pg_resgroupcapability table, defined in the pg_global tablespace, is globally shared across all databases in the system.
|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
|value||opaque type||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.|
|proposed||opaque type||If you altered a resource limit and the limit cannot be updated immediately, the proposed value for the limit referenced in this record. Otherwise, proposed reflects the currently set value.|