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
POOL_ID INTEGER Unique identifier for the resource pool
NAME

VARCHAR

The name of the resource pool.
SUBCLUSTER_OID

INTEGER

Unique identifier for a subcluster-specific resource pool. For global resource pools, 0 is returned.
SUBCLUSTER_NAME VARCHAR Specifies the subcluster that the subcluster-specific resource pool belongs to. If there are subcluster-specific resource pools with the same name on separate subclusters, multiple entries are returned. For global resource pools, this column is blank.
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.

CASCADETOSUBCLUSTERPOOL BOOLEAN

Specifies whether this resource pool cascades to a subcluster-level resource pool.