On Fri, Feb 11, 2005 at 04:24:17PM -0500, Alex Turner wrote:
>
> pg_locks - awesome - I will check it out...
See also pg_stat_activity. If you don't see anything in the
current_query column then edit postgresql.conf and set
stats_command_string = true, then restart the database. With
this configuration you'll be able to see what each connection
is doing.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/