[GENERAL] Number of Active Connections

2004-09-13 Thread MaRCeLO PeReiRA
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

Re: [GENERAL] Number of Active Connections

2004-09-13 Thread elein
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).

Re: [GENERAL] Number of Active Connections

2004-09-13 Thread MaRCeLO PeReiRA
Hi Elein, Thanks!! It was exactly what I was looking for!!! Regards, Marcelo Pereira Brasil --- elein [EMAIL PROTECTED] escreveu: 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

Re: [GENERAL] Number of Active Connections

2004-09-13 Thread Gaetano Mendola
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). If you have enough permission: select count(*) from pg_stat_activity; Regards Gaetano Mendola ---(end of