RESOURCE_POOLS

Displays settings for built-in and user-defined 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.