# SHOW LEAVES Shows the leaves in a cluster. ## Syntax ```sql SHOW LEAVES; ``` **Output** | Column | Description | | ------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------- | | `Host` | Host name or IP address | | `Port` | Port number | | `Availability_Group` | Availability group to which this leaf belongs | | `Pair_Host` | Pair host | | `Pair_Port` | Pair port | | `State` | Leaf state (see[Leaf States](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)) | | `Opened_Connections` | Number of opened connections | | `Average_Roundtrip_Latency_ms` | Average round-trip latency in milliseconds, calculated as`SELECT 1`from the master aggregator to the leaf | | `NodeId` | The unique`ID`of a given leaf node. | | `Grace_Period_in_Seconds` | Time left for the node to recover after failing and coming back online. This is set by engine variable`failover_initial_grace_interval_seconds` | | `Minimum_Pre_Prepare_Ts` | The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves). | | `Runtime_State` | Internal | ## Remarks * 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 LEAVES; ``` ```output +---------------+-------+--------------------+---------------+-----------+--------+--------------------+------------------------------+ | Host | Port | Availability_Group | Pair_Host | Pair_Port | State | Opened_Connections | Average_Roundtrip_Latency_ms | +---------------+-------+--------------------+---------------+-----------+--------+--------------------+------------------------------+ | 192.168.1.110 | 3306 | 1 | 192.168.1.112 | 3306 | online | 5 | 0.299 | | 192.168.1.111 | 3306 | 1 | 192.168.1.113 | 3306 | online | 5 | 0.293 | | 192.168.1.112 | 3306 | 2 | 192.168.1.110 | 3306 | online | 1 | 0.271 | | 192.168.1.113 | 3306 | 2 | 192.168.1.111 | 3306 | online | 1 | 0.264 | +---------------+-------+--------------------+---------------+-----------+--------+--------------------+------------------------------+ 4 rows in set (0.00 sec) ``` *** Modified at: July 31, 2023 Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/show-leaves/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/show-leaves/) (An index of the documentation is available at /llms.txt)