[doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

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

[doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

От:
Amit Langote <amitlangote09@gmail.com>
Дата:
Вложения:
Hi,

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

--
Amit

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

От:
Michael Paquier <michael.paquier@gmail.com>
Дата:
On Wed, Apr 16, 2014 at 12:35 PM, Amit Langote  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: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?

От:
Bruce Momjian <bruce@momjian.us>
Дата:
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          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

FAQ