pg_resqueue

The pg_resqueue system catalog table contains information about OushuDB resource queues, which are used for managing resources. 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).
vcid	oid		the vc’oid resource queue belongs to.