select count(*) from pg_stat_activity; for detailed info use:
select * from pg_stat_activity; On Mon, Sep 13, 2004 at 02:49:36PM -0300, MaRCeLO PeReiRA wrote: > Hi guys, > > How can I know about the number of active > connections?? (not the maximum allowed, but the number > of open connections). > > Regards, > > Marcelo Pereira > Brasil > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
