Re: How many connections now ? - Mailing list pgsql-general

From Devrim GUNDUZ
Subject Re: How many connections now ?
Date
Msg-id Pine.LNX.4.61.0502051324200.31042@emo.org.tr
Whole thread Raw
In response to How many connections now ?  ("NTPT" <ntpt@centrum.cz>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Sat, 5 Feb 2005, NTPT wrote:

> Is there a way to determine how many connections to the database are  active
> ?
> some form of select  ? ie how many client application are connected to server
> ?  I need this value for client application ...

Check  pg_stat_activity  table...

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com                         http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFCBKz9tl86P3SPfQ4RAiTpAKDwUUuvju8xLhAjFzCKYsF4WQp7JACgrpQC
hhw0sDz2XDHElHCfBZFP8gs=
=pYgE
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "NTPT"
Date:
Subject: How many connections now ?
Next
From: Greg Stark
Date:
Subject: Re: Update command too slow