pg_resqueue_status

The pg_resqueue_status view allows administrators to see status and activity for a workload management 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. pg_resqueue_status

column

type

references

description

rsqname

name

pg_resqueue_ rsqname

The name of the resource queue.

segmem

text

The calculated virtual segment memory resource quota.

segcore

text

The calculated virtual segment core resource quota.

segsize

text

The number of virtual segments that can be allocated to the resource queue.

segsizemax

text

The maximum number of virtual segments that can be allocated to the resource queue.

inusemem

text

Aggregated in-use memory by running statements.

inusecore

text

Aggregated in-use core by running statements.

rsqholders

text

The number of resource holders for running statements. A resource holder is a running statement whose allocated resources from the resource manager has not been returned yet. In other words, the statement holds some resources allocated from the resource manager.

resqwaiters

text

The number of resource requests that are queued and waiting for the resource.

paused

text

The dynamic pause status of the resource queue. There are three possible statuses:

T : Queue is paused for the allocation of resources to queued and incoming requests.