On Wed, May 27, 2009 at 1:30 AM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > The big plus of the current technique is that it is so convenient to > Ctrl+C something which is running too long, arrow up, hit Home, and > put the EXPLAIN word in front. Turning the query into a character > string literal and feeding it to a function would be a big step > backward. > > A big down side of the current technique is that you can't get both > the results of a SELECT and its plan. I haven't seen any discussion > here about emitting the EXPLAIN output through some INFO messages or > some such, and letting the query return its normal results, but I feel > that would be a significant improvement, if it that be done.
Would something like this address both of your issues? http://article.gmane.org/gmane.comp.db.postgresql.devel.patches/21614/match=siginfo It let you hit a control character while the query was running to view the explain analyze for the results so far. The query kept running and you could request further updates whenever you wanted. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers