# REMOVE AGGREGATOR

Removes a child aggregator from a cluster.

## Syntax

```
REMOVE AGGREGATOR 'host':port;

```

## Remarks

* This command can only be used to remove child aggregators from a cluster; the master aggregator cannot be removed by using this command.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* 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.

## Example

```sql
SHOW AGGREGATORS;

```

```output

+-----------+------+--------+--------------------+------------------------------+-------------------+
| Host      | Port | State  | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator |
+-----------+------+--------+--------------------+------------------------------+-------------------+
| 10.0.2.15 | 3306 | online |                  0 |                         NULL |                 1 |
| 10.0.2.16 | 3306 | online |                  1 |                        0.322 |                 0 |
+-----------+------+--------+--------------------+------------------------------+-------------------+
2 rows in set (0.00 sec)

```

```sql
REMOVE AGGREGATOR '10.0.2.16':3306;

```

```output

Query OK, 0 rows affected (0.00 sec)
```

```sql
SHOW AGGREGATORS;

```

```output

+-----------+------+--------+--------------------+------------------------------+-------------------+
| Host      | Port | State  | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator |
+-----------+------+--------+--------------------+------------------------------+-------------------+
| 10.0.2.15 | 3306 | online |                  1 |                         NULL |                 1 |
+-----------+------+--------+--------------------+------------------------------+-------------------+
1 row in set (0.00 sec)
```

**Related Topics**

* [Aggregator](https://docs.singlestore.com/db/v9.1/introduction/distributed-architecture/cluster-components/#UUID-5ab4d9d6-9704-50a3-e36b-47484a35ad81.md)

***

Modified at: July 31, 2023

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

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