Monitoring System Resources for Concurrent Use

When running in a multi-user environment, you may have several processes competing concurrently for system resources. Use the built-in GENERAL resource pool to provide resources in a multi-user environment. The GENERAL pool is preconfigured based on your system's RAM and machine cores. You can customize the GENERAL pool or define new resource pools and configure them for memory usage, concurrency, and query priority.

To monitor use of system resources over time, query the following system tables.

System Table Name Description
RESOURCE_ACQUISITIONS Details about each resource (memory, open file handles, threads) acquired by each request for each resource pool in the system.
RESOURCE_POOL_DEFAULTS Default values for parameters in each internal and user-defined resource pool.
RESOURCE_POOL_STATUS Configuration settings of the various resource pools in the system, including internal pools.
RESOURCE_POOLS Information about settings with which each resource pool was configured.
RESOURCE_QUEUES Information about requests that are pending for various resource pools.
RESOURCE_REJECTIONS Information about requests for resources that are rejected by the Resource Manager.
RESOURCE_REJECTION_DETAILS Entries for each resource request that the Vertica database denies. This information is useful for determining if there are resource space issues and which users/pools encounter problems.
SYSTEM_RESOURCE_USAGE History about system resources, such as memory, CPU, network, disk, I/O.

For more information about managing resource pools, see Best Practices for Managing Workload Resources in the Administrator's Guide.