Re: How many connections now ?

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: NTPT <ntpt(at)centrum(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How many connections now ?
Date: 2005-02-05 11:24:44
Message-ID: Pine.LNX.4.61.0502051324200.31042@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message deeps1 2005-02-05 11:54:32 How I can add new function writing on C under Win32 for PostgreSQL v 8.0.1
Previous Message NTPT 2005-02-05 11:21:14 How many connections now ?