Re: Question on session timeout

2024-10-04 Thread Adrian Klaver
On 10/4/24 12:36, sud wrote: And yes it's RDS. The errors which we were seeing were related to the data bit not related to connections. The errors occur in a connection so they are related. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Question on session timeout

2024-10-04 Thread sud
On Tue, Oct 1, 2024 at 5:45 PM Greg Sabino Mullane wrote: > On Tue, Oct 1, 2024 at 1:57 AM sud wrote: > >> *Where are you getting the ~2000 count from?* >> Seeing this in the "performance insights" dashboard and also its matching >> when I query the count of sessions from pg_stat_activity. >> >

Re: Question on session timeout

2024-10-01 Thread Greg Sabino Mullane
On Tue, Oct 1, 2024 at 1:57 AM sud wrote: > *Where are you getting the ~2000 count from?* > Seeing this in the "performance insights" dashboard and also its matching > when I query the count of sessions from pg_stat_activity. > So I'm guessing this is perhaps RDS or Aurora? Stating that up fron

Re: Question on session timeout

2024-10-01 Thread Adrian Klaver
On 9/30/24 22:57, sud wrote: On Tue, Oct 1, 2024 at 4:10 AM Adrian Klaver > wrote: /Where are you getting the ~2000  count from?/ Seeing this in the "performance insights" dashboard and also its matching when I query the count of sessions from pg_stat_activ

Re: Question on session timeout

2024-09-30 Thread sud
On Tue, Oct 1, 2024 at 4:10 AM Adrian Klaver wrote: > On 9/30/24 13:01, sud wrote: > > Hello, > > We are frequently seeing the total DB connection reaching ~2000+ whereas > > Where are you getting the ~2000 count from? > > > the total number of active sessions in pg_stat_activity staying <100 at

Re: Question on session timeout

2024-09-30 Thread Adrian Klaver
On 9/30/24 13:01, sud wrote: Hello, We are frequently seeing the total DB connection reaching ~2000+ whereas Where are you getting the ~2000 count from? the total number of active sessions in pg_stat_activity staying <100 at any point in time. And when we see the sessions from DB side they

Question on session timeout

2024-09-30 Thread sud
Hello, We are frequently seeing the total DB connection reaching ~2000+ whereas the total number of active sessions in pg_stat_activity staying <100 at any point in time. And when we see the sessions from DB side they are showing most of the sessions with state as 'idle' having backend_start/xact_s