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.
  • F : Queue is in a normal working status.
  • R : Queue is paused and may have encountered resource fragmentation.