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.

Was this article helpful?