Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aGsQI-0000Ml-9j for pgsql-performance@arkaria.postgresql.org; Wed, 06 Jan 2016 18:03:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aGsQH-0006Bs-SB for pgsql-performance@arkaria.postgresql.org; Wed, 06 Jan 2016 18:03:01 +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_SHA384:256) (Exim 4.84) (envelope-from ) id 1aGsOb-0006Ic-35 for pgsql-performance@postgresql.org; Wed, 06 Jan 2016 18:01:17 +0000 Received: from mail-by2on0070.outbound.protection.outlook.com ([207.46.100.70] helo=na01-by2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aGsOX-0004VB-Ax for pgsql-performance@postgresql.org; Wed, 06 Jan 2016 18:01:16 +0000 Received: from BY2PR02MB075.namprd02.prod.outlook.com (10.242.42.154) by BY2PR02MB219.namprd02.prod.outlook.com (10.242.232.23) with Microsoft SMTP Server (TLS) id 15.1.361.13; Wed, 6 Jan 2016 18:01:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=corprsinc.onmicrosoft.com; s=selector1-motus-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=9792E+z289C84lffUiVPbDitNpizf0KXDF7nhJo01/U=; b=JOYcbXw/UykVslZtSYiAdUq1mn3wUCQekChQ6xTtx3L6B6aulHdEsshFJBM8Ib2i7QtpqLIr2dQMd1fQqDBV8QEp64uQyTUkG9BN6WlQrX48vMwEp8Dhjpud0EAOaIcU2n5e/h1Nsz+pJBwxhN56FKp9Mcp3JsC4KfXc5Od6zEc= Received: from BY2PR02MB074.namprd02.prod.outlook.com (10.242.42.153) by BY2PR02MB075.namprd02.prod.outlook.com (10.242.42.154) with Microsoft SMTP Server (TLS) id 15.1.361.13; Wed, 6 Jan 2016 18:01:06 +0000 Received: from BY2PR02MB074.namprd02.prod.outlook.com ([169.254.9.235]) by BY2PR02MB074.namprd02.prod.outlook.com ([169.254.9.235]) with mapi id 15.01.0361.006; Wed, 6 Jan 2016 18:01:06 +0000 From: Scott Rankin To: Tom Lane CC: "pgsql-performance@postgresql.org" Subject: Re: Queries intermittently slow Thread-Topic: [PERFORM] Queries intermittently slow Thread-Index: AQHRSJKlgEdVNZa6nU6mq1bDTVSp857umg+A//+vhoCAAFXvgP//sVYAgABYsICAAAT8AP//xQSA Date: Wed, 6 Jan 2016 18:01:05 +0000 Message-ID: References: <2A061A33-9E7C-44ED-A8A4-411FE128A1C9@motus.com> <25400.1452093555@sss.pgh.pa.us> <7EC59C76-D8FF-4880-8A50-9F1195D5D00E@motus.com> <26050.1452094727@sss.pgh.pa.us> <27999.1452096879@sss.pgh.pa.us> <28587.1452097950@sss.pgh.pa.us> In-Reply-To: <28587.1452097950@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=srankin@motus.com; x-ms-exchange-messagesentrepresentingtype: 1 x-originating-ip: [66.31.30.148] x-microsoft-exchange-diagnostics: 1; BY2PR02MB075; 5:jVy8lgj+pwUSQ6Uo6pPUYjoJc7faumjwGgcXo20QUByF1RD2/zdXo/MjVYkRRQvhzezYKukV9okrmzbj/C/kpjxgDDZNwRMtR05siN7wDdT1vfvzJsWg4d4KjfAa6iGzX8WoWnOz+rOfCQQbtzkDIg==; 24:rM2zATq8wyfyEn8llF41AOvzHXfEDfhemkPwg2o4FB8cswpdB3oq8z2Mzw8g8LGVoSol+ADnD5hJRwqRjmFAOoR+zOUv5LkzfhRuCO5uv38= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BY2PR02MB075; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0; PCL:0; RULEID:(601004)(2401047)(5005006)(520078)(8121501046)(10201501046)(3002001); SRVR:BY2PR02MB075; BCL:0; PCL:0; RULEID:; SRVR:BY2PR02MB075; x-forefront-prvs: 0813C68E65 x-forefront-antispam-report: SFV:NSPM; SFS:(10009020)(6009001)(199003)(189002)(164054003)(189998001)(4326007)(5008740100001)(50986999)(2950100001)(105586002)(40100003)(106356001)(5001960100002)(102836003)(92566002)(551934003)(81156007)(83716003)(110136002)(97736004)(11100500001)(87936001)(82746002)(106116001)(122556002)(54356999)(101416001)(36756003)(1096002)(66066001)(6116002)(76176999)(93886004)(3846002)(5004730100002)(99286002)(1220700001)(5002640100001)(33656002)(86362001)(10400500002)(586003)(2900100001)(104396002); DIR:OUT; SFP:1101; SCL:1; SRVR:BY2PR02MB075; H:BY2PR02MB074.namprd02.prod.outlook.com; FPR:; SPF:None; PTR:InfoNoRecords; A:1; MX:1; LANG:en; received-spf: None (protection.outlook.com: motus.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Jan 2016 18:01:05.9027 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 849c4293-31ae-4825-a834-b8bb5ab65c28 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2PR02MB075 X-Microsoft-Exchange-Diagnostics: 1; BY2PR02MB219; 2:ZzVLj2JW6Zng9XxZItyTleTEnnP2KL81xoDVHzl/CnF3i12He91xEcZhJ3aQCcAAhzH6FiQvycaneGopXUr8BoKGt9UDtA5vRjLAsIJMqu6uoU2L0pOz2Sx6YWeMBTxXkSxY+F33seFJ8NcZ2w0eJA==; 23:sSc4LD9yeItIYwt5RbCOQcCTCUOS1MRlbvi64JtDnkw7tf1TkhqXo1wJhljJgHEECGpCaJIfsY1gfbmU1ox7lvbhRrTTI18c92/+/whtobQh+iga6WmaTeL/nm+w45PBYSZp2QTGqeVFWb0xnC7E9R9tzXJcwI62cov1kSNVf7mFi7VcdUhY3AGOX/6ZhAwI X-OriginatorOrg: motus.com X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Pg0KPlNvIHdoYXQgc2VlbXMgbW9yZSBsaWtlbHkgYWZ0ZXIgbW9yZSB0aG91 Z2h0IGlzIHRoYXQgdGhlIHBhZ2VzIGFyZSBzdGF5aW5nDQo+aW4gb3VyIHNo YXJlZCBidWZmZXIgYXJlbmEganVzdCBmaW5lLCBidXQgdGhlIGtlcm5lbCBp cyByYW5kb21seSBjaG9vc2luZw0KPnRvIHN3YXAgb3V0IHBhcnRzIG9mIHRo ZSBhcmVuYSwgYW5kIHRoZSBkZWxheXMgY29ycmVzcG9uZCB0byBzd2FwLWlu DQo+d2FpdHMuICAoVGhlcmUgd291bGQgc3RpbGwgaGF2ZSB0byBiZSBhIG1p Z2h0eSBjcnVtbXkgZGlzayBzdWJzeXN0ZW0NCj51bmRlcmx5aW5nIHRoaW5n cyBmb3Igc3dhcC1pbiB0byB0YWtlIHNvIGxvbmcsIGJ1dCB0aGlzIGlzIGEg bW9yZQ0KPnBsYXVzaWJsZSB0aGVvcnkgZm9yIGV4YWN0bHkgd2hhdCdzIGlu dm9raW5nIHRoZSBkaXNrIHJlYWQuKQ0KPg0KPlBvc3RncmVzIGNhbid0IGRp cmVjdGx5IHNlZSB3aGVuIHRoaXMgaXMgaGFwcGVuaW5nLCBidXQgeW91IGNv dWxkIHRyeQ0KPndhdGNoaW5nICJpb3N0YXQgMSIgYW5kIG5vdGljaW5nIHdo ZXRoZXIgc3dhcC1pbiBldmVudHMgc2VlbSB0byBiZQ0KPmNvcnJlbGF0ZWQg d2l0aCB0aGUgc2xvdyBxdWVyaWVzLg0KPg0KPklmIHRoaXMgaXMgdGhlIHBy b2JsZW0sIHRoZW4gdGhlIGFuc3dlciBpcyB0byByZWR1Y2UgdGhlIHByZXNz dXJlIG9uDQo+c3lzdGVtIG1lbW9yeSBzbyB0aGF0IHN3YXAtb3V0cyBhcmUg bGVzcyBsaWtlbHkuICBZb3UgbWlnaHQgZmluZCB0aGF0DQo+YSBzbWFsbGVy IHNoYXJlZF9idWZmZXIgYXJlbmEgaXMgYSBnb29kIHRoaW5nIChzbyB0aGF0 IGFsbCBvZiBpdCBzdGF5cw0KPiJob3QiIGFuZCB1bnN3YXBwYWJsZSBmcm9t IHRoZSBrZXJuZWwncyBwZXJzcGVjdGl2ZSkuICBPciByZWR1Y2UgdGhlDQo+ bnVtYmVyIG9mIGFjdGl2ZSBiYWNrZW5kIHByb2Nlc3Nlcy4NCj4NCj5yZWdh cmRzLCB0b20gbGFuZQ0KDQpPbmUgY2hhbmdlIHRvIG15IHNldHVwIHRoYXQg bXkgc2VydmVyIGd1eSBwb2ludGVkIG91dCAtIHRoaXMgZGF0YWJhc2Ugc2Vy dmVyIGlzICpub3QqIGEgY2xvdWQgc2VydmVyLCBidXQgaW4gZmFjdCBhIHBo eXNpY2FsIERlbGwgYm94IHdpdGggU1NEcy4gIFNvIHVubGVzcyBzb21ldGhp bmcgaXMgbWFqb3JseSB3cm9uZyB3aXRoIG91ciBkaXNrIHNldHVwLCBkaXNr IElPIHNob3VsZCBub3QgYmUgYSBmYWN0b3IuDQoNCkkgYWxzbyBjaGVja2Vk IGFuZCB0aGUgYm94IGlzIG5vdCBzd2FwcGluZyBhdCBhbGwuDQoNCkkgZ3Vl c3Mgd2XigJlyZSBiYWNrIHRvIGxvY2sgY29udGVudGlvbj8NCg0KVGhhbmtz LA0KU2NvdHQNClRoaXMgZW1haWwgbWVzc2FnZSBjb250YWlucyBpbmZvcm1h dGlvbiB0aGF0IE1vdHVzLCBMTEMgY29uc2lkZXJzIGNvbmZpZGVudGlhbCBh bmQvb3IgcHJvcHJpZXRhcnksIG9yIG1heSBsYXRlciBkZXNpZ25hdGUgYXMg Y29uZmlkZW50aWFsIGFuZCBwcm9wcmlldGFyeS4gSXQgaXMgaW50ZW5kZWQg b25seSBmb3IgdXNlIG9mIHRoZSBpbmRpdmlkdWFsIG9yIGVudGl0eSBuYW1l ZCBhYm92ZSBhbmQgc2hvdWxkIG5vdCBiZSBmb3J3YXJkZWQgdG8gYW55IG90 aGVyIHBlcnNvbnMgb3IgZW50aXRpZXMgd2l0aG91dCB0aGUgZXhwcmVzcyBj b25zZW50IG9mIE1vdHVzLCBMTEMsIG5vciBzaG91bGQgaXQgYmUgdXNlZCBm b3IgYW55IHB1cnBvc2Ugb3RoZXIgdGhhbiBpbiB0aGUgY291cnNlIG9mIGFu eSBwb3RlbnRpYWwgb3IgYWN0dWFsIGJ1c2luZXNzIHJlbGF0aW9uc2hpcCB3 aXRoIE1vdHVzLCBMTEMuIElmIHRoZSByZWFkZXIgb2YgdGhpcyBtZXNzYWdl IGlzIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCBvciB0aGUgZW1wbG95 ZWUgb3IgYWdlbnQgcmVzcG9uc2libGUgdG8gZGVsaXZlciBpdCB0byB0aGUg aW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0 aGF0IGFueSBkaXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24sIG9yIGNvcHlp bmcgb2YgdGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0 ZWQuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBp biBlcnJvciwgcGxlYXNlIG5vdGlmeSBzZW5kZXIgaW1tZWRpYXRlbHkgYW5k IGRlc3Ryb3kgdGhlIG9yaWdpbmFsIG1lc3NhZ2UuDQoNCkludGVybmFsIFJl dmVudWUgU2VydmljZSByZWd1bGF0aW9ucyByZXF1aXJlIHRoYXQgY2VydGFp biB0eXBlcyBvZiB3cml0dGVuIGFkdmljZSBpbmNsdWRlIGEgZGlzY2xhaW1l ci4gVG8gdGhlIGV4dGVudCB0aGUgcHJlY2VkaW5nIG1lc3NhZ2UgY29udGFp bnMgYWR2aWNlIHJlbGF0aW5nIHRvIGEgRmVkZXJhbCB0YXggaXNzdWUsIHVu bGVzcyBleHByZXNzbHkgc3RhdGVkIG90aGVyd2lzZSB0aGUgYWR2aWNlIGlz IG5vdCBpbnRlbmRlZCBvciB3cml0dGVuIHRvIGJlIHVzZWQsIGFuZCBpdCBj YW5ub3QgYmUgdXNlZCBieSB0aGUgcmVjaXBpZW50IG9yIGFueSBvdGhlciB0 YXhwYXllciwgZm9yIHRoZSBwdXJwb3NlIG9mIGF2b2lkaW5nIEZlZGVyYWwg dGF4IHBlbmFsdGllcywgYW5kIHdhcyBub3Qgd3JpdHRlbiB0byBzdXBwb3J0 IHRoZSBwcm9tb3Rpb24gb3IgbWFya2V0aW5nIG9mIGFueSB0cmFuc2FjdGlv biBvciBtYXR0ZXIgZGlzY3Vzc2VkIGhlcmVpbi4NCgotLSAKU2VudCB2aWEg cGdzcWwtcGVyZm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3Jt YW5jZUBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIg c3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxw cmVmL3Bnc3FsLXBlcmZvcm1hbmNlCg==