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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
