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 references 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).