Rajesh Kumar Mallah <mallah@xxxxxxxxxxxxxx> writes: > many a times the backend are stubborn. A backend is currently > executing a Query , the query usually finishes quickly < 5 secs. > But this query is on for past many minutes. I want to debug why > it is hung if it is hung. Attach to the backend process with gdb and get a stack trace --- that would at least give us some information to work with. regards, tom lane