Is there a command to to display active connections

#1

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

John Fabiani wrote:

Quote:

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"

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Is there a command to to display active connections

comp.databases.postgresql.novice comp.databases.postgresql.novice

Is there a command to to display active connections - 04-25-2004 , 09:55 AM

Re: Is there a command to to display active connections - 04-26-2004 , 02:20 AM