gp_resqueue_status

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.

gp_resqueue_status

The gp_toolkit.gp_resqueue_status view allows administrators to see 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.

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.