Postgres Pro
Downloads
Home   >   mailing lists

Thread: Number of Active Connections

Number of Active Connections

From
MaRCeLO PeReiRA
Date:
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

Re: Number of Active Connections

From
elein
Date:
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

Re: Number of Active Connections

From
MaRCeLO PeReiRA
Date:
Hi Elein,

Thanks!! It was exactly what I was looking for!!!

Regards,

Marcelo Pereira
Brasil

 --- elein <elein@varlena.com> 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 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
>





_______________________________________________________
Yahoo! Messenger 6.0 - jogos, emoticons sonoros e muita diversão. Instale agora!
http://br.download.yahoo.com/messenger/

Re: Number of Active Connections

From
Gaetano Mendola
Date:
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