Date: Tue, 4 Oct 2005 12:36:28 -0500
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: jing han <jing_han_66@yahoo.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [INTERFACES] how to monitor dead connections to postgresql
	database
Message-ID: <20051004173628.GQ40138@pervasive.com>
References: <20051004132151.11144.qmail@web53513.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20051004132151.11144.qmail@web53513.mail.yahoo.com>
User-Agent: Mutt/1.5.9i

On Tue, Oct 04, 2005 at 06:21:51AM -0700, jing han wrote:
> Hello,
> 
> After 6 days busy running, one of my process dead of
> cannot connect to database, and the log message shows
> that exceeding max_connections. The max_connections =
> 30.
> 
> By running watch -d "ps ax |grep postgres" I only find
> 6 connections to database, there must be dead
> connections laying around and I cannot see them.
> 
> Can you tell me how to monitor dead connections to
> postgres database?

This isn't the list for this type of question; moving to -general.

You can query from pg_stat_activity:

SELECT * FROM pg_stat_activity;
or
SELECT count(*) FROM pg_stat_activity;
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461