# AGGREGATORS

This view contains information about aggregators. It is useful for understanding the number and attributes of the aggregators for a given cluster.

| Column Name                    | Description                                                                                                             |
| ------------------------------ | ----------------------------------------------------------------------------------------------------------------------- |
| `HOST`                         | The hostname or IP address for the related aggregator.                                                                  |
| `PORT`                         | The port number of the related aggregator.                                                                              |
| `STATE`                        | The current state of a given aggregator.                                                                                |
| `OPENED_CONNECTIONS`           | The number of connections opened on a given aggregator.                                                                 |
| `AVERAGE_ROUNDTRIP_LATENCY`    | The average ping roundtrip latency in milliseconds for a given aggregator.                                              |
| `MASTER_AGGREGATOR`            | If a given aggregator is in the role of master, this will be`1`, otherwise`0`.                                          |
| `ROLE`                         | Whether a given aggregator is a master or child. This will be`leader`for master aggregators, and`follower`for children. |
| `NODE_ID`                      | The unique`ID`of a given aggregator node.                                                                               |
| `LOCAL_MINIMUM_PRE_PREPARE_TS` | The timestamp of the coordinator's oldest distributed transaction.                                                      |
| `MINIMUM_PRE_PREPARE_TS`       | The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves). |
| `RUNTIME_STATE`                | Internal.                                                                                                               |
| `AVAILABILITY_GROUP`           | The ID of the availability group to which the aggregator belongs.                                                       |

***

Modified at: August 5, 2025

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/aggregators/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/aggregators/)

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