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
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).
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
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