Re: postgres connections in IDLE state.. - Mailing list pgsql-admin

From jaime soler
Subject Re: postgres connections in IDLE state..
Date
Msg-id 1381221892.2793.5.camel@turing
Whole thread Raw
In response to Re: postgres connections in IDLE state..  ("Rajagopalan, Jayashree" <Jayashree.Rajagopalan@emc.com>)
List pgsql-admin
El jue, 03-10-2013 a las 16:34 +0000, Rajagopalan, Jayashree escribió:
> Thanks.
>
> But what is the process id that is attached to the connection?
You can look at pid field in the pg_stat_activity system view.

>  Can I track down or debug/ get more information related to that process id?
I'd use operating system tools like lsof, it provides you information
related to devices, files opened... or if you want to know application
information you should use java debuger like jconsole, jvisualvm.


>
> Regards
> Jayashree
>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of David Johnston
> Sent: 03 October 2013 19:44
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] postgres connections in IDLE state..
>
> Rajagopalan, Jayashree wrote
> > I'm seeing intermittently - the DB connections getting stale - and not
> > getting returned to the Hibernate session pool. Some of the
> > connections are as old as 9 days.
>
> The whole point of a connection pool is to keep open connections to the database.  These connections, when not in
use,are "IDLE".  I would expect to see a single connection for every permanent pool connection. 
>
> I don't see any problem with what you show and describe other than I'd expect more than 2 idle connections and I'd
expectthe supposed "problem" to be persistent. 
>
> In your example the backend has been alive and in the pool since 9/11 and the most recent time it was used was 10/2.
Inbetween those two dates there were many other times the connection was used. 
>
> David J.
>
>
>
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/postgres-connections-in-IDLE-state-tp5773232p5773234.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
>




pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Reg. Restore
Next
From: Matheus de Oliveira
Date:
Subject: Re: Reg. Restore