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