Re: Number of Active Connections - Mailing list pgsql-general

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