Re: Interesting results using new prepared statements
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Barry Lind <barry@xythos.com>, pgsql-hackers@postgresql.org
Date: 2002-09-18T04:09:09Z
Lists: pgsql-hackers
Tom Lane wrote: > > But I am not > > sure how to find out what the execution plan is for a prepared > > statement, since EXPLAIN doesn't work for a prepared statement (i.e. > > EXPLAIN EXECUTE <preparedStatementName>, doesn't work). > > Hmmm --- I can see the usefulness of that, but it looks like a new > feature and hence verboten during beta. Maybe a TODO for 7.4? Added to TODO: o Allow EXPLAIN EXECUTE to see prepared plans -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073