Number of Active Connections

select count(*) from pg_stat_activity;

for detailed info use:

select * from pg_stat_activity;

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

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/