Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M248415=pgsql-hackers-arkari@postgresql.org>)
 id 1WaHth-0002p7-RY
 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2014 04:56:34 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M248415=pgsql-hackers-arkari@postgresql.org>)
 id 1WaHth-00062y-As
 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2014 04:56:33 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <michael.paquier@gmail.com>)
 id 1WaHtf-00062d-GV; Wed, 16 Apr 2014 04:56:31 +0000
Received: from mail-qc0-x22c.google.com ([2607:f8b0:400d:c01::22c])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <michael.paquier@gmail.com>)
 id 1WaHtd-0003X0-0j; Wed, 16 Apr 2014 04:56:30 +0000
Received: by mail-qc0-f172.google.com with SMTP id i8so11294678qcq.17
 for <multiple recipients>; Tue, 15 Apr 2014 21:56:27 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=Y7CGRZVYuMrb02vjNMkIfexHSMtUaAmotVHogN2ueBU=;
 b=zZ5DFTT7h/YwDVe+52fmfgHYnv/i1uahhWI96K4kGY7XPLIsodoEeXEVGvXiBdzMU2
 B0yrAZDE3pM95ysuwBUWqQaBZYDEfZHWzq0WFcxACvHSRkkJxECoBubcR43JzNT2wLnO
 2GOVwan2Zh9PY8m04pPGnEyIsMsmPR6kH9w9vri8tNKgBNfxMz/9Ffz218hlsGKDiCMx
 1L+Kp4/j8DXnmx0+UzNTok+4H4HPzL9z1v6OrjgykAc/ui8r4Z5EnJ6fY4dCJbao7ok6
 oCUqWAlEkYky6UJvhzfPOhbXHuDI5eRWsX4xD9hXf4DOeNP9YiVlVN0WdOiezzj/+sGm
 mUzw==
MIME-Version: 1.0
X-Received: by 10.224.65.194 with SMTP id k2mr244502qai.59.1397624187828; Tue,
 15 Apr 2014 21:56:27 -0700 (PDT)
Received: by 10.140.91.136 with HTTP; Tue, 15 Apr 2014 21:56:27 -0700 (PDT)
In-Reply-To: 
 <CA+HiwqEZYDcdz4LH8bXEL_7Fm4XZ2=zGqPJ0xh1twtH=h=SwnA@mail.gmail.com>
References: 
 <CA+HiwqEZYDcdz4LH8bXEL_7Fm4XZ2=zGqPJ0xh1twtH=h=SwnA@mail.gmail.com>
Date: Wed, 16 Apr 2014 13:56:27 +0900
Message-ID: 
 <CAB7nPqSOTN=0KuP5aRn9m9ubsLrxiDZ=QUqtP+JnL6m4iPEopg@mail.gmail.com>
Subject: Re: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS?
From: Michael Paquier <michael.paquier@gmail.com>
To: Amit Langote <amitlangote09@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>,
 "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

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