Postgres Pro
Downloads
Home   >   mailing lists

Re: ToDo: log plans of cancelled queries - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ToDo: log plans of cancelled queries
Date
Msg-id 9944.1357921223@sss.pgh.pa.us
Whole thread Raw
In response to Re: ToDo: log plans of cancelled queries  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: ToDo: log plans of cancelled queries
List pgsql-hackers
Tree view 
Simon Riggs <simon@2ndQuadrant.com> writes:
> An even better feature would be to be able to send a signal to a
> running query to log its currently executing plan. That way you can
> ask "Why so slow?" before deciding to kill it.

That could conceivably work.  At least it wouldn't require running
EXPLAIN in a failed transaction.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ToDo: log plans of cancelled queries
Next
From: Pavel Stehule
Date:
Subject: Re: ToDo: log plans of cancelled queries