Skip site navigation (1) Skip section navigation (2)

Re: Is there a command to to display active connections

From: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
To: jfabiani(at)yolo(dot)com (John Fabiani)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is there a command to to display active connections
Date: 2004-04-26 07:20:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
John Fabiani wrote:
 > I attempting to figure out how many connections are open to my
 > database.  I'm asking because I'd like to keep track of the
 > connection pool.

SELECT * FROM pg_stat_activity;

(It's in the documentation.)

Best regards

Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 M√ľnchen
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"File names are infinite in length, where infinity is set to 255 characters."
        -- Peter Collinson, "The Unix File System"

In response to

pgsql-novice by date

Next:From: Christopher A. GoodfellowDate: 2004-04-26 16:48:43
Subject: Field with character varying (255)
Previous:From: Ramesh PatelDate: 2004-04-26 05:28:52

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group