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