pg_resqueuecapability
The pg_resqueuecapability system catalog table contains information about the extended attributes, or capabilities, of existing Greengage DB 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 master.
This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.
| Column | Type | References | Description |
|---|---|---|---|
resqueueid |
oid |
pg_resqueue.oid |
The object ID of the associated resource queue |
restypid |
smallint |
pg_resourcetype.restypid |
The resource type, derived from the pg_resourcetype system table |
ressetting |
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 |