Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group