Re: How to determine database activity???

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/