pg_resqueue

pg_resqueue

The pg_resqueue system catalog table contains information about HAWQ resource queues, which are used for managing resources. This table is populated only on the master. This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.

Table 1. pg_catalog.pg_resqueue

column	type	description
`rsqname`	name	The name of the resource queue.
`parentoid`	oid	OID of the parent queue of the resource queue.
`activestats`	integer	The maximum number of parallel active statements allowed for the resource queue.
`memorylimit`	text	The maximum amount of memory that can be consumed by the resource queue (expressed as a percentage of the cluster’s memory.) Because of how memory is determined, the memory limit is not an upper limit on the memory actually used by a resource queue.
`corelimit`	text	The maximum amount of cores that can be consumed by the resource queue (expressed as a percentage of the cluster’s cores.)
`resovercommit`	real	The ratio of resource consumption overcommit for the resource queue.
`allocpolicy`	text	The resource allocation policy name for the resource queue.
`vsegresourcequota`	text	The virtual segment resource quota for the resource queue.
`nvsegupperlimit`	integer	The upper limit of number of virtual segments allowed for one statement execution.
`nvseglowerlimit`	integer	The lower limit of number of virtual segments allowed for one statement execution.
`nvsegupperlimitperseg`	real	The upper limit of number of virtual segments allowed for one statement execution. The limit is averaged by the number of segments in the cluster.
`nvseglowerlimitperseg`	real	The lower limit of number of virtual segments aloowed for one statement execution. The limit is averaged by the number of segments in the cluster.
`creationtime`	timestamp with time zone	Time when the resource queue was created.
`updatetime`	timestamp with time zone	Time when the resource queue was last changed.
`status`	text	Current status of the resource queue.Possible values are `branch`, which indicates a branch resource queue (has children), and `NULL`, which indicates a leaf-level queue (no children).