Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWs6r-0001NI-PS for pgsql-bugs@arkaria.postgresql.org; Fri, 08 May 2020 01:47:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jWs6q-0004M5-IZ for pgsql-bugs@arkaria.postgresql.org; Fri, 08 May 2020 01:47:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWqzo-00012x-PP for pgsql-bugs@lists.postgresql.org; Fri, 08 May 2020 00:36:08 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jWqzj-0007cY-Cc for pgsql-bugs@lists.postgresql.org; Fri, 08 May 2020 00:36:08 +0000 Content-Type: multipart/mixed; boundary="===============2900290104942780335==" MIME-Version: 1.0 Subject: BUG #16423: Sequential Scan on query after reindex was done To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jkoceniak@mediamath.com Reply-To: jkoceniak@mediamath.com, pgsql-bugs@lists.postgresql.org Date: Fri, 08 May 2020 00:35:03 +0000 Message-ID: <16423-a55d8d0fe3a8e283@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2900290104942780335== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQyMwpMb2dnZWQgYnk6ICAgICAgICAgIEphbWllIEtvY2VuaWFrCkVt YWlsIGFkZHJlc3M6ICAgICAgamtvY2VuaWFrQG1lZGlhbWF0aC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIEdOVS9MaW51eCAxMCAoYnVzdGVy KQpEZXNjcmlwdGlvbjogICAgICAgIAoKVGhlIHF1ZXJ5IGJlbG93IGhhZCBiZWVuIHVzaW5nIHRo ZSBwcmltYXJ5IGtleSBpbmRleCBidXQgbm93IHRoZSBvcHRpbWl6ZXIKaGFzIGRlY2lkZSB0byBw ZXJmb3JtIGEgc2VxdWVudGlhbCBzY2FuLg0KVGhpcyBoYXBwZW5lZCBhZnRlciBhIHJlaW5kZXgg d2FzIGRvbmUuDQoNCkkndmUgbWFkZSBtdWx0aXBsZSBhdHRlbXB0cyB0byBydW4gYW5hbHl6ZS4g DQpJIGhhdmUgYWxzbyB0cmllZCBpbmNyZWFzaW5nIGRlZmF1bHRfc3RhdGlzdGljc190YXJnZXQg Zm9sbG93ZWQgYnkgYW5hbHl6ZQp3aXRoIG5vIHN1Y2Nlc3MuDQpJIGRvbid0IGhhdmUgdGhlIG9w dGlvbiB0byB1c2UgRU5BQkxFX1NFUVNDQU4uDQoNCklzIHRoZXJlIGEgd2F5IHRvIG1ha2UgdGhl IHF1ZXJ5IHVzZSB0aGUgaW5kZXggYWdhaW4/IHRoZSAxMjBtcyBtYWtlcyBhCmRpZmZlcmVuY2Ug c2luY2UgdGhpcyBxdWVyeSBpcyBjYWxsZWQgbWlsbGlvbnMgb2YgdGltZSBwZXIgZGF5LiBIZXJl IGlzIGFsbAp0aGUgaW5mb3JtYXRpb24gSSBjb3VsZCBnYXRoZXI6DQoNCmV4cGxhaW4gYW5hbHl6 ZSBTRUxFQ1QgKiBGUk9NIHVzZXJfZ2FtZXMgdDEgSk9JTiBnYW1lcyB0MiBPTiAodDEuZ2FtZV9p ZCA9CnQyLmlkKSBXSEVSRSB0MS51c2VyX2lkID0gJzE1MjAyJzsNCg0KTmV3IFF1ZXJ5IFBsYW46 DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgClFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgIA0KLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBIYXNoIEpv aW4gIChjb3N0PTU3MDkuOTYuLjE0Mzk3LjQwIHJvd3M9MTI0MDMgd2lkdGg9MTU2KSAoYWN0dWFs CnRpbWU9MTQxLjY4NS4uMTQ5LjEwOSByb3dzPTExMDQzIGxvb3BzPTEpDQogICBIYXNoIENvbmQ6 ICh0MS5nYW1lX2lkID0gdDIuaWQpDQogICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX2dhbWVz X3VzZXJfaWRfaWR4IG9uIHVzZXJfZ2FtZXMgdDEgCihjb3N0PTAuNDMuLjg2NTUuMzEgcm93cz0x MjQwMyB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMTAyLi4yLjg4Mwpyb3dzPTExMDQzIGxvb3Bz PTEpDQogICAgICAgICBJbmRleCBDb25kOiAodXNlcl9pZCA9IDI5NjYpDQogICAtPiAgSGFzaCAg KGNvc3Q9Mzk5My42OC4uMzk5My42OCByb3dzPTEzNzI2OCB3aWR0aD0xNDApIChhY3R1YWwKdGlt ZT0xNDAuMzE5Li4xNDAuMzE5IHJvd3M9MTM3MjcwIGxvb3BzPTEpDQogICAgICAgICBCdWNrZXRz OiAyNjIxNDQgIEJhdGNoZXM6IDEgIE1lbW9yeSBVc2FnZTogMjI3NjVrQg0KICAgICAgICAgLT4g IFNlcSBTY2FuIG9uIGdhbWVzIHQyICAoY29zdD0wLjAwLi4zOTkzLjY4IHJvd3M9MTM3MjY4Cndp ZHRoPTE0MCkgKGFjdHVhbCB0aW1lPTAuMDMwLi43My41ODEgcm93cz0xMzcyNzAgbG9vcHM9MSkN CiBQbGFubmluZyBUaW1lOiAyLjM4MyBtcw0KIEV4ZWN1dGlvbiBUaW1lOiAxNDkuOTAzIG1zDQoN Cg0KUXVlcnkgUGxhbiBiZWZvcmUgdXNpbmcgdGhlIGluZGV4LiBXZSB3YW50IHRoaXMgcXVlcnkg cGxhbiBiYWNrLg0KDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZClBMQU4gICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKDQot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEdhdGhlciAgKGNvc3Q9 MTE2Ni45Ny4uMTYwMjIuOTIgcm93cz0xMjQwMyB3aWR0aD0xNTYpIChhY3R1YWwKdGltZT0xLjQw My4uMjcuODQ3IHJvd3M9MTEwNDMgbG9vcHM9MSkNCiAgIFdvcmtlcnMgUGxhbm5lZDogMg0KICAg V29ya2VycyBMYXVuY2hlZDogMg0KICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0xNjYuOTcuLjEz NzgyLjYyIHJvd3M9NTE2OCB3aWR0aD0xNTYpIChhY3R1YWwKdGltZT0wLjQzNy4uMTUuNjU5IHJv d3M9MzY4MSBsb29wcz0zKQ0KICAgICAgICAgLT4gIFBhcmFsbGVsIEJpdG1hcCBIZWFwIFNjYW4g b24gdXNlcl9nYW1lcyB0MSAKKGNvc3Q9MTY2LjU1Li45MDIwLjc1IHJvd3M9NTE2OCB3aWR0aD0x NikgKGFjdHVhbCB0aW1lPTAuMzA0Li4xLjE3Mwpyb3dzPTM2ODEgbG9vcHM9MykNCiAgICAgICAg ICAgICAgIFJlY2hlY2sgQ29uZDogKHVzZXJfaWQgPSAyOTY2KQ0KICAgICAgICAgICAgICAgSGVh cCBCbG9ja3M6IGV4YWN0PTI3DQogICAgICAgICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4g b24gdXNlcl9nYW1lc191c2VyX2lkX2lkeCAKKGNvc3Q9MC4wMC4uMTYzLjQ1IHJvd3M9MTI0MDMg d2lkdGg9MCkgKGFjdHVhbCB0aW1lPTAuNzQ1Li4wLjc0NSByb3dzPTExMDQzCmxvb3BzPTEpDQog ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodXNlcl9pZCA9IDI5NjYpDQogICAgICAg ICAtPiAgSW5kZXggU2NhbiB1c2luZyBnYW1lc19wa2V5IG9uIGdhbWVzIHQyICAoY29zdD0wLjQy Li4wLjkyCnJvd3M9MSB3aWR0aD0xNDApIChhY3R1YWwgdGltZT0wLjAwMy4uMC4wMDMgcm93cz0x IGxvb3BzPTExMDQzKQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGlkID0gdDEuZ2FtZV9p ZCkNCiBQbGFubmluZyBUaW1lOiAwLjI5NyBtcw0KIEV4ZWN1dGlvbiBUaW1lOiAyOC4zNjUgbXMN Cg0KdXNlcl9nYW1lcyB0YWJsZToNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVGFi bGUgInB1YmxpYy51c2VyX2dhbWVzIg0KICAgIENvbHVtbiAgICAgfCAgVHlwZSAgIHwgQ29sbGF0 aW9uIHwgTnVsbGFibGUgfCAgICAgICAgICAgICAgICAgICBEZWZhdWx0IAogICAgICAgICAgICAg ICAgICANCi0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogdXNlcl9pZCAg ICAgICB8IGludGVnZXIgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IA0KIGdhbWVfaWQgfCBpbnRl Z2VyIHwgICAgICAgICAgIHwgbm90IG51bGwgfCANCiBpZCAgICAgICAgICAgIHwgaW50ZWdlciB8 ICAgICAgICAgICB8IG5vdCBudWxsIHwKbmV4dHZhbCgndXNlcl9nYW1lc19pZF9zZXEnOjpyZWdj bGFzcykNCiB2ZXJzaW9uICAgICAgIHwgaW50ZWdlciB8ICAgICAgICAgICB8IG5vdCBudWxsIHwg MA0KSW5kZXhlczoNCiAgICAidXNlcl9nYW1lc19wa2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlk KQ0KICAgICJ1c2VyX2dhbWVzX2dhbWVfaWRfaWR4IiBidHJlZSAoZ2FtZV9pZCkNCg0KR2FtZXMg dGFibGU6DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIFRhYmxlICJwdWJsaWMuZ2FtZXMiDQogICAgICAgICAgIENvbHVtbiAgICAgICAgICAgIHwg ICAgICAgICAgICAgICBUeXBlICAgICAgICAgICAgICAgIHwgQ29sbGF0aW9uCnwgTnVsbGFibGUg fCAgICAgICAgICAgICAgICAgIERlZmF1bHQgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIGlkICAgICAgICAgICAgICAgICAgICAgICAgICB8IGludGVnZXIgICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAgICAgICAgIAp8IG5vdCBudWxsIHwgbmV4dHZhbCgnZ2FtZXNf aWRfc2VxJzo6cmVnY2xhc3MpDQogdmVyc2lvbiAgICAgICAgICAgICAgICAgICAgIHwgaW50ZWdl ciAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgCnwgbm90IG51bGwgfCAwDQog bWZjX2lkICAgICAgICAgICAgICAgICAgIHwgaW50ZWdlciAgICAgICAgICAgICAgICAgICAgICAg ICAgIHwgICAgICAgICAgIHwKbm90IG51bGwgfCANCiBuYW1lICAgICAgICAgICAgICAgICAgICAg ICAgfCBjaGFyYWN0ZXIgdmFyeWluZyg2NCkgICAgICAgICAgICAgfCAgICAgICAgICAKfCBub3Qg bnVsbCB8IA0KSW5kZXhlczoNCiAgICAiZ2FtZXNfcGtleSIgUFJJTUFSWSBLRVksIGJ0cmVlIChp ZCkNCiAgICAiZ2FtZXNfbWZjX2lkX2lkeCIgYnRyZWUgKG1mY19pZCkNCg0Kc2VsZWN0ICogZnJv bSBwZ19zdGF0cyB3aGVyZSB0YWJsZW5hbWUgPSAnZ2FtZXMnIGFuZCBhdHRuYW1lID0gJ2lkJzsN Ci1bIFJFQ09SRCAxCl0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0Kc2NoZW1hbmFt ZSAgICAgICAgICAgICB8IHB1YmxpYw0KdGFibGVuYW1lICAgICAgICAgICAgICB8IGdhbWVzDQph dHRuYW1lICAgICAgICAgICAgICAgIHwgaWQNCmluaGVyaXRlZCAgICAgICAgICAgICAgfCBmDQpu dWxsX2ZyYWMgICAgICAgICAgICAgIHwgMA0KYXZnX3dpZHRoICAgICAgICAgICAgICB8IDQNCm5f ZGlzdGluY3QgICAgICAgICAgICAgfCAtMQ0KbW9zdF9jb21tb25fdmFscyAgICAgICB8IA0KbW9z dF9jb21tb25fZnJlcXMgICAgICB8IA0KaGlzdG9ncmFtX2JvdW5kcyAgICAgICB8CnsxNiwxMDEy OTAsMTAyNjczLDEwNDAwNywxMDUzNDcsMTA2NjI1LDEwNzk3MSwxMDkzODUsMTEwNjM3LDExMjAx MCwxMTM0MDksMTE0ODU4LDExNjIxOSwxMTc1NjIsMTE5MDI0LDEyMDI0MCwxMjE3MjUsMTIzMTM2 LDEyNDQxNCwxMjU3MDIsMTI3MDY4LDEyODM1MSwxMjk2OTgsMTMxMDg3LDEzMjQyMywxMzM4MTQs MTM1MTkxLDEzNjU3NywxMzc5OTAsMTM5NDcwLDE0MDgwMSwxNDIyMTIsMTQzNjUwLDE0NTAyNywx NDY0NDgsMTQ3OTIyLDE0OTQxNywxNTA4ODcsMTUyMTQ2LDE1MzU1MiwxNTQ5OTQsMTU2MzMwLDE1 Nzc2OSwxNTkxODMsMTYwNDg3LDE2MTg1OSwxNjMyMjcsMTY0NTMyLDE2NjAwNiwxNjczMDAsMTY4 NjgwLDE3MDA2MywxNzEzMDUsMTcyNzUyLDE3NDEyMSwxNzU1NDIsMTc2OTMxLDE3ODI0NCwxNzk2 NTcsMTgwOTc4LDE4MjI5NywxODM2MTEsMTg0OTczLDE4NjI5NCwxODc0OTksMTg4ODQ1LDE5MDIw NSwxOTE1MjgsMTkyODkwLDE5NDE1MSwxOTU1MDAsMTk2OTA4LDE5ODMxNCwxOTk3ODksMjAxMTQw LDIwMjUyNCwyMDM5NTMsMjA1MzAxLDIwNjYzNywyMDc5ODcsMjA5NDc0LDIxMDg4MCwyMTIzMjUs MjEzNjg0LDIxNTEzNCwyMTY2MTEsMjE4MTUyLDIxOTQ0NywyMjA4OTcsMjIyMjQyLDIyMzYyNywy MjUwMDgsMjI2NDQ4LDIyNzg3MCwyMjkyNDIsMjMwNTkyLDIzMjAwMSwyMzM0OTYsMjM0ODA4LDIz NjIyOCwyMzc2NDR9DQpjb3JyZWxhdGlvbiAgICAgICAgICAgIHwgMC4zMDg4NjgzMg0KbW9zdF9j b21tb25fZWxlbXMgICAgICB8IA0KbW9zdF9jb21tb25fZWxlbV9mcmVxcyB8IA0KZWxlbV9jb3Vu dF9oaXN0b2dyYW0gICB8IA0KDQotLSBub3RlIHRvdGFsc2Vxc2NhbiBpcyBpbmNyZWFzaW5nIGZh c3QNClNFTEVDVA0KICByZWxuYW1lICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBBUyBUYWJsZU5hbWUsDQogIHRvX2NoYXIoc2VxX3NjYW4sICc5OTksOTk5LDk5 OSw5OTknKSAgICAgICAgICAgICAgICAgIEFTIFRvdGFsU2VxU2NhbiwNCiAgdG9fY2hhcihpZHhf c2NhbiwgJzk5OSw5OTksOTk5LDk5OScpICAgICAgICAgICAgICAgICAgQVMgVG90YWxJbmRleFNj YW4sDQogIHRvX2NoYXIobl9saXZlX3R1cCwgJzk5OSw5OTksOTk5LDk5OScpICAgICAgICAgICAg ICAgIEFTIFRhYmxlUm93cywNCiAgcGdfc2l6ZV9wcmV0dHkocGdfcmVsYXRpb25fc2l6ZShyZWxu YW1lIDo6IHJlZ2NsYXNzKSkgQVMgVGFibGVTaXplDQpGUk9NIHBnX3N0YXRfYWxsX3RhYmxlcw0K V0hFUkUgc2NoZW1hbmFtZSA9ICdwdWJsaWMnDQogICAgICAgICBhbmQgcmVsbmFtZSA9ICdnYW1l cycNCk9SREVSIEJZIHJlbG5hbWUgQVNDOw0KICB0YWJsZW5hbWUgIHwgICB0b3RhbHNlcXNjYW4g ICB8ICB0b3RhbGluZGV4c2NhbiAgfCAgICB0YWJsZXJvd3MgICAgIHwKdGFibGVzaXplIA0KLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLQ0KIGdhbWVzIHwgICAgICAgICAgMjYzLDA0NCB8ICAgMTYs MzQ5LDQ3MCw4MDYgfCAgICAgICAgICAxMzcsMjcwIHwgMjAgTUIKCg== --===============2900290104942780335==--