gp_resqueue_status

The gp_toolkit.gp_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. gp_toolkit.gp_resqueue_status
column type references description
queueid oid gp_toolkit.gp_resqueue_ queueid The ID of the resource queue.
rsqname name gp_toolkit.gp_resqueue_ rsqname The name of the resource queue.
rsqcountlimit real gp_toolkit.gp_resqueue_ rsqcountlimit The active query threshold of the resource queue. A value of -1 means no limit.
rsqcountvalue real gp_toolkit.gp_resqueue_ rsqcountvalue The number of active query slots currently being used in the resource queue.
rsqcostlimit real gp_toolkit.gp_resqueue_ rsqcostlimit The query cost threshold of the resource queue. A value of -1 means no limit.
rsqcostvalue real gp_toolkit.gp_resqueue_ rsqcostvalue The total cost of all statements currently in the resource queue.
rsqmemorylimit real gp_toolkit.gp_resqueue_ rsqmemorylimit The memory limit for the resource queue.
rsqmemoryvalue real gp_toolkit.gp_resqueue_ rsqmemoryvalue The total memory used by all statements currently in the resource queue.
rsqwaiters integer gp_toolkit.gp_resqueue_ rsqwaiter The number of statements currently waiting in the resource queue.
rsqholders integer gp_toolkit.gp_resqueue_ rsqholders The number of statements currently running on the system from this resource queue.