RESOURCE_POOLS

This view contains information about resource pools.

For more information about these fields, see CREATE RESOURCE POOL.

Column Name	Description
`POOL_NAME`	The name of a given resource pool.
`MEMORY_PERCENTAGE`	The percentage of available memory that the given resource pool is allowed to use.
`QUERY_TIMEOUT`	The number of seconds after which a resource pool is set to cancel queries.
`MAX_CONCURRENCY`	The maximum number of concurrent queries that can be run across all aggregators at a time for a given resource pool.
`SOFT_CPU_LIMIT_PERCENTAGE`	An integer between 1 to 100. CPU usage for users can be limited from 1% - 100% of available processing capacity.
`HARD_CPU_LIMIT_PERCENTAGE`	An integer between 1 to 100. CPU usage for users can be limited from 1% - 100% of available processing capacity.
`MAX_QUEUE_DEPTH`	The maximum number of queries that will be queued when `MAX_CONCURRENCY` is exceeded.

Was this article helpful?