# SHOW AGGREGATORS

Show the aggregators in a cluster.

## Syntax

```sql
SHOW AGGREGATORS [EXTENDED];

```

## Remarks

* See [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md).
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) 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 thiscluster                                                                                       |
| `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;

```

```output

+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
| 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)

```

***

Modified at: June 2, 2023

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/show-aggregators/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-aggregators/)

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