pg_resqueuecapability

Note

The pg_resqueuecapability system catalog table is valid only when resource queue-based resource management is active.

The pg_resqueuecapability system catalog table contains information about the extended attributes, or capabilities, of existing Greenplum Database resource queues. Only resource queues that have been assigned an extended capability, such as a priority setting, are recorded in this table. This table is joined to the pg_resqueue table by resource queue object ID, and to the pg_resourcetype table by resource type ID (restypid).

This table is populated only on the coordinator. This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.

column	type	references	description
rsqueueid	oid	pg_resqueue.oid	The object ID of the associated resource queue.
restypid	smallint	pg_resourcetype. restypid	The resource type, derived from the pg_resqueuecapability system table.
resetting	text		The specific value set for the capability referenced in this record. Depending on the actual resource type, this value may have different data types.

Parent topic: System Catalogs Definitions