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 1gf2oR-0004Ml-KH for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2019 13:13:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gf2oP-0000tV-K1 for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2019 13:13:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gf2oP-0000tO-8x for pgsql-performance@lists.postgresql.org; Thu, 03 Jan 2019 13:13:25 +0000 Received: from smtp1.iter.org ([193.51.56.7]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gf2oH-0001KS-CH for pgsql-performance@lists.postgresql.org; Thu, 03 Jan 2019 13:13:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iter.org; l=7234; q=dns/txt; s=20170425; t=1546521197; x=1547125997; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=IKlUrhkieuIVyMxyX3GiGt7ZIIH77My8SU7XUryCUoo=; b=TCJVU9dfXmqdvayzsw7g6ZcisaS2+DR57j1eVAlHw/TDn6liaAVQ595F qabb/xqxFm6kRJXZPAGlfuq4q3GSeQbs7BfSGUqtWieXz+ZuUe1AKP3/z Y1M+qJfCv5QsSy0d+BgkjEHlounw5Ep/ffewAyYmSt8i2evDBPnv54js5 0=; Received: from XCH-CLU1N3.iter.org (10.10.242.164) by XCH-CLU1N3.iter.org (10.10.242.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:13:14 +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:13:14 +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 Date: Thu, 3 Jan 2019 13:13:14 +0000 Message-ID: <438dcc57f91d4a9fab12ae4078592d69@iter.org> References: <49406fb0c239480980ffc6c2a250d4e9@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 aWQucm93bGV5QDJuZHF1YWRyYW50LmNvbT4gDQpTZW50OiAwMyBKYW51YXJ5IDIwMTkgMTQ6MDEN ClRvOiBBYmFkaWUgTGFuYSA8TGFuYS5BYmFkaWVAaXRlci5vcmc+DQpDYzogcGdzcWwtcGVyZm9y bWFuY2VAbGlzdHMucG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBzZWxlY3QgcXVlcnkgZG9l cyBub3QgcGljayB1cCB0aGUgcmlnaHQgaW5kZXgNCg0KT24gRnJpLCA0IEphbiAyMDE5IGF0IDAx OjU3LCBBYmFkaWUgTGFuYSA8TGFuYS5BYmFkaWVAaXRlci5vcmc+IHdyb3RlOg0KPiA0KSBuYW1l IGlzIHVuaXF1ZSwgY29uc3RyYWludCBhbmQgaW5kZXggY3JlYXRlZC4gUmlnaHQgaW5kZXggaXMg cGlja2VkIHVwIGFuZCBxdWVyeSB0aW1lIGlzIHJhdGhlciBjb25zdGFudCB0aGVyZSA0MHNlYy4N Cg0KVGhhdCdzIHN1cnByaXNpbmdseSBzbG93LiBDYW4geW91IHNoYXJlIHRoZSBFWFBMQUlOIChB TkFMWVpFLCBCVUZGRVJTKSBvZiB0aGF0Pw0KDQoNCi0tIA0KIERhdmlkIFJvd2xleSAgICAgICAg ICAgICAgICAgICBodHRwOi8vd3d3LjJuZFF1YWRyYW50LmNvbS8NCiBQb3N0Z3JlU1FMIERldmVs b3BtZW50LCAyNHg3IFN1cHBvcnQsIFRyYWluaW5nICYgU2VydmljZXMNCg0KDQoNCg0KDQpleHBs YWluIChhbmFseXplLGJ1ZmZlcnMpIHNlbGVjdCAnQlVJTC1CMzYtVkEtUlQtUlQxOkNMMDAwMS0y LUFCVycsYy5zbXBsX3RpbWUsYy5uYW5vc2VjcyxjLmZsb2F0X3ZhbCxjLm51bV92YWwsYy5zdHJf dmFsLGMuZGF0YXR5cGUsYy5hcnJheV92YWwgZnJvbSBzYW1wbGUgYyBXSEVSRSBjLmNoYW5uZWxf aWQgPSAoU0VMRUNUIGNoYW5uZWxfaWQgRlJPTSBjaGFubmVsIFdIRVJFIG5hbWU9J0JVSUwtQjM2 LVZBLVJULVJUMTpDTDAwMDEtMi1BQlcnKSBvcmRlciBieSBjLnNtcGxfdGltZSBkZXNjIGxpbWl0 IDU7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFODQoNCi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCiBMaW1pdCAgKGNvc3Q9MTMuNDAuLjIwLjIyIHJvd3M9NSB3aWR0aD0yMzMpIChh Y3R1YWwgdGltZT00MTAyMy4wNTcuLjQxMDI3LjQxMiByb3dzPTMgbG9vcHM9MSkNCiAgIEJ1ZmZl cnM6IHNoYXJlZCBoaXQ9NzU3ODIxMzkgcmVhZD0xODM0OTY5DQogICBJbml0UGxhbiAxIChyZXR1 cm5zICQwKQ0KICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB1bmlxdWVfY2huYW1lIG9uIGNoYW5u ZWwgIChjb3N0PTAuNDEuLjguNDMgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0yLjQ0Mi4u Mi40NDMgcm93cz0xIGxvb3BzPQ0KMSkNCiAgICAgICAgICAgSW5kZXggQ29uZDogKChuYW1lKTo6 dGV4dCA9ICdCVUlMLUIzNi1WQS1SVC1SVDE6Q0wwMDAxLTItQUJXJzo6dGV4dCkNCiAgICAgICAg ICAgQnVmZmVyczogc2hhcmVkIHJlYWQ9NA0KICAgLT4gIFJlc3VsdCAgKGNvc3Q9NC45Ni4uODM0 NDQ3OC42NSByb3dzPTYxMTczMjMgd2lkdGg9MjMzKSAoYWN0dWFsIHRpbWU9NDEwMjMuMDU1Li40 MTAyNy40MDggcm93cz0zIGxvb3BzPTEpDQogICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTc1 NzgyMTM5IHJlYWQ9MTgzNDk2OQ0KICAgICAgICAgLT4gIE1lcmdlIEFwcGVuZCAgKGNvc3Q9NC45 Ni4uODI4MzMwNS40MiByb3dzPTYxMTczMjMgd2lkdGg9MjAxKSAoYWN0dWFsIHRpbWU9NDEwMjMu MDU0Li40MTAyNy40MDQgcm93cz0zIGxvb3BzPTEpDQogICAgICAgICAgICAgICBTb3J0IEtleTog Yy5zbXBsX3RpbWUgREVTQw0KICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD03NTc4 MjEzOSByZWFkPTE4MzQ5NjkNCiAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIEJhY2t3YXJk IHVzaW5nIHNtcGxfdGltZV9xYV9pZHggb24gc2FtcGxlIGMgIChjb3N0PTAuMTIuLjguMTQgcm93 cz0xIHdpZHRoPTMyNikgKGFjdHVhbCB0aW1lPTANCi4wMDguLjAuMDA5IHJvd3M9MCBsb29wcz0x KQ0KICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoY2hhbm5lbF9pZCA9ICQwKQ0KICAgICAg ICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD0xDQogICAgICAgICAgICAgICAtPiAg SW5kZXggU2NhbiBCYWNrd2FyZCB1c2luZyBzYW1wbGVfdGltZV9iX2lkeCBvbiBzYW1wbGVfYnVp bCBjXzEgIChjb3N0PTAuNDIuLjIyMzE4LjAzIHJvd3M9NjMwMCB3aWR0aD0zMjApDQogKGFjdHVh bCB0aW1lPTIuNDc4Li4yLjQ3OCByb3dzPTAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAg IEluZGV4IENvbmQ6IChjaGFubmVsX2lkID0gJDApDQogICAgICAgICAgICAgICAgICAgICBCdWZm ZXJzOiBzaGFyZWQgcmVhZD03DQogICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiBCYWNrd2Fy ZCB1c2luZyBzYW1wbGVfdGltZV9jX2lkeCBvbiBzYW1wbGVfY3RybCBjXzIgIChjb3N0PTAuNDIu LjExNjQ4Mi44MSByb3dzPTMzNjYxIHdpZHRoPTMyDQowKSAoYWN0dWFsIHRpbWU9MC4wMjIuLjAu MDIyIHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNo YW5uZWxfaWQgPSAkMCkNCiAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCByZWFk PTMNCiAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIEJhY2t3YXJkIHVzaW5nIHNhbXBsZV90 aW1lX3VfaWR4IG9uIHNhbXBsZV91dGlsIGNfMyAgKGNvc3Q9MC40My4uMzUzNjYuNzIgcm93cz05 NDgzIHdpZHRoPTMyMCkNCiAoYWN0dWFsIHRpbWU9MC4wMjIuLjAuMDIyIHJvd3M9MCBsb29wcz0x KQ0KICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNoYW5uZWxfaWQgPSAkMCkNCiAg ICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCByZWFkPTMNCiAgICAgICAgICAgICAg IC0+ICBJbmRleCBTY2FuIEJhY2t3YXJkIHVzaW5nIHNhbXBsZV90aW1lX2JtX2lkeCBvbiBzYW1w bGVfYnVpbF9tb250aCBjXzQgIChjb3N0PTAuNTYuLjYwMjkzLjg4IHJvd3M9MTU3MTEgd2kNCmR0 aD03NCkgKGFjdHVhbCB0aW1lPTUuNDk5Li45Ljg0NyByb3dzPTMgbG9vcHM9MSkNCiAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6IChjaGFubmVsX2lkID0gJDApDQogICAgICAgICAgICAg ICAgICAgICBCdWZmZXJzOiBzaGFyZWQgcmVhZD04DQogICAgICAgICAgICAgICAtPiAgSW5kZXgg U2NhbiBCYWNrd2FyZCB1c2luZyBzbXBsX3RpbWVfYngyX2lkeCBvbiBzYW1wbGVfYnVpbF95ZWFy IGNfNSAgKGNvc3Q9MC41Ni4uMjAyMzkyNS4zMCByb3dzPTMxNjIzNjQNCndpZHRoPTMyMCkgKGFj dHVhbCB0aW1lPTE1MTY3LjMzMC4uMTUxNjcuMzMwIHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAg ICAgICAgICAgICAgRmlsdGVyOiAoY2hhbm5lbF9pZCA9ICQwKQ0KICAgICAgICAgICAgICAgICAg ICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogNTA1OTc4MzQNCiAgICAgICAgICAgICAgICAgICAg IEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MjU5MTMxNDcgcmVhZD03MTMyMjENCiAgICAgICAgICAgICAg IC0+ICBJbmRleCBTY2FuIEJhY2t3YXJkIHVzaW5nIHNhbXBsZV90aW1lX2NtX2lkeCBvbiBzYW1w bGVfY3RybF9tb250aCBjXzYgIChjb3N0PTAuNTYuLjE4NjI1ODcuMTIgcm93cz01Mzc1NjINCiB3 aWR0aD03NykgKGFjdHVhbCB0aW1lPTAuMDQ4Li4wLjA0OCByb3dzPTAgbG9vcHM9MSkNCiAgICAg ICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChjaGFubmVsX2lkID0gJDApDQogICAgICAgICAg ICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgcmVhZD00DQogICAgICAgICAgICAgICAtPiAgSW5k ZXggU2NhbiBCYWNrd2FyZCB1c2luZyBzbXBsX3RpbWVfY214Ml9pZHggb24gc2FtcGxlX2N0cmxf eWVhciBjXzcgIChjb3N0PTAuNTcuLjMxODYzMDUuNjcgcm93cz0yMDk0MTg2DQogd2lkdGg9Njgp IChhY3R1YWwgdGltZT0yNTg0Ny41NDkuLjI1ODQ3LjU0OSByb3dzPTAgbG9vcHM9MSkNCiAgICAg ICAgICAgICAgICAgICAgIEZpbHRlcjogKGNoYW5uZWxfaWQgPSAkMCkNCiAgICAgICAgICAgICAg ICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDc5NTc5MDc1DQogICAgICAgICAgICAgICAg ICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTQ5ODY4OTkxIHJlYWQ9MTEyMTcxNQ0KICAgICAgICAg ICAgICAgLT4gIEluZGV4IFNjYW4gQmFja3dhcmQgdXNpbmcgc2FtcGxlX3RpbWVfdW1faWR4IG9u IHNhbXBsZV91dGlsX21vbnRoIGNfOCAgKGNvc3Q9MC41Ny4uMzYwNDU0LjUzIHJvd3M9OTcxMDEg dw0KaWR0aD03NCkgKGFjdHVhbCB0aW1lPTAuMDU4Li4wLjA1OSByb3dzPTAgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChjaGFubmVsX2lkID0gJDApDQogICAgICAg ICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgcmVhZD00DQogICAgICAgICAgICAgICAtPiAg SW5kZXggU2NhbiBCYWNrd2FyZCB1c2luZyBzYW1wbGVfdGltZV91eV9pZHggb24gc2FtcGxlX3V0 aWxfeWVhciBjXzkgIChjb3N0PTAuNTcuLjQ5ODY2My4yMiByb3dzPTE2MDk1NCB3DQppZHRoPTc1 KSAoYWN0dWFsIHRpbWU9MC4wMzAuLjAuMDMwIHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAgICAg ICAgICAgICAgSW5kZXggQ29uZDogKGNoYW5uZWxfaWQgPSAkMCkNCiAgICAgICAgICAgICAgICAg ICAgIEJ1ZmZlcnM6IHNoYXJlZCByZWFkPTQNCiBQbGFubmluZyB0aW1lOiAwLjc4MiBtcw0KIEV4 ZWN1dGlvbiB0aW1lOiA0MTAyNy41NzAgbXMNCig0NSByb3dzKQ0KDQo=