pg_resqueue_status

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	pgresqueue 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.