# MV\_RESOURCE\_POOL\_STATUS

This view contains information about the status of resource pools aggregating this information across all nodes in the cluster.

The view `LMV_RESOURCE_POOL_STATUS` provides the same resource pool status information as a local view for a specific node.

| Column Name             | Description                                                                                                                                                                                     |
| ----------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `NODE_ID`               | The`ID`of the related node.                                                                                                                                                                     |
| `POOL_NAME`             | The name of a given resource pool.                                                                                                                                                              |
| `RUNNING_QUERIES`       | The number of queries running on a given resource pool. This statistic is dependent on the current state of the server.                                                                         |
| `QUEUEING_QUERIES`      | The number of queries queued for a given resource pool. This statistic is dependent on the current state of the server.                                                                         |
| `KILLED_QUERIES`        | The number of queries killed on a given resource pool. This statistic is cumulative from the start of the server for that node.                                                                 |
| `FINISHED_QUERIES`      | The number of queries finished on a given resource pool. This statistic is cumulative from the start of the server for that node.                                                               |
| `TOTAL_QUEUE_TIME_US`   | The historical total queue time for a given resource pool. This statistic is cumulative from the start of the server for that node.                                                             |
| `AVERAGE_QUEUE_TIME_US` | The historical average queue time for a given resource pool. This statistic is cumulative from the start of the server for that node.                                                           |
| `CPU_AFFINITY_MASK`     | A boolean mask showing which CPU is designated for the queries in a given resource pool.                                                                                                        |
| `MEMORY_USAGE_BYTES`    | The amount of memory (in bytes) currently utilized by the associated resource pool. It is useful for monitoring resource allocation and detecting memory bottlenecks within the resource pools. |

***

Modified at: October 16, 2025

Source: [/db/v9.1/reference/information-schema-reference/resource-and-user-management/mv-resource-pool-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/mv-resource-pool-status/)

(An index of the documentation is available at /llms.txt)