Yes, you got it. A count on pg_stat_activity should do it.
Regards,
Husam
-Original Message-
From: Sean Brown <[EMAIL PROTECTED]>
Sent: Monday, November 10, 2008 7:10 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Number of Current Client Connections
Is there a query
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
signature.asc
Description: This is a digita