# LEAVES

This view contains information about leaves.

| Column Name                 | Description                                                                                                                                      |
| --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ |
| `HOST`                      | The hostname or IP address for a given leaf node.                                                                                                |
| `PORT`                      | The port number of a given leaf node.                                                                                                            |
| `AVAILABILITY_GROUP`        | The`ID`of the related availability group.                                                                                                        |
| `PAIR_HOST`                 | The hostname or IP address for the mate of a given leaf which is part of a pair.                                                                 |
| `PAIR_PORT`                 | The port number of the mate of a given leaf which is part of a pair.                                                                             |
| `STATE`                     | The state of a given leaf node.                                                                                                                  |
| `OPENED_CONNECTIONS`        | The number of connections opened on a given leaf node.                                                                                           |
| `AVERAGE_ROUNDTRIP_LATENCY` | The average ping roundtrip latency in milliseconds for a given leaf node.                                                                        |
| `NODE_ID`                   | 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.                                                                                                                                        |

***

Modified at: June 2, 2023

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/leaves/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/leaves/)

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