Re: Open connections

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Nico <nicohmail-postgresql(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Open connections
Date: 2004-12-28 15:48:49
Message-ID: 1104248929.21810.13.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 2004-12-28 at 05:34, Nico wrote:
> I would like to know how many connections are open at a certain time from a
> servlet, so I can anticipate connection errors. How do I do that?

Assuming that stats_row_level = true is set in the postgresql.conf file,
you can find out with:

SELECT * from pg_stat_activity;

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message tony 2004-12-28 17:14:49 openoffice and boolean
Previous Message Guillaume Cottenceau 2004-12-28 14:56:29 Re: problem to get nextval of a sequence