Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

SHOW AGGREGATORS

Syntax

SQL

SHOW AGGREGATORS [EXTENDED];

Remarks

See Node Requirements for SingleStore Commands.
Refer to the Permissions Matrix for the required permissions.

Output

Column	Description
`Host`	Host name or IP address
`Port`	Port number
`State`	Aggregator state
`Opened_Connections`	Number of opened connections
`Average_Roundtrip_Latency_ms`	Average round-trip latency in milliseconds
`Master_Aggregator`	Master aggregator for this cluster
`Role`	Whether a given aggregator is a master or child. This will be `leader` for master aggregators, and `follower` for children.
`NodeID`	The unique `ID` of a given aggregator node.
`Runtime_State`	Internal

SHOW AGGREGATORS EXTENDED

SHOW AGGREGATORS EXTENDED adds these additional columns:

Column	Description
`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).
`Availability_Group`	The ID of the availability group to which the aggregator belongs.

Example

SQL

SHOW AGGREGATORS;

+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
| Host          | Port  | State  | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator | NodeID | Runtime_State |
+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
| 127.0.0.1     |  3306 | online |                  0 |                      NULL    |                 1 |      4 |        online |
| 192.168.1.116 |  3306 | online |                  1 |                     0.200    |                 0 |      5 |        online |
+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
2 rows in set (0.00 sec)