Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org