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 1gf2vM-0004iA-8Y for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2019 13:20:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gf2vK-00057S-RC for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2019 13:20:34 +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 1gf2vK-00057H-JR for pgsql-performance@lists.postgresql.org; Thu, 03 Jan 2019 13:20:34 +0000 Received: from smtp2.iter.org ([193.51.56.8]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gf2vH-0003MB-Vy for pgsql-performance@lists.postgresql.org; Thu, 03 Jan 2019 13:20:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iter.org; l=6852; q=dns/txt; s=20170425; t=1546521632; x=1547126432; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=52DUcmQg1NfyG7P1/fBnTEu4+PT/Ia3juTb6s57BXn0=; b=kiJvNysJyxzml05GMbByFD7etjDerrCg8IJxOcKncpVLRReZXYFOF7D1 412eHze3lcq8EjFGcPYntpunDs0PlOQQDL6692HlfT7qaee5GKfntG5WL TQ3WLjvBVhw/R1g2P5w/ba8iM9rRLYQ+blR71sy3q9TnuW8gqJIINxnMA A=; Received: from XCH-CLU1N3.iter.org (10.10.242.164) by XCH-CLU1N4.iter.org (10.10.243.164) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.1261.35; Thu, 3 Jan 2019 14:20:30 +0100 Received: from XCH-CLU1N3.iter.org ([fe80::f903:4e8a:c365:4c74]) by XCH-CLU1N3.iter.org ([fe80::f903:4e8a:c365:4c74%16]) with mapi id 15.01.1261.036; Thu, 3 Jan 2019 14:20:30 +0100 From: Abadie Lana To: David Rowley CC: "pgsql-performance@lists.postgresql.org" Subject: RE: select query does not pick up the right index Thread-Topic: select query does not pick up the right index Thread-Index: AdSitwt5/9TyB7hoTX++E94tUlkiMgAOgIkAABh1BzAAAkhrgAACgegQ///wggD//+6z4A== Date: Thu, 3 Jan 2019 13:20:30 +0000 Message-ID: References: <49406fb0c239480980ffc6c2a250d4e9@iter.org> <438dcc57f91d4a9fab12ae4078592d69@iter.org> In-Reply-To: Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.14.32.57] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk DQoNCg0KTGFuYSBBQkFESUUNCkRhdGFiYXNlIEVuZ2luZWVyDQpDT0RBQyBTZWN0aW9uDQoNCklU RVIgT3JnYW5pemF0aW9uLCBCdWlsZGluZyA3Mi80MTA4LCBTQ09ELCBDb250cm9sIFN5c3RlbSBE aXZpc2lvbg0KUm91dGUgZGUgVmlub24tc3VyLVZlcmRvbiAtIENTIDkwIDA0NiAtIDEzMDY3IFN0 IFBhdWwgTGV6IER1cmFuY2UgQ2VkZXggLSBGcmFuY2UNClBob25lOiArMzMgNCA0MiAxNyA4NCAw Mg0KR2V0IHRoZSBsYXRlc3QgSVRFUiBuZXdzIG9uIGh0dHA6Ly93d3cuaXRlci5vcmcvd2hhdHNu ZXcNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IERhdmlkIFJvd2xleSA8ZGF2 aWQucm93bGV5QDJuZHF1YWRyYW50LmNvbT4gDQpTZW50OiAwMyBKYW51YXJ5IDIwMTkgMTQ6MTgN ClRvOiBBYmFkaWUgTGFuYSA8TGFuYS5BYmFkaWVAaXRlci5vcmc+DQpDYzogcGdzcWwtcGVyZm9y bWFuY2VAbGlzdHMucG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBzZWxlY3QgcXVlcnkgZG9l cyBub3QgcGljayB1cCB0aGUgcmlnaHQgaW5kZXgNCg0KPiBGcm9tOiBEYXZpZCBSb3dsZXkgPGRh dmlkLnJvd2xleUAybmRxdWFkcmFudC5jb20+DQo+IFNlbnQ6IDAzIEphbnVhcnkgMjAxOSAxNDow MQ0KPiBUaGF0J3Mgc3VycHJpc2luZ2x5IHNsb3cuIENhbiB5b3Ugc2hhcmUgdGhlIEVYUExBSU4g KEFOQUxZWkUsIEJVRkZFUlMpIG9mIHRoYXQ/DQo+DQo+IGV4cGxhaW4gKGFuYWx5emUsYnVmZmVy cykgc2VsZWN0IA0KPiAnQlVJTC1CMzYtVkEtUlQtUlQxOkNMMDAwMS0yLUFCVycsYy5zbXBsX3Rp bWUsYy5uYW5vc2VjcyxjLmZsb2F0X3ZhbCxjDQo+IC5udW1fdmFsLGMuc3RyX3ZhbCxjLmRhdGF0 eXBlLGMuYXJyYXlfdmFsIGZyb20gc2FtcGxlIGMgV0hFUkUgDQo+IGMuY2hhbm5lbF9pZCA9IChT RUxFQ1QgY2hhbm5lbF9pZCBGUk9NIGNoYW5uZWwgV0hFUkUgDQo+IG5hbWU9J0JVSUwtQjM2LVZB LVJULVJUMTpDTDAwMDEtMi1BQlcnKSBvcmRlciBieSBjLnNtcGxfdGltZSBkZXNjIA0KPiBsaW1p dCA1Ow0KDQoNCj4gICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gQmFja3dhcmQgdXNpbmcg c21wbF90aW1lX2J4Ml9pZHggb24gDQo+IHNhbXBsZV9idWlsX3llYXIgY181ICAoY29zdD0wLjU2 Li4yMDIzOTI1LjMwIHJvd3M9MzE2MjM2NA0KPiB3aWR0aD0zMjApIChhY3R1YWwgdGltZT0xNTE2 Ny4zMzAuLjE1MTY3LjMzMCByb3dzPTAgbG9vcHM9MSkNCj4gICAgICAgICAgICAgICAgICAgICAg RmlsdGVyOiAoY2hhbm5lbF9pZCA9ICQwKQ0KPiAgICAgICAgICAgICAgICAgICAgICBSb3dzIFJl bW92ZWQgYnkgRmlsdGVyOiA1MDU5NzgzNA0KPiAgICAgICAgICAgICAgICAgICAgICBCdWZmZXJz OiBzaGFyZWQgaGl0PTI1OTEzMTQ3IHJlYWQ9NzEzMjIxDQo+ICAgICAgICAgICAgICAgIC0+ICBJ bmRleCBTY2FuIEJhY2t3YXJkIHVzaW5nIHNhbXBsZV90aW1lX2NtX2lkeCBvbiANCj4gc2FtcGxl X2N0cmxfbW9udGggY182ICAoY29zdD0wLjU2Li4xODYyNTg3LjEyIHJvd3M9NTM3NTYyDQo+ICB3 aWR0aD03NykgKGFjdHVhbCB0aW1lPTAuMDQ4Li4wLjA0OCByb3dzPTAgbG9vcHM9MSkNCj4gICAg ICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNoYW5uZWxfaWQgPSAkMCkNCj4gICAgICAg ICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIHJlYWQ9NA0KPiAgICAgICAgICAgICAgICAt PiAgSW5kZXggU2NhbiBCYWNrd2FyZCB1c2luZyBzbXBsX3RpbWVfY214Ml9pZHggb24gDQo+IHNh bXBsZV9jdHJsX3llYXIgY183ICAoY29zdD0wLjU3Li4zMTg2MzA1LjY3IHJvd3M9MjA5NDE4Ng0K PiAgd2lkdGg9NjgpIChhY3R1YWwgdGltZT0yNTg0Ny41NDkuLjI1ODQ3LjU0OSByb3dzPTAgbG9v cHM9MSkNCj4gICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoY2hhbm5lbF9pZCA9ICQwKQ0K PiAgICAgICAgICAgICAgICAgICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA3OTU3OTA3NQ0K PiAgICAgICAgICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTQ5ODY4OTkxIHJlYWQ9 MTEyMTcxNQ0KDQpSaWdodCwgc28geW91IG5lZWQgdG8gY2hlY2sgeW91ciBpbmRleGVzIG9uIHNh bXBsZV9jdHJsX3llYXIgYW5kIHNhbXBsZV9idWlsX3llYXIuIFlvdSBuZWVkIGFuIGluZGV4IG9u IChjaGFubmVsX2lkLCBzbXBsX3RpbWUpIG9uIHRob3NlLg0KDQoNClRoZXNlIGluZGV4ZXMgZXhp c3QgYWxyZWFkeQ0KXGQgc2FtcGxlX2N0cmxfeWVhcg0KICAgICAgICAgICAgICAgICAgICAgICAg VGFibGUgInB1YmxpYy5zYW1wbGVfY3RybF95ZWFyIg0KICAgQ29sdW1uICAgIHwgICAgICAgICAg ICBUeXBlICAgICAgICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCAgIERlZmF1bHQNCi0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0t LS0tLS0tLSstLS0tLS0tLS0tLS0tDQogY2hhbm5lbF9pZCAgfCBiaWdpbnQgICAgICAgICAgICAg ICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQogc21wbF90aW1lICAgfCB0aW1lc3Rh bXAgd2l0aG91dCB0aW1lIHpvbmUgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQogbmFub3NlY3Mg ICAgfCBiaWdpbnQgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8 DQogc2V2ZXJpdHlfaWQgfCBiaWdpbnQgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAg fCBub3QgbnVsbCB8DQogc3RhdHVzX2lkICAgfCBiaWdpbnQgICAgICAgICAgICAgICAgICAgICAg fCAgICAgICAgICAgfCBub3QgbnVsbCB8DQogbnVtX3ZhbCAgICAgfCBpbnRlZ2VyICAgICAgICAg ICAgICAgICAgICAgfCAgICAgICAgICAgfCAgICAgICAgICB8DQogZmxvYXRfdmFsICAgfCBkb3Vi bGUgcHJlY2lzaW9uICAgICAgICAgICAgfCAgICAgICAgICAgfCAgICAgICAgICB8DQogc3RyX3Zh bCAgICAgfCBjaGFyYWN0ZXIgdmFyeWluZygxMjApICAgICAgfCAgICAgICAgICAgfCAgICAgICAg ICB8DQogZGF0YXR5cGUgICAgfCBjaGFyYWN0ZXIoMSkgICAgICAgICAgICAgICAgfCAgICAgICAg ICAgfCAgICAgICAgICB8ICcgJzo6YnBjaGFyDQogYXJyYXlfdmFsICAgfCBieXRlYSAgICAgICAg ICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCAgICAgICAgICB8DQpJbmRleGVzOg0KICAgICJz YW1wbGVfdGltZV9jeV9pZHgiIGJ0cmVlIChjaGFubmVsX2lkLCBzbXBsX3RpbWUpDQogICAgInNh bXBsZV90aW1lX3ljMV9pZHgiIGJ0cmVlIChzbXBsX3RpbWUsIGNoYW5uZWxfaWQpDQogICAgInNt cGxfdGltZV9jbXgyX2lkeCIgYnRyZWUgKHNtcGxfdGltZSkNCkNoZWNrIGNvbnN0cmFpbnRzOg0K ICAgICJzYW1wbGVfY3RybF95ZWFyX3NtcGxfdGltZV9jaGVjayIgQ0hFQ0sgKHNtcGxfdGltZSA+ PSAobm93KCkgLSAnMSB5ZWFyIDEgbW9uJzo6aW50ZXJ2YWwpOjp0aW1lc3RhbXAgd2l0aG91dCB0 aW1lIHpvbmUgQU5EIHNtcGxfdGltZSA8PSBub3coKSkNCkluaGVyaXRzOiBzYW1wbGVfY3RybA0K DQpjc3NfYXJjaGl2ZV8zXzBfMD0jIFxkIHNhbXBsZV9idWlsX3llYXINCiAgICAgICAgICAgICAg ICAgICAgICAgIFRhYmxlICJwdWJsaWMuc2FtcGxlX2J1aWxfeWVhciINCiAgIENvbHVtbiAgICB8 ICAgICAgICAgICAgVHlwZSAgICAgICAgICAgICB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgICBE ZWZhdWx0DQotLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGNoYW5uZWxfaWQgIHwgYmlnaW50ICAg ICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfA0KIHNtcGxfdGltZSAg IHwgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25lIHwgICAgICAgICAgIHwgbm90IG51bGwgfA0K IG5hbm9zZWNzICAgIHwgYmlnaW50ICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwg bm90IG51bGwgfA0KIHNldmVyaXR5X2lkIHwgYmlnaW50ICAgICAgICAgICAgICAgICAgICAgIHwg ICAgICAgICAgIHwgbm90IG51bGwgfA0KIHN0YXR1c19pZCAgIHwgYmlnaW50ICAgICAgICAgICAg ICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfA0KIG51bV92YWwgICAgIHwgaW50ZWdl ciAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfA0KIGZsb2F0X3Zh bCAgIHwgZG91YmxlIHByZWNpc2lvbiAgICAgICAgICAgIHwgICAgICAgICAgIHwgICAgICAgICAg fA0KIHN0cl92YWwgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoMTIwKSAgICAgIHwgICAgICAgICAg IHwgICAgICAgICAgfA0KIGRhdGF0eXBlICAgIHwgY2hhcmFjdGVyKDEpICAgICAgICAgICAgICAg IHwgICAgICAgICAgIHwgICAgICAgICAgfCAnICc6OmJwY2hhcg0KIGFycmF5X3ZhbCAgIHwgYnl0 ZWEgICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfA0KSW5kZXhl czoNCiAgICAic2FtcGxlX3RpbWVfYnlfaWR4IiBidHJlZSAoY2hhbm5lbF9pZCwgc21wbF90aW1l KQ0KICAgICJzYW1wbGVfdGltZV95YjFfaWR4IiBidHJlZSAoc21wbF90aW1lLCBjaGFubmVsX2lk KQ0KICAgICJzbXBsX3RpbWVfYngyX2lkeCIgYnRyZWUgKHNtcGxfdGltZSkNCkNoZWNrIGNvbnN0 cmFpbnRzOg0KICAgICJzYW1wbGVfYnVpbF95ZWFyX3NtcGxfdGltZV9jaGVjayIgQ0hFQ0sgKHNt cGxfdGltZSA+PSAobm93KCkgLSAnMSB5ZWFyIDEgbW9uJzo6aW50ZXJ2YWwpOjp0aW1lc3RhbXAg d2l0aG91dCB0aW1lIHpvbmUgQU5EIHNtcGxfdGltZSA8PSBub3coKSkNCkluaGVyaXRzOiBzYW1w bGVfYnVpbA0KDQpjc3NfYXJjaGl2ZV8zXzBfMD0jDQoNCi0tIA0KIERhdmlkIFJvd2xleSAgICAg ICAgICAgICAgICAgICBodHRwOi8vd3d3LjJuZFF1YWRyYW50LmNvbS8NCiBQb3N0Z3JlU1FMIERl dmVsb3BtZW50LCAyNHg3IFN1cHBvcnQsIFRyYWluaW5nICYgU2VydmljZXMNCg==