# show-aggregators

## Description

A convenience wrapper for running `SELECT * FROM INFORMATION_SCHEMA.AGGREGATORS` on the Master Aggregator on this host.

Returns a list of aggregators in the cluster. This command must be run from the same host that the Master Aggregator is on.

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.

## Usage

```
Usage:
  memsqlctl show-aggregators [flags]

Flags:
  -h, --help   Help for show-aggregators

Global Flags:
  -c, --config FILE_PATH                     Path to the memsqctl config file
      --default-install-dir DIRECTORY_PATH   Path to the default install directory
      --insecure-ssl                         Fall back to insecure SSL connections to local nodes if memsqlctl is unable to otherwise establish a connection (ADVANCED)
  -j, --json                                 Print output in JSON format
      --node-metadata-file FILE_PATH         Path to the node metadata file
      --parallelism POSITIVE_INTEGER         Maximum amount of operations to be run in parallel
      --ssl-ca FILE_PATH                     The path to the CA certificate file (in PEM format) to authenticate the database certificate
      --timeout duration                     Maximum time for operation to complete (e.g., 30s, 10m, 1.5h)
      --verbose-json                         Print output in JSON format, include some warnings and user messages
  -v, --verbosity count                      Increase logging verbosity
  -y, --yes                                  Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default
```

## Remarks

* This command is interactive unless you use either `--yes` or `--json` flag to override interactive behavior.
* The `memsqlctl show-aggregators` command is equivalent to the [sdb-admin show-aggregators](https://docs.singlestore.com/db/v9.1/reference/singlestore-tools-reference/sdb-admin-commands/show-aggregators.md) command.

## Output

The following is the standard output for the show-aggregators command.

```shell
sudo memsqlctl show-aggregators

```

```output

+------------+------+--------+--------------------+------------------------------+-------------------+
|    Host    | Port | State  | Opened Connections | Average Roundtrip Latency ms | Master Aggregator |
+------------+------+--------+--------------------+------------------------------+-------------------+
| 172.17.0.2 | 3306 | online |0                   | null                         |1                  |
| 172.17.0.7 | 3307 | online |1                   | 10.089                       |0                  |
+------------+------+--------+--------------------+------------------------------+-------------------+

```

***

Modified at: April 22, 2024

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

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