Hi Maxim,
10-20 active, concurrent connections is way below any CPU load problem
you should have with 48 available vCPUs.
You never explicitly said what the load is, so what is it in the context
of the 1,5,15?
Maxim Boguk wrote on 1/1/2023 11:30 AM:
> 1)usual load (e.g. no anomalies)
> 10-20 concurrent query runs (e.g. issues isn't related to the load
> spike or similar anomalies)
> additionally 5-10 short idle in transaction (usual amount too)
> total around 300 active connections to the database (after local
> pgbouncer in transaction mode)
Regards,
Michael Vitale
Michaeldba(at)sqlexec(dot)com <mailto:michaelvitale(at)sqlexec(dot)com>
703-600-9343