RESOURCE_POOLS

Displays settings for built-in and user-defined resource pools. For information about defining resource pools, see CREATE RESOURCE POOL and ALTER RESOURCE POOL.

Column Name Data Type Description
NAME

VARCHAR

The name of this resource pool.

IS_INTERNAL

BOOLEAN

Specifies whether this pool is a built-in pool.

MEMORYSIZE

VARCHAR

The amount of memory allocated to this resource pool.

MAXMEMORYSIZE

VARCHAR

Value assigned as the maximum size this resource pool can grow by borrowing memory from the GENERAL pool.

MAXQUERYMEMORYSIZE VARCHAR The maximum amount of memory allocated by this pool to process any query
EXECUTIONPARALLELISM

INTEGER

Limits the number of threads used to process any single query issued in this resource pool
PRIORITY

INTEGER

Specifies priority of queries in this pool when they compete for resources in the GENERAL pool.

RUNTIMEPRIORITY

VARCHAR

The run-time priority defined for this pool, indicates how many run-time resources (CPU, I/O bandwidth) the Resource Manager should dedicate to running queries in the resource pool. Valid values are:

  • HIGH
  • MEDIUM (default)
  • LOW

These values are relative to each other. Queries with a HIGH run-time priority are given more CPU and I/O resources than those with a MEDIUM or LOW run-time priority.

RUNTIMEPRIORITYTHRESHOLD

INTEGER

Limits in seconds how soon a query must finish before the Resource Manager assigns to it the resource pool's RUNTIMEPRIORITY setting.

QUEUETIMEOUT

INTEGER INTERVAL

The maximum length of time requests can wait for resources to become available before being rejected, specified in seconds or as an interval. This value is set by the pool's QUEUETIMEOUT parameter.

PLANNEDCONCURRENCY

INTEGER

The preferred number of queries that execute concurrently in this resource pool, specified by the pool's PLANNEDCONCURRENCY parameter.

MAXCONCURRENCY

INTEGER

The maximum number of concurrent execution slots available to the resource pool, specified by the poolMAXCONCURRENCY parameter.

RUNTIMECAP

INTERVAL

The maximum time a query in the pool can execute.

SINGLEINITIATOR

BOOLEAN

Set for backward compatibility.

CPUAFFINITYSET

VARCHAR

The set of CPUs on which queries associated with this pool are executed. For example:

  • 0, 2-4 : Specifies CPUs 0, 2, 3, and 4
  • 25%: A percentage of available CPUs, rounded down to whole CPUs.
CPUAFFINITYMODE

VARCHAR

Specifies whether to share usage of the CPUs assigned to this resource pool by CPUAFFINITYSET, one of the following:

  • SHARED: Queries that run in this pool share its CPUAFFINITYSET CPUs with other Vertica resource pools.
  • EXCLUSIVE: Dedicates CPUAFFINITYSET CPUs to this resource pool only, and excludes other Vertica resource pools. If CPUAFFINITYSET is set as a percentage, then that percentage of CPU resources available to Vertica is assigned solely for this resource pool.
  • ANY: Queries in this resource pool can run on any CPU.
CASCADETO

VARCHAR

A secondary resource pool for executing queries that exceed the RUNTIMECAP setting of this resource pool.