[YSQL] [Connection Manager] NewOrder latencies in TPCC increase(~30%) when using CM with Hikari

[sonalsagarwal]

Jira Link: DB-14571

Description

We observed higher NewOrder latencies when using Hikari Pool with ConnectionManager, compared to Hikari Pool without a ConnectionManager.
Perf comparison report

YB version : 2024.2.1.0-b78
GFlags:

enable_ysql_conn_mgr = true
allowed_preview_flags_csv = enable_ysql_conn_mgr
ysql_conn_mgr_superuser_sticky = false

Issue Type

kind/bug

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

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