Обсуждение: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

Поиск
Список
Период
Сортировка

[doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

От
Amit Langote
Дата:
Hi,

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

--
Amit

Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

От
Michael Paquier
Дата:
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


Re: [DOCS] [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

От
Bruce Momjian
Дата:
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. +