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