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
"Rob Sell" <lists@facnd.com> writes:
> Is there a way to see how many connections are open at a given time.
See pg_stat_activity, or run "ps" and count the backend processes ...
regards, tom lane