tauren@servlets.net ("Tauren Mills") wrote in message news:<NBBBLBKDJMGDNPMDGAABAEBKBBAB.tauren@servlets.net>...
> 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
