Re: How to determine database activity???

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: Joost Kraaijeveld <J(dot)Kraaijeveld(at)askesis(dot)nl>
Subject: Re: How to determine database activity???
Date: 2005-10-31 01:05:35
Message-ID: 200510310205.35769.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message adey 2005-10-31 04:16:18 Re: How to determine database activity???
Previous Message Joost Kraaijeveld 2005-10-30 09:49:35 How to determine database activity???