On Mon, May 22, 2006 at 07:10:39PM +0100, Steve Tucknott wrote:
> Thanks for the pointers - we use Linux so I had thought of just using ps
> - but I'll also look into the pg_stat_activity table and see what's in
> that ...
pg_stat_activity is a view. To learn more about it and monitoring
in general see the "Monitoring Database Activity" chapter in the
documentation.
http://www.postgresql.org/docs/8.1/interactive/monitoring.html
--
Michael Fuhr