On Thu, 2003-01-02 at 15:55, Campano, Troy wrote:
> Is there an easy way to see what connections are open in a PostgreSQL server?
> Any way to see if they are active?
>
> thank you!
>
ps -ax (or different flags if you like) will show open connections and
should have bits / pieces of the queries being run on those connections.
You can also do a select * from pg_stat_activity from psql to get a look
at the current queries.
Robert Treat