pg bouncer issue what does sv_used column means - Mailing list pgsql-performance

From Sheena, Prabhjot
Subject pg bouncer issue what does sv_used column means
Date
Msg-id 13E39D789E19FF4E9A87F6D456F3F982E90F30@SEAMBX03.sea.corp.int.untd.com
Whole thread Raw
Responses Re: pg bouncer issue what does sv_used column means  (Xenofon Papadopoulos <xpapad@gmail.com>)
List pgsql-performance

Guys we see spike in pg bouncer during the peak hours and that was slowing down the application. We did bump up the connection limit and it is helpful but now we  again notice little spike in connection. And one thing that I notice that is different is jump in sv_used value when I run command show pools during problem times

 

 

Can anyone please explain what value of sv_used means when i run show pools;

 

 


Regards

Prabhjot

 

pgsql-performance by date:

Previous
From: Johann Spies
Date:
Subject: Re: Slow query - lots of temporary files.
Next
From: Xenofon Papadopoulos
Date:
Subject: Re: pg bouncer issue what does sv_used column means