System Catalogs Definitions - gp_resqueue_status - 《Greenplum Database v6.23 Documentation》

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.

Note

The gp_resqueue_status view is valid only when resource queue-based resource management is active.

column	type	references	description
`queueid`	oid	gptoolkit.gp_resqueue queueid	The ID of the resource queue.
`rsqname`	name	gptoolkit.gp_resqueue rsqname	The name of the resource queue.
`rsqcountlimit`	real	gptoolkit.gp_resqueue rsqcountlimit	The active query threshold of the resource queue. A value of -1 means no limit.
`rsqcountvalue`	real	gptoolkit.gp_resqueue rsqcountvalue	The number of active query slots currently being used in the resource queue.
`rsqcostlimit`	real	gptoolkit.gp_resqueue rsqcostlimit	The query cost threshold of the resource queue. A value of -1 means no limit.
`rsqcostvalue`	real	gptoolkit.gp_resqueue rsqcostvalue	The total cost of all statements currently in the resource queue.
`rsqmemorylimit`	real	gptoolkit.gp_resqueue rsqmemorylimit	The memory limit for the resource queue.
`rsqmemoryvalue`	real	gptoolkit.gp_resqueue rsqmemoryvalue	The total memory used by all statements currently in the resource queue.
`rsqwaiters`	integer	gptoolkit.gp_resqueue rsqwaiter	The number of statements currently waiting in the resource queue.
`rsqholders`	integer	gptoolkit.gp_resqueue rsqholders	The number of statements currently running on the system from this resource queue.

Parent topic: System Catalogs Definitions