Re: [ADMIN] Number of Current Client Connections

2008-11-10 Thread Tomeh, Husam
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

[ADMIN] Number of Current Client Connections

2008-11-10 Thread Sean Brown
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