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.