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.