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

oid

oid

OID of the resource queue.

rsqowner

oid

OID of the resource queue’s owner.

rsqname

name

The name of the resource queue.

rsqcountlimit

real

The active query threshold of the resource queue.

rsqcostlimit

real

The query cost threshold of the resource queue.

rsqovercommit

boolean

Allows queries that exceed the cost threshold to run when the system is idle.

rsqignorecostlimit

real

The query cost limit of what is considered a ‘small query’. Queries with a cost under this limit will not be queued and run immediately.

rsqacl

aclitem[]

Access privileges for the resource queue.