[doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

Started by Amit Langoteabout 12 years ago3 messageshackersdocs
Jump to latest
#1Amit Langote
Langote_Amit_f8@lab.ntt.co.jp
hackersdocs

Hi,

Attached adds CREATE MATERIALIZED VIEW AS to the list of statements
that can be EXPLAINed.

--
Amit

Attachments:

explain-create-materialized-view-as.patchapplication/octet-stream; name=explain-create-materialized-view-as.patchDownload+3-2
#2Michael Paquier
michael@paquier.xyz
In reply to: Amit Langote (#1)
hackersdocs
Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

On Wed, Apr 16, 2014 at 12:35 PM, Amit Langote <amitlangote09@gmail.com> wrote:

Hi,

Attached adds CREATE MATERIALIZED VIEW AS to the list of statements
that can be EXPLAINed.

Now that you mention that, REFRESH MATERIALIZED VIEW can be EXPLAIN'ed
as well, except that it returns that and does not error out:
=# explain refresh materialized view aam;
QUERY PLAN
-------------------------------------------
Utility statements have no plan structure
(1 row)
--
Michael

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Bruce Momjian
bruce@momjian.us
In reply to: Amit Langote (#1)
hackersdocs
Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

On Wed, Apr 16, 2014 at 12:35:26PM +0900, Amit Langote wrote:

Hi,

Attached adds CREATE MATERIALIZED VIEW AS to the list of statements
that can be EXPLAINed.

Patch applied. Thanks.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs