gp_resqueue_status
The gp_toolkit.gp_resqueue_status view shows the status and activity for a 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.
| 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 |
integer |
gp_toolkit.gp_resqueue_rsqcountlimit |
The active query threshold of the resource queue.
A value of |
rsqcountvalue |
integer |
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 |
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_rsqwaiters |
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 |