public inbox for [email protected]
help / color / mirror / Atom feedFrom: Michael Paquier <[email protected]>
To: Amit Langote <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?
Date: Wed, 16 Apr 2014 13:56:27 +0900
Message-ID: <CAB7nPqSOTN=0KuP5aRn9m9ubsLrxiDZ=QUqtP+JnL6m4iPEopg@mail.gmail.com> (raw)
In-Reply-To: <CA+HiwqEZYDcdz4LH8bXEL_7Fm4XZ2=zGqPJ0xh1twtH=h=SwnA@mail.gmail.com>
References: <CA+HiwqEZYDcdz4LH8bXEL_7Fm4XZ2=zGqPJ0xh1twtH=h=SwnA@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-hackers>
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
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?
In-Reply-To: <CAB7nPqSOTN=0KuP5aRn9m9ubsLrxiDZ=QUqtP+JnL6m4iPEopg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox