[EMAIL PROTECTED] ("Tauren Mills") wrote in message
news:<[EMAIL PROTECTED]>...
> I need to find a way to determine how many concurrent connections are being
> made to the database server at any given time.
You may find what you are looking for with Bruce Momjian's pgmonitor
tool.
http://greatbridge.org/project/pgmonitor/projdisplay.php
Alternatively, you could just use a simple shell script. All of the
Postgres connections are separate jobs with the identifier "postgres:"
at the begining. So you could simply do:
ps ax | grep postgres:
on a RH Linux machine.
With some sed/awk commands, you could sort the job information even
finer. For example, to find out which users are logged onto the
database at any given time:
ps ax | grep postgres: | awk '{print $6 | "sort" } ' | uniq
I'm sure if you fooled around with this, you could come up with
something tailored to your needs in no time.
-Tony
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
