Remove all trace of EXPLAIN EXECUTE

Started by Simon Riggsabout 21 years ago3 messagespatches
Jump to latest
#1Simon Riggs
simon@2ndQuadrant.com

There once was a rumour of a EXPLAIN EXECUTE command.

This minor patch removes all trace of that, but without disturbing other
valid occurrences of the EXECUTE command, which still lives on.

Best Regards, Simon Riggs

Attachments:

anal.patchtext/x-patch; charset=UTF-8; name=anal.patchDownload+8-8
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Simon Riggs (#1)
Re: Remove all trace of EXPLAIN EXECUTE

Simon Riggs <simon@2ndquadrant.com> writes:

There once was a rumour of a EXPLAIN EXECUTE command.
This minor patch removes all trace of that, but without disturbing other
valid occurrences of the EXECUTE command, which still lives on.

It's not as dead as you seem to think.

regression=# prepare foo as select * from tenk1;
PREPARE
regression=# explain execute foo;
QUERY PLAN
-------------------------------------------------------------
Seq Scan on tenk1 (cost=0.00..458.00 rows=10000 width=244)
(1 row)

regression=#

regards, tom lane

#3Simon Riggs
simon@2ndQuadrant.com
In reply to: Tom Lane (#2)
Re: Remove all trace of EXPLAIN EXECUTE

On Tue, 2005-08-09 at 18:50 -0400, Tom Lane wrote:

Simon Riggs <simon@2ndquadrant.com> writes:

There once was a rumour of a EXPLAIN EXECUTE command.
This minor patch removes all trace of that, but without disturbing other
valid occurrences of the EXECUTE command, which still lives on.

It's not as dead as you seem to think.

regression=# prepare foo as select * from tenk1;
PREPARE
regression=# explain execute foo;
QUERY PLAN
-------------------------------------------------------------
Seq Scan on tenk1 (cost=0.00..458.00 rows=10000 width=244)
(1 row)

regression=#

Got me! LOL

Patch retracted.

Best Regards, Simon Riggs