Thread: Is there a command to to display active connections

Hi,
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.
John

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

--
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"