[yugabyted] connection management metrics integration with yugabyted UI

[nchandrappa]

Jira Link: DB-7685

Description

Introduction

The connection management project enables the server-side pooling in the YugabyteDB cluster to improve client connection utilization in low-resource environments and handle large number of connections when the YugabyteDB is stressed with a burst of incoming client connections. Refer to #17599 for more details.

Connection Management Metrics

Connection management feature provides a host of metrics to show the connection utilization by reporting the active physical and logical connections, number of connections queued and avg time spent by the connections in the queue. Below is a sample metrics response reported in tserver-ip:13000/connections endpoint -

{
    "pools": [
        {
            "pool": "global",
            "active_logical_connections": 0,
            "queued_logical_connections": 0,
            "pending_logical_connections": 0,
            "active_physical_connections": 0,
            "idle_physical_connections": 0,
            "avg_wait_time": 0,
            "count_query": 0,
            "count_transactions": 0
        },
        {
            "pool": "control",
            "active_logical_connections": 0,
            "queued_logical_connections": 0,
            "pending_logical_connections": 0,
            "active_physical_connections": 0,
            "idle_physical_connections": 0,
            "avg_wait_time": 0,
            "count_query": 0,
            "count_transactions": 0
        }
    ]

• Each server reports metrics related to the current client connections load
• :13000/connections endpoint reports load stats for each database in the cluster

UI Integration Tasks

Status	UI Page	Description
	Overview page	Add a badge to the cluster overview page to display connection management is enabled on the cluster
	Nodes Page	When connection management is enabled, connection sections should display the active physical connections and active logical connections for each node
	Performance page	Add a connections tab, display a stacked graph to show the currently active connections and total connections
	Alerts page	TBD

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.