pg_stat_resqueues

pg_stat_resqueues

The pg_stat_resqueues view allows administrators to view metrics about a
resource queue's workload over time. To allow statistics to be collected for this view, you
must enable the stats_queue_level server configuration parameter on the
Greenplum Database master instance. Enabling the collection of these metrics
does incur a small performance penalty, as each statement submitted through a resource queue
must be logged in the system catalog tables.

Table 1. pg_catalog.pg_stat_resqueues

column

type

references

description

queueoid

oid

The OID of the resource queue.

queuename

name

The name of the resource queue.

n_queries_exec

bigint

Number of queries submitted for execution from
this resource queue.

n_queries_wait

bigint

Number of queries submitted to this resource
queue that had to wait before they could execute.

elapsed_exec

bigint

Total elapsed execution time for statements
submitted through this resource queue.

elapsed_wait

bigint

Total elapsed time that statements submitted
through this resource queue had to wait before they were executed.