Re: "Stuck" query

Tommy Gildseth <tommy.gildseth@usit.uio.no> writes:
> Richard Huxton wrote:
>> Looks like part of your query results being sent. Is it hung in that one
>> system-call?

> Yes, I left it there for about ~1 hour, and that was all that ever came.

Seems like you have got a network issue.  What does netstat show for the
status of that connection?

I don't think that a query cancel will blow PG off the send; you'd
probably have to resort to kill -9 on that process (with a consequent
restart of other sessions).  It's odd that the kernel hasn't given up
on the connection yet ...

            regards, tom lane