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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
