Re: killing a query safely - Mailing list pgsql-admin

From Tom Lane
Subject Re: killing a query safely
Date
Msg-id 8800.1137703367@sss.pgh.pa.us
Whole thread Raw
In response to killing a query safely  (Rajesh Kumar Mallah <mallah@tradeindia.com>)
List pgsql-admin
Rajesh Kumar Mallah <mallah@tradeindia.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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Question
Next
From: Bruce Momjian
Date:
Subject: Re: WAL log archive frequency