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.

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