public inbox for [email protected]help / color / mirror / Atom feed
[doc] EXPLAIN CREATE MATERIALIZED VIEW AS? 3+ messages / 3 participants [nested] [flat]
* [doc] EXPLAIN CREATE MATERIALIZED VIEW AS? @ 2014-04-16 03:35 Amit Langote <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Amit Langote @ 2014-04-16 03:35 UTC (permalink / raw) To: PostgreSQL-development <[email protected]>; pgsql-docs Hi, Attached adds CREATE MATERIALIZED VIEW AS to the list of statements that can be EXPLAINed. -- Amit -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs Attachments: [application/octet-stream] explain-create-materialized-view-as.patch (695B, 2-explain-create-materialized-view-as.patch) download | inline diff: diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index 04a78ee..f945e50 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -228,8 +228,9 @@ ROLLBACK; <para> Any <command>SELECT</>, <command>INSERT</>, <command>UPDATE</>, <command>DELETE</>, <command>VALUES</>, <command>EXECUTE</>, - <command>DECLARE</>, or <command>CREATE TABLE AS</command> - statement, whose execution plan you wish to see. + <command>DECLARE</>, <command>CREATE TABLE AS</>, or + <command>CREATE MATERIALIZED VIEW AS</> statement, whose execution + plan you wish to see. </para> </listitem> </varlistentry> ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS? @ 2014-04-16 04:56 Michael Paquier <[email protected]> parent: Amit Langote <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Michael Paquier @ 2014-04-16 04:56 UTC (permalink / raw) To: Amit Langote <[email protected]>; +Cc: PostgreSQL-development <[email protected]>; pgsql-docs On Wed, Apr 16, 2014 at 12:35 PM, Amit Langote <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS? @ 2014-04-22 22:38 Bruce Momjian <[email protected]> parent: Amit Langote <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Bruce Momjian @ 2014-04-22 22:38 UTC (permalink / raw) To: Amit Langote <[email protected]>; +Cc: PostgreSQL-development <[email protected]>; pgsql-docs 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 <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-04-22 22:38 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-04-16 03:35 [doc] EXPLAIN CREATE MATERIALIZED VIEW AS? Amit Langote <[email protected]> 2014-04-16 04:56 ` Michael Paquier <[email protected]> 2014-04-22 22:38 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox