Re: Number of Active Connections

From: elein <elein(at)varlena(dot)com>
To: MaRCeLO PeReiRA <gandalf_mp(at)yahoo(dot)com(dot)br>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Number of Active Connections
Date: 2004-09-13 19:30:24
Message-ID: 20040913123024.H5903@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-13 19:41:39 Re: Number of Active Connections
Previous Message MaRCeLO PeReiRA 2004-09-13 17:49:36 Number of Active Connections