Number of Current Client Connections

From: "Sean Brown" <sbrown(at)eaglepress(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Number of Current Client Connections
Date: 2008-11-10 15:10:03
Message-ID: 1226329803.26082.3.camel@lin-it1.eaglepress.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there a query I can run against PostgreSQL to get the number of
current client connections to the database? I didn't expect trying to
track this down would be as difficult as it has been.

Would a simple count of pg_stat_activity be correct?

-Thanks

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2008-11-10 15:23:20 Re: Number of Current Client Connections
Previous Message Achilleas Mantzios 2008-11-10 14:51:16 Re: max_files_per_process limit