Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cPDIR-00039Y-KN for pgsql-performance@arkaria.postgresql.org; Thu, 05 Jan 2017 19:01:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cPDIR-0005ya-7C for pgsql-performance@arkaria.postgresql.org; Thu, 05 Jan 2017 19:01:55 +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_2) (envelope-from ) id 1cPDIQ-0005wf-GH for pgsql-performance@postgresql.org; Thu, 05 Jan 2017 19:01:54 +0000 Received: from mail-qt0-x236.google.com ([2607:f8b0:400d:c0d::236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cPDIN-0002oE-Rt for pgsql-performance@postgresql.org; Thu, 05 Jan 2017 19:01:53 +0000 Received: by mail-qt0-x236.google.com with SMTP id v23so59377505qtb.0 for ; Thu, 05 Jan 2017 11:01:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=APG0Rro4GHZsnId2CmTuVwqlcK8VzzFfdYkd+BqzHqI=; b=LxRivVakaFcBxEJAWwcW4Pjz2GjSf7/Z1tRj4S54ecnXS8eH0LqdcroU8faEsd/7vJ ZxU6tcuSpUkPnGJCaoUYHjupN8ZRVUyyXmv7zVVzXX64IWuDOFsjXqi8s85WH/oawMCN PA4o64M72bu/XpAIV7nV/SSx7LygSvXX6HefJfdvJoPBjo5EIrUtBwGu5mFQgzqtLhZ2 mMqXz3AT3mzPPcKS/IfI25CWaMm5pem3RdTbdmFsxZ6KCVcT9Gkl2CKpmhH4T7+H6+4y pp16JzMBZ6cVRUlhDAzhnh+4x/0cqwALBNzRYuWe8OWoxK3qRdZYpGpZrVYfWb/jAbGG Uj4g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=APG0Rro4GHZsnId2CmTuVwqlcK8VzzFfdYkd+BqzHqI=; b=alwaLtL/MNyVgWyfehWkhp3s81S7fO80vFTT5WkgAnKxpOjReDDFEkQbEzjB1H844U fM+S8qNiVzrhtGdJO7E+6ia0Vgnri1bobT/ljPGii0s/62fL7TAjHB8ykL2uMnQEwKT2 4USCwxuCZgD3KDF5+I+8JoodhV0/2atViSD/vUvniCls4PQ8ck4RzUM+/w7ZqVVoQ2r8 0LSmvKCUwW2TTocyUpJzZpBqS9XCMub7F5NfWB8I6dBGHP9o2hh175ZopdBdbMMZjRnP lGiSoSpthKk/+y/yolpzDHqzlQ3QZJfhouYJE9vX+oUQBqvZpQn703fVRE6JaNZklR0l uv0w== X-Gm-Message-State: AIkVDXLVDd/i3DbNVf8g1Hy0OCBdtjLlrnxvBNVnrHu5Ui7/dMyLEc24SgTxZOF3eLjnkfOee07YYIx6+PbT2Q== X-Received: by 10.237.53.253 with SMTP id d58mr68425076qte.29.1483642910745; Thu, 05 Jan 2017 11:01:50 -0800 (PST) MIME-Version: 1.0 Received: by 10.12.169.2 with HTTP; Thu, 5 Jan 2017 11:01:50 -0800 (PST) In-Reply-To: References: From: Merlin Moncure Date: Thu, 5 Jan 2017 13:01:50 -0600 Message-ID: Subject: Re: Slow query after 9.3 to 9.6 migration To: =?UTF-8?Q?Fl=C3=A1vio_Henrique?= Cc: postgres performance list Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 X-Pg-Spam-Score: -2.7 (--) 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 T24gVGh1LCBKYW4gNSwgMjAxNyBhdCAxMDo1MSBBTSwgRmzDoXZpbyBIZW5y aXF1ZSA8eW9zaGltaXRAZ21haWwuY29tPiB3cm90ZToNCj4gQE1lcmxpbiBN b25jdXJlDQo+Pg0KPj4gQmlnIGdhaW5zIChpZiBhbnkpIGFyZSBsaWtlbHkg ZHVlIHRvIGluZGV4aW5nIHN0cmF0ZWd5Lg0KPj4gSSBkbyBzZWUgc29tZSBz dXNwaWNpb3VzIGNhc3RpbmcsIGZvciBleGFtcGxlOg0KPj4gSm9pbiBGaWx0 ZXI6ICgoZm91cl9jaGFybGllLmRlbHRhX3RhbmdvKTo6aW50ZWdlciA9DQo+ PiAoc2l4X3F1ZWJlYy5nb2xmX2JyYXZvKTo6aW50ZWdlcikNCj4+IEFyZSB5 b3UgY2FzdGluZyBpbiB0aGUgcXVlcnkgb3Igam9pbmluZyB0aHJvdWdoIGRp c3NpbWlsYXIgZGF0YSB0eXBlcz8NCj4NCj4gTm8gY2FzdHMgaW4gcXVlcnku IFRoZSBqb2lucyBhcmUgb24gc2FtZSBkYXRhIHR5cGVzLg0KDQp3ZWxsLCBz b21ldGhpbmcgaXMgZ29pbmcgb24uDQoNCmNyZWF0ZSB0YWJsZSB0KGkgaW50 KTsNCmNyZWF0ZSB0YWJsZSB0MihpIGludCk7DQpzZXQgZW5hYmxlX2hhc2hq b2luIHRvIGZhbHNlOw0Kc2V0IGVuYWJsZV9tZXJnZWpvaW4gdG8gZmFsc2U7 DQoNCnlpZWxkczoNCg0KcG9zdGdyZXM9IyBleHBsYWluIHNlbGVjdCAqIGZy b20gdCBqb2luIHQyIG9uIHQuaSA9IHQyLmk7DQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgUVVFUlkgUExBTg0K4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQog TmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjk3NjE0Ljg4IHJvd3M9MzI1MTIg d2lkdGg9OCkNCiAgIEpvaW4gRmlsdGVyOiAodC5pID0gdDIuaSkNCiAgIC0+ ICBTZXEgU2NhbiBvbiB0ICAoY29zdD0wLjAwLi4zNS41MCByb3dzPTI1NTAg d2lkdGg9NCkNCiAgIC0+ICBNYXRlcmlhbGl6ZSAgKGNvc3Q9MC4wMC4uNDgu MjUgcm93cz0yNTUwIHdpZHRoPTQpDQogICAgICAgICAtPiAgU2VxIFNjYW4g b24gdDIgIChjb3N0PTAuMDAuLjM1LjUwIHJvd3M9MjU1MCB3aWR0aD00KQ0K DQpwbGVhc2Ugbm90ZSB0aGUgbm9uLWNhc3RlZCBqb2luIGZpbHRlci4NCg0K aG93ZXZlciwNCg0KcG9zdGdyZXM9IyBleHBsYWluIHNlbGVjdCAqIGZyb20g dCBqb2luIHQyIG9uIHQuaTo6YmlnaW50ID0gdDIuaTo6YmlnaW50Ow0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4NCuKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU gOKUgOKUgOKUgA0KIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi4xMzAxMjcu Mzggcm93cz0zMjUxMiB3aWR0aD04KQ0KICAgSm9pbiBGaWx0ZXI6ICgodC5p KTo6YmlnaW50ID0gKHQyLmkpOjpiaWdpbnQpDQogICAtPiAgU2VxIFNjYW4g b24gdCAgKGNvc3Q9MC4wMC4uMzUuNTAgcm93cz0yNTUwIHdpZHRoPTQpDQog ICAtPiAgTWF0ZXJpYWxpemUgIChjb3N0PTAuMDAuLjQ4LjI1IHJvd3M9MjU1 MCB3aWR0aD00KQ0KICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHQyICAoY29z dD0wLjAwLi4zNS41MCByb3dzPTI1NTAgd2lkdGg9NCkNCg0Kbm90aWNlIHRo ZSBjYXN0cyBpbiB0aGUgam9pbiBmaWx0ZXIuICAgRnVydGhlcm1vcmUsIHBs ZWFzZSBub3RlIHRoZQ0KaGlnaGVyICBxdWVyeSBjb3N0IGR1ZSB0byB0aGUg c2VydmVyIGFjY291bnRpbmcgZm9yIHRoZSBjYXN0aW5nDQppbnZvbHZlZCBp biB0aGUgam9pbi4gIEFueSBraW5kIG9mIG5vbi1lcXVhbGl0eSBiYXNlZCBv cGVyYXRpb24gaW4gYQ0Kam9pbiBvciB0aGUgcHJlZGljYXRlIHNpZGUgb2Yg YSB3aGVyZSBjb25kaXRpb24gY2FuIGdldCB2ZXJ5IGV4cGVuc2l2ZQ0KdmVy eSBxdWlja2x5LiAgIChpdCByZW1haW5zIGRpZmZpY3VsdCB0byBzZWUgaWYg dGhlcmUncyBhbnkgd2F5IHRvDQppbXByb3ZlIHRoZSBqb2luIG9wZXJhdGlv biBkdWUgdG8gbGFjayBvZiB2aXNpYmlsaXR5IG9uIHRoZSBxdWVyeQ0Kc3Ry aW5nKS4NCg0KbWVybGluDQoKLS0gClNlbnQgdmlhIHBnc3FsLXBlcmZvcm1h bmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNx bC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoK aHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJm b3JtYW5jZQo=