RESOURCE_REJECTIONS

Monitors requests for resources that are rejected by the Resource Manager. Information is valid only as long as the node is up and the counters reset to 0 upon node restart.

 Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

POOL_ID

INTEGER

Catalog-assigned integer value that uniquely identifies the resource pool.

POOL_NAME

VARCHAR

Name of the resource pool.

REASON

VARCHAR

Reason for rejecting this request, for example:

  • Usage of single request exceeds high limit
  • Timed out waiting for resource reservation
  • Canceled waiting for resource reservation
RESOURCE_TYPE

VARCHAR

Memory, threads, file handles or execution slots.

The following list shows the resources that are limited by the resource manager. A query might need some amount of each resource, and if the amount needed is not available, the query is queued and could eventually time out of the queue and be rejected.

  • Number of running plans
  • Number of running plans on initiator node (local)
  • Number of requested threads
  • Number of requested file handles
  • Number of requested KB of memory
  • Number of requested KB of address space

Execution slots are determined by MAXCONCURRENCY parameter.

REJECTION_COUNT

INTEGER

Number of requests rejected due to specified reason and RESOURCE_TYPE.

FIRST_REJECTED_TIMESTAMP

TIMESTAMPTZ

Time of the first rejection for this pool.

LAST_REJECTED_TIMESTAMP

TIMESTAMPTZ

Time of the last rejection for this pool.

LAST_REJECTED_VALUE

INTEGER

Amount of the specific resource requested by the last rejection.

Example

=> SELECT node_name, pool_name, reason, resource_type, rejection_count AS count, last_rejected_value AS value FROM resource_rejections;
    node_name     | pool_name |           reason            | resource_type | count |  value
------------------+-----------+-----------------------------+---------------+-------+---------
 v_vmart_node0001 | sysquery  | Request exceeded high limit | Memory(KB)    |     1 | 8248449
(1 row)