pg_resqueue
The pg_resqueue system catalog table contains information about Greengage DB resource queues, which are used for the resource management feature.
This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.
| Column | Type | Description |
|---|---|---|
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 |