"Chris Velevitch" <chris.velevitch@gmail.com> writes:
> But, wouldn't you want to see the execution plan for the select
> statement that appears in the create?
Then give the EXPLAIN the select statement that appears in the create.
Logically, EXPLAIN of a DDL statement would tell you about the costs
of performing the catalog modifications involved in the DDL statement.
Which wouldn't have anything to do with what you request above. I don't
believe that CREATE VIEW ever bothers to form a plan for the view query
at all --- it just stuffs the parse tree into the catalogs.
regards, tom lane