Postgres Pro
Downloads
Home   >   mailing lists

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

From Gaetano Mendola
Subject Re: Number of Active Connections
Date
Msg-id ci4t5o$si6$1@floppy.pyrenet.fr
Whole thread Raw
In response to Number of Active Connections  (MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: MaRCeLO PeReiRA
Date:
Subject: Re: Number of Active Connections
Next
From: Ying Lu
Date:
Subject: about C-JDBC for postgreSQL