| Lists: | pgsql-patches |
|---|
| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Remove all trace of EXPLAIN EXECUTE |
| Date: | 2005-08-09 22:28:01 |
| Message-ID: | 1123626481.3670.602.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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
| Attachment | Content-Type | Size |
|---|---|---|
| anal.patch | text/x-patch | 2.3 KB |
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Remove all trace of EXPLAIN EXECUTE |
| Date: | 2005-08-09 22:50:01 |
| Message-ID: | 20415.1123627801@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
Simon Riggs <simon(at)2ndquadrant(dot)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
| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Remove all trace of EXPLAIN EXECUTE |
| Date: | 2005-08-10 07:41:25 |
| Message-ID: | 1123659685.3670.606.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
On Tue, 2005-08-09 at 18:50 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)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