Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aH20J-00045j-AI for pgsql-performance@arkaria.postgresql.org; Thu, 07 Jan 2016 04:16:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aH20I-0003MX-PL for pgsql-performance@arkaria.postgresql.org; Thu, 07 Jan 2016 04:16:50 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aH1yd-0001RZ-QF for pgsql-performance@postgresql.org; Thu, 07 Jan 2016 04:15:08 +0000 Received: from mail-by2on0077.outbound.protection.outlook.com ([207.46.100.77] helo=na01-by2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aH1ya-0005F1-8v for pgsql-performance@postgresql.org; Thu, 07 Jan 2016 04:15:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=a7lWZ81+Pkcyi8YhJKH9DEvUWwJmhov/Ip9zQ5jC9s0=; b=U/FxdmLNi9/9rnD6D+lX9RUqjLMmAuI3cWh3zDU/2eGf2TsVAMNljJASrQDo1pRxrrUNFR62Bt4wHGJsFdeA9kjpD8CvI39RffZVXjbO1hhD9n+HzCucM/8NoTjHz2Y5NQwzvjXLoIuiF8cJgZCSsicqtQ8zmNlWaMfKjynBmfk= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:659c:6b73:4a76:ca79) by CY1PR11MB0684.namprd11.prod.outlook.com (10.163.236.22) with Microsoft SMTP Server (TLS) id 15.1.361.13; Thu, 7 Jan 2016 04:15:00 +0000 Subject: Re: Queries intermittently slow To: Scott Rankin , Tom Lane 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> CC: "pgsql-performance@postgresql.org" From: Jim Nasby Message-ID: <568DE640.5070508@BlueTreble.com> Date: Wed, 6 Jan 2016 22:14:56 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 8bit X-Originating-IP: [2602:306:ce8b:3460:659c:6b73:4a76:ca79] X-ClientProxiedBy: CY1PR12CA0050.namprd12.prod.outlook.com (25.163.230.18) To CY1PR11MB0684.namprd11.prod.outlook.com (25.163.236.22) X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0684; 2:lJO6rFujl67DgBDezeL2GMPz3Ihy/kCxmVKQjFQpgmD4mU9cEGMPptDfAD7pVOcOofcibdm8D1vhWyozFwZPJ3b8Vc0dIZmRyuxhpX/US9VcvVah7yo+dJ7fcclQZR3uZUjRrw4yZ2AIkqodbhNgNQ==; 3:2tnZFgVk60YlsxpoUmJboFi9XapyI85ZCMYTjyzrqEtyMsw/D1FiWnyEeVnIbIVrOSzbpsP3LFWY0KilHs1troR/oa+IHjKIbgUP/yaFLdo+3WxrKbXKveZLjmuLjUTa; 25:TzG2FR6UwH1G0YoAMGPUk3XUl9kGQGne5OMm6iPWAKuUFE9KI//4NRh/Q4dhL6QDja4dxsm0KzRr9Vfd8wql4tLoT4e6xTmjvLdMdv4a2nZ+9Z6PNd9HSO/EUfyjN4mVCNR8AS/x0cfvkBQqDq5WzdTh0Ru/92+W7kWhSc+VqFjPoUtLaeTC0rXEUMGC4j6OQ7rlULBXO2JCQlAuxJlK2g==; 20:DF0cAzBaKw0o8TXu67xmVdT3Pd9bvNm+illldZLSBZGZlOUvrrlngvQhAg20/t4z2ZsIb/gEsIW8PGxfIGxud+GmZQily/nqvjnW5Eu7Jg0gxQlZJtLEDELmK1ebj1IOv/Ai6emmQvHAC/wdseRxp5rFAzO9vNrNrbaowJvm/jM= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY1PR11MB0684; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(8121501046)(520078)(5005006)(3002001)(10201501046); SRVR:CY1PR11MB0684; BCL:0; PCL:0; RULEID:; SRVR:CY1PR11MB0684; X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0684; 4:Xv///Nv41OsLn9bVtkfjcb/xImIaPK5E0gVH+qqqjacZnPavzps+ynB8hCgmOmeHEtdRerknA2ohsSq6WNAAZkorfAGqnldl5gSNM5yY5pRk229sDf6g6lsQMGnRw1cRdMXiIK8gg6Xe4Hsu2EHZXDLUWcpXnnJvlFePh7I2LbZx+ano+C9l9+53Id2UeTo8KRAyPrV2PhZ3xxdJ6jOTRJesfGhoi2f9/g0PW9DXkerZrZ291T+Qv/8cFRqtaPaLaYgr74wP8R6NgjaRD47AdqtWIFhe2U1W0dvrOG9GQZDuQo9yj1hg9AT5AltBgJKlmKNvUwMDCUKHl3yPKcV1gXuKYhXpkG8w2+sdpa0PMeZrv5HzXmkjq9NOcKca2EYn X-Forefront-PRVS: 0814A2C7A3 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(479174004)(24454002)(189002)(377454003)(199003)(92566002)(19580395003)(54356999)(87976001)(23676002)(36756003)(69596002)(2906002)(87266999)(50986999)(101416001)(59896002)(65806001)(65956001)(5004730100002)(33656002)(4326007)(47776003)(76176999)(5001960100002)(586003)(106356001)(5008740100001)(6116002)(189998001)(80316001)(53416004)(77096005)(5001770100001)(65816999)(86362001)(93886004)(83506001)(64126003)(42186005)(50466002)(40100003)(105586002)(97736004)(81156007)(4001350100001)(15975445007)(122386002)(2950100001)(1096002)(3826002)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:CY1PR11MB0684; H:decina.attlocal.net; FPR:; SPF:None; PTR:InfoNoRecords; MX:1; A:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtDWTFQUjExTUIwNjg0OzIzOi9UakNoSjFGaDZBZmtkS3VvdjQwZklLWUJo?= =?utf-8?B?TXVOS0hDcGp2RDNwUFVZdGJoUGs0dE0vdVpvTmJGY1RKdVNXeEZtYUFnWWoy?= =?utf-8?B?VjF3RWV2SE92VUgxc3l2aGlDL2R5K3JuZFB0MWloQ2hRdG5PS2wrMzZNcmQ0?= =?utf-8?B?NHNCRkFCMEhLNy9saWRzMjd0UUpjSG5mQkVKTFFBUGhPdGgrNWdwNzZqMDJk?= =?utf-8?B?cW5iYVJ5YnNVRGpjNFZtSG1LT3pvWGhabEh4bmFrOVlsZDR6NVBsYmo5ZDdU?= =?utf-8?B?OEQ5Z1NySkZuYjRpUVJ5bm9WRHdwTThWMmR3MEVVR3NiUGFMZEZTNzM3R1cx?= =?utf-8?B?d3hXVWFrOXdYekN2QXVaK3BnWWp0bkRDSTVWVldwSGZiaUNIVnBYQzR3eXVZ?= =?utf-8?B?OHlNYUp5SGNncmpoeHBUWFBDcUVMYzNBai9BMW1UU253bjhzak5TMUYxakdy?= =?utf-8?B?VWYyTkpMMEIybTZBOFZ2Zk5VaVZRR25zeTVzMW84MW9Ka2RqNXlLaXJhTDhP?= =?utf-8?B?eVdZQnhaK05uTFpURHlvTW1ZdjVPWFRxUzFHNEwwenZhUnVicFFhelZiOFow?= =?utf-8?B?U01KdFN0ZUJHcGZydm8yL1ZQU2xqaWF1SHB1eWlLbkRRWFdwcXFjTDlzNkt3?= =?utf-8?B?dTMwN0NIa0M3MkxNT3FGekxrVnVxNWx2SHNtSXlDQWNnd2ZOaStQUEFPVkVW?= =?utf-8?B?MlZaWGJDbk16Tk04QjBiQ2wwSTVJTTJtS1A1SFFZam50NEdIQkhJMUNxK3RM?= =?utf-8?B?VmphNUc3bTFSTTFRYzdDdnlxSGZ1MXgvR2h2RHN1cmk2UGFyZDNNMkE0Z2U1?= =?utf-8?B?VmNpNHJhWVdidm9iSXVDK2k1eDlVRnNBdUFkY3Z3SW9DMjMvK25JbTBiVjQz?= =?utf-8?B?N0xMTlJ3bmdBNFNFdlN0NjdZRHpCNFg4ZXhuRXZkZ0prUDQyRUlVMFk1aVhy?= =?utf-8?B?bXN3elRmQjIzNHo5YVdBcEkxeld5cTJZMTVFbHpwSHdYRm5Sa2FaUlFjTFNw?= =?utf-8?B?a2xJNUU1aWYwU2hqdDRpRklYNk9xYk5PTXVzWUJza1Z3UFovWG42cEt1ZG5m?= =?utf-8?B?THFzQ3BGSlFsU0dPN2I2bnJCc1k2L2JpcmpXRUZjbEdCaFo0RjBSZCsvMDdp?= =?utf-8?B?R2NTdS9XeExNSGg4SVhUblR4b2hWMjd6QVFZQnV5Zjd3bUxzMjFvRUJOYkp6?= =?utf-8?B?K1JqWDAzcERFeGFySXpndEpDRnR4WFI3OUk4aElNWFhndkxUN2daZ3hzcWk0?= =?utf-8?B?WW1oTlhiSGZtSitnUXBHUDRxU0FTMXVCVG80UmZydUxiRzc2WGxheU1qQ3J4?= =?utf-8?B?V0c4b3lPcWdjNjJ6WmlQOXF3YWFEeXBmVXZXU1pvMTNiZjU1c0VjS0tWN2Nx?= =?utf-8?B?cElrSHBoMFNHbllNUHVQR2FKSUIvNGdtMWt6alRPaGFWUC9rTTlPNVN2MUVJ?= =?utf-8?B?K0tQdlhQMUxuOERDdi9VQmF0K1FiOVI5eGNuVWJDc2lCdlVqZzNnYjBKY29I?= =?utf-8?B?TGVxTk0wa0czcjNTNnE4UDB5KytVaVozUTRxYUZaUGpMVDJydXgwS3U4M0JM?= =?utf-8?B?a3dydUNDaE04UHVTdlRKTDNxbWZmZW5NTnJvSkRldm95cXZWV1FoMTNURlNG?= =?utf-8?B?RWxuSUNQaVB2aXIzL3lwbXNsTDZpaDU3MHd4NFJHZE5YUnVmNWRLcTNucys1?= =?utf-8?B?bFpPNFdhOW5Kb1NTU1hxTWJVSDBkNzhVK2Nkdm15SGNXYklsZ0xXQ2p3aC9w?= =?utf-8?B?Mk85Ym9JRGcwNk9YN0JYUWkwNE81V1ZjTjVDR2RZZ2hrSmpRSVRRS0ZCSGNz?= =?utf-8?B?RUxQRm5TQXo3OW1RWmVLVDRpUUZmTWxwZXZraXJYUUU3MUlCTWhHMVQ5T1RS?= =?utf-8?Q?NxhOs1fjgVxlMINy66ByVN+H9eFTy+yL?= X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0684; 5:YyMGQe2Ur38+WGoGrDuz1rPFrEDRwBMF4jvtGmA9uPiUsiHfqalRUqRRISTwZf4AzXQJwRZo0s+SnOTgzFIxJBscci9ejPXMlNQHqzvFKdRNSlBhBKo9+qBCiLZRHQXDtkmCCwr5uQmQASrkVAsXyA==; 24:IXiWs9fOhz7dLAYVw3iUF35XfOeaPuIaoQuyGPFUSQ/etFOODlpt/5om8v+rY6H3MJ3piT4KbE+FiYnZUlEs9JFzC6ecNZUitAlNAtNLqcM= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 07 Jan 2016 04:15:00.4416 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR11MB0684 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 On 1/6/16 12:01 PM, Scott Rankin wrote: > I guess we’re back to lock contention? Is there by chance an anti-wraparound vacuum happening on that table? Actually, for that matter... if autovacuum is hitting that table it's locking could be causing problems, and it won't release it's locks until the deadlock detector kicks in. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance