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 8747.1357918284@sss.pgh.pa.us
Whole thread Raw
In response to ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: ToDo: log plans of cancelled queries
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> What do you thinking about this feature?

The idea of expecting an add-on module to execute operations in an
already-failed transaction seems pretty dubious to me.  I also think
it's not a great idea to add partial executions into a query's stats.
For instance, suppose query X has been done 3 times and took a minute
each time.  The fourth time, the user cancels it after one second.
If we now report that the query's average execution time is 45 seconds
or so, that seems pretty misleading to me.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: allowing privileges on untrusted languages
Next
From: Samuel Vogel
Date:
Subject: Re: Print b-tree tuples