Re: create view problem - Mailing list pgsql-general

From Tom Lane
Subject Re: create view problem
Date
Msg-id 20176.1149519130@sss.pgh.pa.us
Whole thread Raw
In response to Re: create view problem  ("Chris Velevitch" <chris.velevitch@gmail.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: does this mean i have a corruption?
Next
From: "Filip Rembiałkowski"
Date:
Subject: COLLATE