Message-ID: <1381221892.2793.5.camel@turing>
Subject: Re: postgres connections in IDLE state..
From: jaime soler <jaime.soler@gmail.com>
Reply-To: jaime.soler@gmail.com
To: "Rajagopalan, Jayashree" <Jayashree.Rajagopalan@emc.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Tue, 08 Oct 2013 10:44:52 +0200
In-Reply-To: <A7A2044B8A59DA4F9F07599B3B1CA1210E4CA164@MX101CL02.corp.emc.com>
References: <A7A2044B8A59DA4F9F07599B3B1CA1210E4CA0F7@MX101CL02.corp.emc.com>
 <1380809664829-5773234.post@n5.nabble.com>
 <A7A2044B8A59DA4F9F07599B3B1CA1210E4CA164@MX101CL02.corp.emc.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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 expect the 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.  In between 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
> 
> 
> 


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin