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.

Last modified: June 5, 2023

Was this article helpful?