Remove all trace of EXPLAIN EXECUTE

Поиск
Список
Период
Сортировка
Искать

Remove all trace of EXPLAIN EXECUTE

От:
Simon 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

Re: Remove all trace of EXPLAIN EXECUTE

От:
Simon Riggs <simon@2ndquadrant.com>
Дата:
On Tue, 2005-08-09 at 18:50 -0400, Tom Lane wrote:
> Simon Riggs  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

Re: Remove all trace of EXPLAIN EXECUTE

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Simon Riggs  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
FAQ