Re: How to determine database activity??? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: How to determine database activity???
Date
Msg-id 200510310205.35769.peter_e@gmx.net
Whole thread Raw
In response to How to determine database activity???  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-admin
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/

pgsql-admin by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: How to determine database activity???
Next
From: adey
Date:
Subject: Re: How to determine database activity???