---
title: "pg_resqueuecapability"
source: https://cloudberry.apache.org/docs/sys-catalogs/sys-tables/pg-resqueuecapability
---

# 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 Apache Cloudberry 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](./pg-resqueue.md) table by resource queue object ID, and to the [pg_resourcetype](./pg-resourcetype.md) 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](./pg-resourcetype.md) 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.|