Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j2BEC-0002MZ-Ka for pgsql-docs@arkaria.postgresql.org; Thu, 13 Feb 2020 09:56:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j2BEB-0005PV-Fy for pgsql-docs@arkaria.postgresql.org; Thu, 13 Feb 2020 09:56:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j21rW-0006nH-Eo for pgsql-docs@lists.postgresql.org; Wed, 12 Feb 2020 23:56:10 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j21rR-0006Xa-Nh for pgsql-docs@lists.postgresql.org; Wed, 12 Feb 2020 23:56:09 +0000 Content-Type: multipart/mixed; boundary="===============0762293725422792143==" MIME-Version: 1.0 Subject: pg_buffercache query example results misleading, grouping by just relname, needs schema_name To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: adunham@arbormetrix.com Reply-To: adunham@arbormetrix.com, pgsql-docs@lists.postgresql.org Date: Wed, 12 Feb 2020 23:55:51 +0000 Message-ID: <158155175140.23798.2189464781144503491@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0762293725422792143== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9wZ2J1 ZmZlcmNhY2hlLmh0bWwKRGVzY3JpcHRpb246CgpUaGUgcGdfYnVmZmVyY2FjaGUgcXVlcnkgZXhh bXBsZSByZXN1bHRzIGFyZSBtaXNsZWFkaW5nLiBUaGUgImdyb3VwIGJ5IiB1c2VzCmp1c3QgYnkg cmVsbmFtZS4gSXQgbmVlZHMgdG8gaW5jbHVkZSBwZ19uYW1lc3BhY2UubnNwbmFtZSwgd2l0aG91 dCBpdCwgaWYKdGhlIHNhbWUgb2JqZWN0IGV4aXN0cyBpbiBtdWx0aXBsZSBzY2hlbWFzLCB0aGUg YnVmZmVyIGNvdW50IGlzIHN1bW1lZCBmb3IKdGhvc2UgbXVsdGlwbGUgZGlzdGluY3Qgb2JqZWN0 cy4gIA0KSW46IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTIvcGdidWZmZXJjYWNo ZS5odG1sDQpBbHRlcm5hdGl2ZSBTUUwgKHRoZSBjb3VudCBpcyBub3cgY29ycmVjdCBmb3IgdGFi bGVzIGluIG11bHRpcGxlIHNjaGVtYXMpOg0KU0VMRUNUIHRzLm5zcG5hbWUgQVMgc2NoZW1hX25h bWUsYy5yZWxuYW1lLCBjb3VudCgqKSBBUyBidWZmZXJzDQogICAgICAgICAgICAgRlJPTSBwZ19i dWZmZXJjYWNoZSBiIElOTkVSIEpPSU4gcGdfY2xhc3MgYw0KICAgICAgICAgICAgIE9OIGIucmVs ZmlsZW5vZGUgPSBwZ19yZWxhdGlvbl9maWxlbm9kZShjLm9pZCkgQU5EDQogICAgICAgICAgICAg ICAgYi5yZWxkYXRhYmFzZSBJTiAoMCwgKFNFTEVDVCBvaWQgRlJPTSBwZ19kYXRhYmFzZQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBXSEVSRSBkYXRuYW1lID0gY3VycmVu dF9kYXRhYmFzZSgpKSkNCiAgICAgICAgICAgICBKT0lOIHBnX25hbWVzcGFjZSB0cyBPTiB0cy5v aWQgPSBjLnJlbG5hbWVzcGFjZQ0KICAgICAgICAgICAgIEdST1VQIEJZIHRzLm5zcG5hbWUsYy5y ZWxuYW1lDQogICAgICAgICAgICAgT1JERVIgQlkgYnVmZmVycyBERVNDDQogICAgICAgICAgICAg TElNSVQgMTA7DQoNCkV4YW1wbGUgUmVzdWx0czoNCkN1cnJlbnQgUXVlcnkgcmV0dXJucyAxIHJv dyB3aXRoIGJ1ZmZlciBjb3VudCBzdW1tZWQgZm9yIDMgdGFibGVzOg0KcmVsbmFtZQlidWZmZXJz DQp0YWIxCTcyNDAxDQoNCk1vZGlmaWVkIFF1ZXJ5Og0Kc2NoZW1hX25hbWUJcmVsbmFtZQlidWZm ZXJzDQpzY2hlbWExCXRhYjEJMTg4Mw0Kc2NoZW1hMgl0YWIxCTY5OTYxDQpzY2hlbWEzCXRhYjEJ NTU3Cg== --===============0762293725422792143==--