Rajesh Kumar Mallah <mallah(at)tradeindia(dot)com> 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