[doc] EXPLAIN CREATE MATERIALIZED VIEW AS?
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
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>
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
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