# pg_resqueue_status

The `pg_resqueue_status` view allows administrators to see status and activity for a workload management resource queue. It shows how many queries are waiting to run and how many queries are currently active in the system from a particular resource queue.



Table 1. `pg_resqueue_status`

| column        | type | references           | description                                                  |
| :------------ | :--- | :------------------- | :----------------------------------------------------------- |
| `rsqname`     | name | pg_resqueue_ rsqname | The name of the resource queue.                              |
| `segmem`      | text |                      | The calculated virtual segment memory resource quota.        |
| `segcore`     | text |                      | The calculated virtual segment core resource quota.          |
| `segsize`     | text |                      | The number of virtual segments that can be allocated to the resource queue. |
| `segsizemax`  | text |                      | The maximum number of virtual segments that can be allocated to the resource queue. |
| `inusemem`    | text |                      | Aggregated in-use memory by running statements.              |
| `inusecore`   | text |                      | Aggregated in-use core by running statements.                |
| `rsqholders`  | text |                      | The number of resource holders for running statements. A resource holder is a running statement whose allocated resources from the resource manager has not been returned yet. In other words, the statement holds some resources allocated from the resource manager. |
| `resqwaiters` | text |                      | The number of resource requests that are queued and waiting for the resource. |
| `paused`      | text |                      | The dynamic pause status of the resource queue. There are three possible statuses:`T` : Queue is paused for the allocation of resources to queued and incoming requests.`F` : Queue is in a normal working status.`R` : Queue is paused and may have encountered resource fragmentation. |