Thread: See how many connections

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