Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yq0gJ-0006LE-T7 for pgsql-docs@arkaria.postgresql.org; Wed, 06 May 2015 14:52:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yq0gJ-0006KY-CK for pgsql-docs@arkaria.postgresql.org; Wed, 06 May 2015 14:52:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YpmTj-00075E-V8 for pgsql-docs@postgresql.org; Tue, 05 May 2015 23:42:20 +0000 Received: from mail-pd0-f179.google.com ([209.85.192.179]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YpmTZ-0003ns-Qh for pgsql-docs@postgresql.org; Tue, 05 May 2015 23:42:18 +0000 Received: by pdbnk13 with SMTP id nk13so212505851pdb.0 for ; Tue, 05 May 2015 16:42:06 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:message-id:date:user-agent:mime-version:to :subject:content-type; bh=mNu3w4GLnjKXYzkSwhuo824nGDCB7IT4Jse9HMC8cQ8=; b=Y8Xh7uLRspnGG9bm4dzkdQs3m6ukRLpBCYf8hevywTxm3FOIql++vUH/x1iW1nnyoe /t+BE4lxA3TQbHPLHIhfyEnRmW0223sVdmAedJ5UHMHknuEGZC8b00pZ+4DIA7KeqB+d Ol7jHw4Wzmzmjc6cooDrV4bwcR9SKh/JwLf+ACPGJnJaUDAsc5liKbyu5SUGczlqqPV2 kFS75/4+a9o1wYvvZVSk6qtytb1qZ4AC++kSNIFmMbH11n1/jjXXEBLgIuxBLsdr9Elz jtWIcEqA4cCxU60/eFDty8yf37OAlXN33pxTozjkh/bNYwXR8i53+JorKSuSJPQei41z jmWA== X-Gm-Message-State: ALoCoQnK4cJlJpu218/7cnEzscAa0E/TEexyhKrnwV3zIkXpJFYEz26ySb4Hy2QIHcThxFZfaaV5/bNRCqpnx6x6TTQDteiEdHGXvHT26IkfpqaaBx8r+ILmzgk4mfGoVp2MwoNaJ6uxJUhy1hsJwn/eYHRDWFtBcRh8R7B8yTKlbtVK1iSvBYCD9iApUvpfwuQt2lAQ+5sK X-Received: by 10.66.165.8 with SMTP id yu8mr24795453pab.82.1430869326499; Tue, 05 May 2015 16:42:06 -0700 (PDT) Received: from nara.local (p2148-ipngn402marunouchi.tokyo.ocn.ne.jp. [180.22.71.148]) by mx.google.com with ESMTPSA id qp13sm17027826pdb.31.2015.05.05.16.42.05 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 05 May 2015 16:42:05 -0700 (PDT) From: Ian Barwick X-Google-Original-From: Ian Barwick Message-ID: <5549554A.8030101@2ndquadrant.com> Date: Wed, 06 May 2015 08:42:02 +0900 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: pg_stat_statements doc tweaks Content-Type: multipart/mixed; boundary="------------080409080106040305010905" X-Pg-Spam-Score: -2.6 (--) 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 This is a multi-part message in MIME format. --------------080409080106040305010905 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi I noticed that the pg_stat_statement docs [*] seem to imply that if you load pg_stat_statements via 'shared_preload_libraries', a "system view" named 'pg_stat_statements' will be created, presumably in the pg_catalog schema. However the requirement to install the extension to access the (non-system) view isn't mentioned until after the (lengthy) view description. [*] http://www.postgresql.org/docs/devel/static/pgstatstatements.html I've refactored this slightly to put the installation details at the top, and remove the term "system view". Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services --------------080409080106040305010905 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="pgss-doc.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="pgss-doc.patch" ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9wZ3N0YXRzdGF0ZW1lbnRzLnNn bWwgYi9kb2Mvc3JjL3NnbWwvcGdzdGF0c3RhdGVtZW50cy5zZ21sCm5ldyBm aWxlIG1vZGUgMTAwNjQ0CmluZGV4IDA0YjNmMDEuLjRkN2E2ZTYKKioqIGEv ZG9jL3NyYy9zZ21sL3Bnc3RhdHN0YXRlbWVudHMuc2dtbAotLS0gYi9kb2Mv c3JjL3NnbWwvcGdzdGF0c3RhdGVtZW50cy5zZ21sCioqKioqKioqKioqKioq KgoqKiogMTksMzAgKioqKgogICAgVGhpcyBtZWFucyB0aGF0IGEgc2VydmVy IHJlc3RhcnQgaXMgbmVlZGVkIHRvIGFkZCBvciByZW1vdmUgdGhlIG1vZHVs ZS4KICAgPC9wYXJhPgogIAogICA8c2VjdDI+CiAgICA8dGl0bGU+VGhlIDxz dHJ1Y3RuYW1lPnBnX3N0YXRfc3RhdGVtZW50czwvc3RydWN0bmFtZT4gVmll dzwvdGl0bGU+CiAgCiAgICA8cGFyYT4KICAgICBUaGUgc3RhdGlzdGljcyBn YXRoZXJlZCBieSB0aGUgbW9kdWxlIGFyZSBtYWRlIGF2YWlsYWJsZSB2aWEg YQohICAgIHN5c3RlbSB2aWV3IG5hbWVkIDxzdHJ1Y3RuYW1lPnBnX3N0YXRf c3RhdGVtZW50czwvPi4gIFRoaXMgdmlldwogICAgIGNvbnRhaW5zIG9uZSBy b3cgZm9yIGVhY2ggZGlzdGluY3QgZGF0YWJhc2UgSUQsIHVzZXIgSUQgYW5k IHF1ZXJ5CiAgICAgSUQgKHVwIHRvIHRoZSBtYXhpbXVtIG51bWJlciBvZiBk aXN0aW5jdCBzdGF0ZW1lbnRzIHRoYXQgdGhlIG1vZHVsZQogICAgIGNhbiB0 cmFjaykuICBUaGUgY29sdW1ucyBvZiB0aGUgdmlldyBhcmUgc2hvd24gaW4K LS0tIDE5LDQwIC0tLS0KICAgIFRoaXMgbWVhbnMgdGhhdCBhIHNlcnZlciBy ZXN0YXJ0IGlzIG5lZWRlZCB0byBhZGQgb3IgcmVtb3ZlIHRoZSBtb2R1bGUu CiAgIDwvcGFyYT4KICAKKyAgPHBhcmE+CisgICAgV2hlbiA8ZmlsZW5hbWU+ cGdfc3RhdF9zdGF0ZW1lbnRzPC9maWxlbmFtZT4gaXMgbG9hZGVkLCBpdCB0 cmFja3MKKyAgICBzdGF0aXN0aWNzIGFjcm9zcyBhbGwgZGF0YWJhc2VzIG9m IHRoZSBzZXJ2ZXIuICBUbyBhY2Nlc3MgYW5kIG1hbmlwdWxhdGUKKyAgICB0 aGVzZSBzdGF0aXN0aWNzLCB0aGUgbW9kdWxlIHByb3ZpZGVzIGEgdmlldywg PHN0cnVjdG5hbWU+cGdfc3RhdF9zdGF0ZW1lbnRzPC8+LAorICAgIGFuZCB0 aGUgdXRpbGl0eSBmdW5jdGlvbnMgPGZ1bmN0aW9uPnBnX3N0YXRfc3RhdGVt ZW50c19yZXNldDwvPiBhbmQKKyAgICA8ZnVuY3Rpb24+cGdfc3RhdF9zdGF0 ZW1lbnRzPC8+LiAgVGhlc2UgYXJlIG5vdCBhdmFpbGFibGUgZ2xvYmFsbHkg YnV0CisgICAgY2FuIGJlIGVuYWJsZWQgZm9yIGEgc3BlY2lmaWMgZGF0YWJh c2Ugd2l0aAorICAgIDxjb21tYW5kPkNSRUFURSBFWFRFTlNJT04gcGdfc3Rh dF9zdGF0ZW1lbnRzPC8+LgorICA8L3BhcmE+CisgCiAgIDxzZWN0Mj4KICAg IDx0aXRsZT5UaGUgPHN0cnVjdG5hbWU+cGdfc3RhdF9zdGF0ZW1lbnRzPC9z dHJ1Y3RuYW1lPiBWaWV3PC90aXRsZT4KICAKICAgIDxwYXJhPgogICAgIFRo ZSBzdGF0aXN0aWNzIGdhdGhlcmVkIGJ5IHRoZSBtb2R1bGUgYXJlIG1hZGUg YXZhaWxhYmxlIHZpYSBhCiEgICAgdmlldyBuYW1lZCA8c3RydWN0bmFtZT5w Z19zdGF0X3N0YXRlbWVudHM8Lz4uICBUaGlzIHZpZXcKICAgICBjb250YWlu cyBvbmUgcm93IGZvciBlYWNoIGRpc3RpbmN0IGRhdGFiYXNlIElELCB1c2Vy IElEIGFuZCBxdWVyeQogICAgIElEICh1cCB0byB0aGUgbWF4aW11bSBudW1i ZXIgb2YgZGlzdGluY3Qgc3RhdGVtZW50cyB0aGF0IHRoZSBtb2R1bGUKICAg ICBjYW4gdHJhY2spLiAgVGhlIGNvbHVtbnMgb2YgdGhlIHZpZXcgYXJlIHNo b3duIGluCioqKioqKioqKioqKioqKgoqKiogMjE2LDIzNCAqKioqCiAgICA8 L3RhYmxlPgogIAogICAgPHBhcmE+Ci0gICAgVGhpcyB2aWV3LCBhbmQgdGhl IGZ1bmN0aW9ucyA8ZnVuY3Rpb24+cGdfc3RhdF9zdGF0ZW1lbnRzX3Jlc2V0 PC8+Ci0gICAgYW5kIDxmdW5jdGlvbj5wZ19zdGF0X3N0YXRlbWVudHM8Lz4s IGFyZSBhdmFpbGFibGUgb25seSBpbgotICAgIGRhdGFiYXNlcyB0aGV5IGhh dmUgYmVlbiBzcGVjaWZpY2FsbHkgaW5zdGFsbGVkIGludG8gYnkgaW5zdGFs bGluZwotICAgIHRoZSA8bGl0ZXJhbD5wZ19zdGF0X3N0YXRlbWVudHM8Lz4g ZXh0ZW5zaW9uLgotICAgIEhvd2V2ZXIsIHN0YXRpc3RpY3MgYXJlIHRyYWNr ZWQgYWNyb3NzIGFsbCBkYXRhYmFzZXMgb2YgdGhlIHNlcnZlcgotICAgIHdo ZW5ldmVyIHRoZSA8ZmlsZW5hbWU+cGdfc3RhdF9zdGF0ZW1lbnRzPC9maWxl bmFtZT4gbW9kdWxlIGlzIGxvYWRlZAotICAgIGludG8gdGhlIHNlcnZlciwg cmVnYXJkbGVzcyBvZiBwcmVzZW5jZSBvZiB0aGUgdmlldy4KLSAgIDwvcGFy YT4KLSAKLSAgIDxwYXJhPgogICAgIEZvciBzZWN1cml0eSByZWFzb25zLCBu b24tc3VwZXJ1c2VycyBhcmUgbm90IGFsbG93ZWQgdG8gc2VlIHRoZSBTUUwK ISAgICB0ZXh0IG9yIDxzdHJ1Y3RmaWVsZD5xdWVyeWlkPC9zdHJ1Y3RmaWVs ZD4gb2YgcXVlcmllcyBleGVjdXRlZCBieSBvdGhlciB1c2Vycy4gIFRoZXkg Y2FuIHNlZQohICAgIHRoZSBzdGF0aXN0aWNzLCBob3dldmVyLCBpZiB0aGUg dmlldyBoYXMgYmVlbiBpbnN0YWxsZWQgaW4gdGhlaXIKICAgICBkYXRhYmFz ZS4KICAgIDwvcGFyYT4KICAKLS0tIDIyNiwyMzQgLS0tLQogICAgPC90YWJs ZT4KICAKICAgIDxwYXJhPgogICAgIEZvciBzZWN1cml0eSByZWFzb25zLCBu b24tc3VwZXJ1c2VycyBhcmUgbm90IGFsbG93ZWQgdG8gc2VlIHRoZSBTUUwK ISAgICB0ZXh0IG9yIDxzdHJ1Y3RmaWVsZD5xdWVyeWlkPC9zdHJ1Y3RmaWVs ZD4gb2YgcXVlcmllcyBleGVjdXRlZCBieSBvdGhlciB1c2Vycy4KISAgICBU aGV5IGNhbiBzZWUgdGhlIHN0YXRpc3RpY3MsIGhvd2V2ZXIsIGlmIHRoZSB2 aWV3IGhhcyBiZWVuIGluc3RhbGxlZCBpbiB0aGVpcgogICAgIGRhdGFiYXNl LgogICAgPC9wYXJhPgogIAo= --------------080409080106040305010905 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 --------------080409080106040305010905--