Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaGdc-000870-F8 for pgsql-docs@arkaria.postgresql.org; Wed, 16 Apr 2014 03:35:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WaGdb-0004r6-UE for pgsql-docs@arkaria.postgresql.org; Wed, 16 Apr 2014 03:35:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaGdb-0004qw-93; Wed, 16 Apr 2014 03:35:51 +0000 Received: from mail-oa0-x22c.google.com ([2607:f8b0:4003:c02::22c]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WaGdZ-0000oD-6U; Wed, 16 Apr 2014 03:35:50 +0000 Received: by mail-oa0-f44.google.com with SMTP id n16so11932570oag.31 for ; Tue, 15 Apr 2014 20:35:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=ZISu17lbFcZxp3e/hLkmYcCh/SIr8BApGFaVOwhb1YU=; b=A9BqltkQ1C/dgkPAY+0Bk84ylNj5XEhbyeoAdfi8lP1vkNHBmPDHPEvlgNF69orCJC Gv73H1K5MCAumG0hwtjSDRxSgycT3TTfF7BrGQZk/TRzdHPDUKOpPJGvv7QLYx5GJunh Pz1IFZguXrd8Z0XFB9eIMr+PBvMRlP9zgzM9gHkEEiGxs7wLuYT4KhmFDJehORjlXzn6 yRkO/OvDBiTl9mdYtT5sxg3ByliNJ95OzqOdajNpyZMqN0jRQCSg9RthCH7eg6ASIs3t lDwX7CEF/QUh/YSsJnwJ5twCEFQjrQI2Irtrpa6jh+/PjhKKaOxHLj39wSIqfCCCwKdN s1ag== X-Received: by 10.60.141.9 with SMTP id rk9mr4613827oeb.12.1397619346344; Tue, 15 Apr 2014 20:35:46 -0700 (PDT) MIME-Version: 1.0 Received: by 10.76.129.238 with HTTP; Tue, 15 Apr 2014 20:35:26 -0700 (PDT) From: Amit Langote Date: Wed, 16 Apr 2014 12:35:26 +0900 Message-ID: Subject: [doc] EXPLAIN CREATE MATERIALIZED VIEW AS? To: PostgreSQL-development , "pgsql-docs@postgresql.org" Content-Type: multipart/mixed; boundary=047d7b3a9cacabb5d404f7209cad X-Pg-Spam-Score: -1.8 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --047d7b3a9cacabb5d404f7209cad Content-Type: text/plain; charset=UTF-8 Hi, Attached adds CREATE MATERIALIZED VIEW AS to the list of statements that can be EXPLAINed. -- Amit --047d7b3a9cacabb5d404f7209cad Content-Type: application/octet-stream; name="explain-create-materialized-view-as.patch" Content-Disposition: attachment; filename="explain-create-materialized-view-as.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_hu22afl90 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvZXhwbGFpbi5zZ21sIGIv ZG9jL3NyYy9zZ21sL3JlZi9leHBsYWluLnNnbWwKaW5kZXggMDRhNzhlZS4u Zjk0NWU1MCAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9leHBsYWlu LnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9leHBsYWluLnNnbWwKQEAg LTIyOCw4ICsyMjgsOSBAQCBST0xMQkFDSzsKICAgICAgPHBhcmE+CiAgICAg ICBBbnkgPGNvbW1hbmQ+U0VMRUNUPC8+LCA8Y29tbWFuZD5JTlNFUlQ8Lz4s IDxjb21tYW5kPlVQREFURTwvPiwKICAgICAgIDxjb21tYW5kPkRFTEVURTwv PiwgPGNvbW1hbmQ+VkFMVUVTPC8+LCA8Y29tbWFuZD5FWEVDVVRFPC8+LAot ICAgICAgPGNvbW1hbmQ+REVDTEFSRTwvPiwgb3IgPGNvbW1hbmQ+Q1JFQVRF IFRBQkxFIEFTPC9jb21tYW5kPgotICAgICAgc3RhdGVtZW50LCB3aG9zZSBl eGVjdXRpb24gcGxhbiB5b3Ugd2lzaCB0byBzZWUuCisgICAgICA8Y29tbWFu ZD5ERUNMQVJFPC8+LCA8Y29tbWFuZD5DUkVBVEUgVEFCTEUgQVM8Lz4sIG9y CisgICAgICA8Y29tbWFuZD5DUkVBVEUgTUFURVJJQUxJWkVEIFZJRVcgQVM8 Lz4gc3RhdGVtZW50LCB3aG9zZSBleGVjdXRpb24KKyAgICAgIHBsYW4geW91 IHdpc2ggdG8gc2VlLgogICAgICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4K ICAgIDwvdmFybGlzdGVudHJ5Pgo= --047d7b3a9cacabb5d404f7209cad Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --047d7b3a9cacabb5d404f7209cad--