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.

Last modified: June 2, 2023

Was this article helpful?