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.

Was this article helpful?