Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

SHOW AGGREGATORS

Syntax

SQL

SHOW AGGREGATORS [EXTENDED];

Remarks

See Node Requirements for SingleStore Helios 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)