pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aaron Bono <postgresql@aranya.com>
To: Tomeh, Husam <htomeh@firstam.com>
Cc: pgsql admin <pgsql-admin@postgresql.org>
Subject: Re: Monitoring Connections
Date: Wed, 20 Sep 2006 13:46:00 -0500
Message-ID: <bf05e51c0609201146q11bff875g667c7ccc119ae4a9@mail.gmail.com> (raw)
In-Reply-To: <CB0FB369FF86E248A884BCC002562BCB0227DA1F@pisgsna01sxch01.ana.firstamdata.com>
References: <CB0FB369FF86E248A884BCC002562BCB0227DA1E@pisgsna01sxch01.ana.firstamdata.com>
	<CB0FB369FF86E248A884BCC002562BCB0227DA1F@pisgsna01sxch01.ana.firstamdata.com>

On 9/20/06, Tomeh, Husam <htomeh@firstam.com> wrote:
>
>  Make that:  http://www.postgresql.org/docs/8.1/static/monitoring.html
> 8.1 docs rather..   :)
>
> --
>   Husam
>   http://firstdba.googlepages.com
>
>  ------------------------------
> *From:* pgsql-admin-owner@postgresql.org [mailto:
> pgsql-admin-owner@postgresql.org] *On Behalf Of *Tomeh, Husam
> *Sent:* Wednesday, September 20, 2006 11:22 AM
> *To:* Aaron Bono; pgsql admin
> *Subject:* Re: [ADMIN] Monitoring Connections
>
>  Query the pg_stat_activity.
> For more detailed stats activities, you may query the pg_stat_* and
> pg_statio_*  system views.
>
> http://www.postgresql.org/docs/8.0/static/monitoring.html
>
> --
>   Husam
>   http://firstdba.googlepages.com
>
>
>  ------------------------------
> *From:* pgsql-admin-owner@postgresql.org [mailto:
> pgsql-admin-owner@postgresql.org] *On Behalf Of *Aaron Bono
> *Sent:* Wednesday, September 20, 2006 10:48 AM
> *To:* pgsql admin
> *Subject:* [ADMIN] Monitoring Connections
>
> Is there a way to get diagnostics on current connections to the database?
> Specifically I am looking for:
>
> 1. How many current connections are there?
> 2. Who is connected (user name, database and from what IP address)?
> 3. When was the last time the connection was used?
> 4. When was the connection established?
>
> I can get most of this information from the ps command but am having
> problem with getting the information on #3.
>
> My problem is that I have a number of web sites running on the server all
> using different databases and/or user log ins and also using connection
> pooling.  Whenever I redeploy an application, the "old" connections do not
> appear to disconnect but new connections are established.  I fear that,
> since the application server is not actually restarting but just reloading
> the application, it is keeping old connections open when they really should
> be closed.  This is something I will need to fix in the application but I
> need to do some digging before I know this is indeed the problem.
>
> I am using PostgreSQL 8.1.3 on CentOS.
>
> Thanks!
>


I checked the pg_stat_activity table and it doesn't give any more
information than I got from the ps command.

Is there any way to find out the last time the connection was used?

Thanks,
Aaron

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

view thread (6+ messages)  latest in thread

Message-ID: <bf05e51c0609201146q11bff875g667c7ccc119ae4a9@mail.gmail.com>
Permalink:  ../bf05e51c0609201146q11bff875g667c7ccc119ae4a9@mail.gmail.com/
Also on:    postgresql.org/message-id/bf05e51c0609201146q11bff875g667c7ccc119ae4a9@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: postgresql@aranya.com, htomeh@firstam.com
  Subject: Re: Monitoring Connections
  In-Reply-To: <bf05e51c0609201146q11bff875g667c7ccc119ae4a9@mail.gmail.com>
  References: <CB0FB369FF86E248A884BCC002562BCB0227DA1E@pisgsna01sxch01.ana.firstamdata.com> <CB0FB369FF86E248A884BCC002562BCB0227DA1F@pisgsna01sxch01.ana.firstamdata.com> <bf05e51c0609201146q11bff875g667c7ccc119ae4a9@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox