Remove all trace of EXPLAIN EXECUTE
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
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
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