Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group