"Chris Velevitch" <chris.velevitch@xxxxxxxxx> 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
