# 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.                              |
| `rsqcountlimit` | real    | pg_resqueue.rsqcountlimit | The active query threshold of the resource queue. A value of -1 means no limit. |
| `rsqcountvalue` | real    |                           | The number of active query slots currently being used in the resource queue. |
| `rsqcostlimit`  | real    | pg_resqueue.rsqcostlimit  | The query cost threshold of the resource queue. A value of -1 means no limit. |
| `rsqcostvalue`  | real    |                           | The total cost of all statements currently in the resource queue. |
| `rsqwaiters`    | integer |                           | The number of statements currently waiting in the resource queue. |
| `rsqholders`    | integer |                           | The number of statements currently running on the system from this resource queue. |