Tommy Gildseth <tommy.gildseth@xxxxxxxxxxx> 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
