Managing System Resource Usage

You can use the Using System Tables to track overall resource usage on your cluster. These and the other system tables are described in the Vertica System Tables.

If your queries are experiencing errors due to resource unavailability, you can use the following system tables to obtain more details:

System Table Description

RESOURCE_REJECTIONS

Monitors requests for resources that are rejected by the Resource Manager.

DISK_RESOURCE_REJECTIONS

Monitors requests for resources that are rejected due to disk space shortages. See Managing Disk Space for more information.

When requests for resources of a certain type are being rejected, do one of the following:

The LAST_REJECTED_VALUE field in RESOURCE_REJECTIONS indicates the cause of the problem. For example: