# pg_resqueue

The `pg_resqueue` system catalog table contains information about OushuDB resource queues, which are used for managing resources. This table is defined in the `pg_global` tablespace, meaning it is globally shared across all databases in the system.



Table 1. `pg_catalog.pg_resqueue`

| column                  | type                     | references | description                                                  |
| :---------------------- | :----------------------- | :--------- | :----------------------------------------------------------- |
| `rsqname`               | name                     |            | The name of the resource queue.                              |
| `parentoid`             | oid                      |            | OID of the parent queue of the resource queue.               |
| `activestats`           | integer                  |            | The maximum number of parallel active statements allowed for the resource queue. |
| `memorylimit`           | text                     |            | The maximum amount of memory that can be consumed by the resource queue (expressed as a percentage of the cluster’s memory.) Because of how memory is determined, the memory limit is not an upper limit on the memory actually used by a resource queue. |
| `corelimit`             | text                     |            | The maximum amount of cores that can be consumed by the resource queue (expressed as a percentage of the cluster’s cores.) |
| `resovercommit`         | real                     |            | The ratio of resource consumption overcommit for the resource queue. |
| `allocpolicy`           | text                     |            | The resource allocation policy name for the resource queue.  |
| `vsegresourcequota`     | text                     |            | The virtual segment resource quota for the resource queue.   |
| `nvsegupperlimit`       | integer                  |            | The upper limit of number of virtual segments allowed for one statement execution. |
| `nvseglowerlimit`       | integer                  |            | The lower limit of number of virtual segments allowed for one statement execution. |
| `nvsegupperlimitperseg` | real                     |            | The upper limit of number of virtual segments allowed for one statement execution. The limit is averaged by the number of segments in the cluster. |
| `nvseglowerlimitperseg` | real                     |            | The lower limit of number of virtual segments aloowed for one statement execution. The limit is averaged by the number of segments in the cluster. |
| `creationtime`          | timestamp with time zone |            | Time when the resource queue was created.                    |
| `updatetime`            | timestamp with time zone |            | Time when the resource queue was last changed.               |
| `status`                | text                     |            | Current status of the resource queue.Possible values are `branch`, which indicates a branch resource queue (has children), and `NULL`, which indicates a leaf-level queue (no children). |
| `vcid`                  | oid                      |            | the vc'oid resource queue belongs to.                        |