On 4/14/14, 12:44 PM, Tom Lane wrote:
Andres Freund<and...@2ndquadrant.com>  writes:
>On 2014-04-14 13:06:21 -0400, Tom Lane wrote:
>>In particular I'm not sold on the use-case
>>for being able to tell that a process is waiting without being able to
>>tell what it's waiting for.  I can figure that much out already.


>You can? How? It could also be io or something else that's problematic.

If the process is not consuming any CPU time at all, it's waiting on
something.  (Now admittedly, that might be hard to tell remotely ---
but Simon seems to be assuming you have access to "ps" output.)

Right... and then I always find myself wondering what it's actually waiting on. 
IO? lwlock? Something else?
--
Jim C. Nasby, Data Architect                       j...@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to