Persistent High Connection Counts in RDS with Proxy: Seeking Community Insights and Solutions

Hello AWS community,

I'm experiencing an issue with persistently high connection counts in my Amazon RDS instance, which is configured with RDS Proxy to enhance performance and prevent saturation. Despite this setup, I consistently observe a minimum of 40 client connections and at least 60 database connections, rarely dropping below these numbers even during off-peak hours.

Here's a brief overview of my architecture:

Application Layer: Several serverless components including numerous AWS Lambda functions. Database: Amazon RDS with RDS Proxy enabled. Despite implementing RDS Proxy to manage database connections efficiently, the number of open connections remains unusually high throughout the day. This issue persists without any apparent spikes in traffic or workload, which should typically reduce the number of connections outside peak times.

Key Points:

• The client and database connections remain high even during low traffic periods.

• I have already enabled slow query logs and general logs on RDS to identify problematic queries but haven't pinpointed the cause.

I am looking for advice or diagnostic approaches that might help identify the source of these persistent connections. Are there specific RDS Proxy settings or AWS tools that could help monitor and potentially reduce these constant open connections?

Thank you in advance for your insights and suggestions!