Is there a way to see how many connections are open at a given time. We have
a constantly running program gathering data and putting it into a table. And
we are wondering if there is a way to view how many connections it is using,
so we are sure that the program is running correctly.

Rob


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"Rob Sell" <lists (AT) facnd (DOT) com> writes:
See pg_stat_activity, or run "ps" and count the backend processes ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org