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