Joost Kraaijeveld wrote: > Is there a way to actually determine if the database is doing > anything after a query is send to the backend during *long* lasting > queries besides waiting and hoping? strace or ltrace will give you an idea, but I think you will find that the answer is usually "yes" and you just have to be patient. :) -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend