Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9QyF-0003rh-6l for pgsql-sql@arkaria.postgresql.org; Mon, 08 Oct 2018 08:32:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9QyD-0005YB-AD for pgsql-sql@arkaria.postgresql.org; Mon, 08 Oct 2018 08:32:53 +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.89) (envelope-from ) id 1g9QyD-0005Y0-03; Mon, 08 Oct 2018 08:32:53 +0000 Received: from mtagatea.edf.fr ([163.114.23.130]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9Qy1-0000Mz-5f; Mon, 08 Oct 2018 08:32:51 +0000 From: ROS Didier To: "Virendra.Kumar@guycarp.com" , "folarte@peoplecall.com" CC: "pavel.stehule@gmail.com" , "pgsql-sql@lists.postgresql.org" , "pgsql-performance@lists.postgresql.org" , "pgsql-general@lists.postgresql.org" Subject: RE: Why the index is not used ? Thread-Topic: Why the index is not used ? Thread-Index: AdRdWvsLq5pbGc6hRyec/3F+ZHcFNP//4vmA//5l9yCAA4zAgP//vN6QgABwqID//v5bQA== Date: Mon, 8 Oct 2018 08:32:36 +0000 Message-ID: References: <74090066a33740ea8fc442cc70f8afa2@PCYINTPEXMU001.NEOPROD.EDF.FR> <3a14f7f8fbda4e868b663b31e8c5fa16@PCYINTPEXMU001.NEOPROD.EDF.FR> <064a89d526c44d45ae43a37556c6b5f1@USFKL11XG20CN01.mercer.com> In-Reply-To: <064a89d526c44d45ae43a37556c6b5f1@USFKL11XG20CN01.mercer.com> Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.22.153.70] x_exchange_neo: 1 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGkgVmlyZW5kcmEgDQoNCglZb3UgdGhpbmsgdGhhdCBvdXRzaWRlIGVuY3J5cHRpb24gb2YgdGhl IGRhdGFiYXNlIGlzIHRoZSBiZXN0IHNvbHV0aW9uCSA/DQogICAgICAgICAgICAgICBIb3cgZG8g eW91IG1hbmFnZSB0aGUgZW5jcnlwdGlvbiBrZXkgPw0KCUNhbiB5b3UgZ2l2ZSBtZSBzb21lIGV4 YW1wbGVzIG9mIHRoaXMga2luZCBvZiBzb2x1dGlvbi4NCg0KQmVzdCBSZWdhcmRzDQpEaWRpZXIg Uk9TDQoNCi0tLS0tTWVzc2FnZSBkJ29yaWdpbmUtLS0tLQ0KRGXCoDogVmlyZW5kcmEuS3VtYXJA Z3V5Y2FycC5jb20gW21haWx0bzpWaXJlbmRyYS5LdW1hckBndXljYXJwLmNvbV0gDQpFbnZvecOp wqA6IGRpbWFuY2hlIDcgb2N0b2JyZSAyMDE4IDIwOjQxDQrDgMKgOiBST1MgRGlkaWVyIDxkaWRp ZXIucm9zQGVkZi5mcj47IGZvbGFydGVAcGVvcGxlY2FsbC5jb20NCkNjwqA6IHBhdmVsLnN0ZWh1 bGVAZ21haWwuY29tOyBwZ3NxbC1zcWxAbGlzdHMucG9zdGdyZXNxbC5vcmc7IHBnc3FsLXBlcmZv cm1hbmNlQGxpc3RzLnBvc3RncmVzcWwub3JnOyBwZ3NxbC1nZW5lcmFsQGxpc3RzLnBvc3RncmVz cWwub3JnDQpPYmpldMKgOiBSRTogV2h5IHRoZSBpbmRleCBpcyBub3QgdXNlZCA/DQoNCllvdSBj YW4gY29uc2lkZXIgb3V0c2lkZSBEQiBlbmNyeXB0aW9uIHdoaWNoIGlzIGxlc3Mgb2Ygd29ycnkg Zm9yIHBlcmZvcm1hbmNlIGFuZCBkYXRhIGF0IHJlc3Qgd2lsbCBiZSBlbmNyeXB0ZWQuDQoNClJl Z2FyZHMsDQpWaXJlbmRyYQ0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IFJPUyBE aWRpZXIgW21haWx0bzpkaWRpZXIucm9zQGVkZi5mcl0NClNlbnQ6IFN1bmRheSwgT2N0b2JlciAw NywgMjAxOCAyOjMzIFBNDQpUbzogZm9sYXJ0ZUBwZW9wbGVjYWxsLmNvbQ0KQ2M6IHBhdmVsLnN0 ZWh1bGVAZ21haWwuY29tOyBwZ3NxbC1zcWxAbGlzdHMucG9zdGdyZXNxbC5vcmc7IHBnc3FsLXBl cmZvcm1hbmNlQGxpc3RzLnBvc3RncmVzcWwub3JnOyBwZ3NxbC1nZW5lcmFsQGxpc3RzLnBvc3Rn cmVzcWwub3JnDQpTdWJqZWN0OiBSRTogV2h5IHRoZSBpbmRleCBpcyBub3QgdXNlZCA/DQoNCkhp IEZyYW5jaXNjbw0KDQpUaGFuayB5b3UgZm9yIHlvdXIgcmVtYXJrLg0KWW91J3JlIHJpZ2h0LCBi dXQgaXQncyB0aGUgb25seSBwcm9jZWR1cmUgSSBmb3VuZCB0byBtYWtlIHNlYXJjaCBvbiBlbmNy eXB0ZWQgZmllbGRzIHdpdGggZ29vZCByZXNwb25zZSB0aW1lcyAodXNpbmcgaW5kZXgpICENCg0K UmVnYXJkaW5nIGFjY2VzcyB0byB0aGUgZmlsZSBzeXN0ZW0sIG91ciBzZXJ2ZXJzIGFyZSBpbiBw cm90ZWN0ZWQgbmV0d29yayBhcmVhcy4gZmV3IHBlb3BsZSBjYW4gY29ubmVjdCB0byBpdC4NCg0K aXQncyBub3QgdGhlIGJlc3Qgc29sdXRpb24sIGJ1dCB3ZSBoYXZlIGRhdGEgZW5jcnlwdGlvbiBu ZWVkcyBhbmQgZ29vZCBwZXJmb3JtYW5jZSBuZWVkcyB0b28uIEkgZG8gbm90IGtub3cgaG93IHRv IGRvIGl0IGV4Y2VwdCB0aGUgc3BlY2lmaWVkIHByb2NlZHVyZS4uDQppZiBhbnlvbmUgaGFzIGFu eSBwcm9wb3NhbHMgdG8gcHV0IHRoaXMgaW4gcGxhY2UsIEknbSBpbnRlcmVzdGVkLg0KDQpUaGFu a3MgaW4gYWR2YW5jZQ0KDQpCZXN0IFJlZ2FyZHMNCkRpZGllciBST1MNCg0KLS0tLS1NZXNzYWdl IGQnb3JpZ2luZS0tLS0tDQpEZSA6IGZvbGFydGVAcGVvcGxlY2FsbC5jb20gW21haWx0bzpmb2xh cnRlQHBlb3BsZWNhbGwuY29tXSBFbnZvecOpIDogZGltYW5jaGUgNyBvY3RvYnJlIDIwMTggMTc6 NTggw4AgOiBST1MgRGlkaWVyIDxkaWRpZXIucm9zQGVkZi5mcj4gQ2MgOiBwYXZlbC5zdGVodWxl QGdtYWlsLmNvbTsgcGdzcWwtc3FsQGxpc3RzLnBvc3RncmVzcWwub3JnOyBwZ3NxbC1wZXJmb3Jt YW5jZUBsaXN0cy5wb3N0Z3Jlc3FsLm9yZzsgcGdzcWwtZ2VuZXJhbEBsaXN0cy5wb3N0Z3Jlc3Fs Lm9yZw0KT2JqZXQgOiBSZTogV2h5IHRoZSBpbmRleCBpcyBub3QgdXNlZCA/DQoNClJPUzoNCg0K T24gU3VuLCBPY3QgNywgMjAxOCBhdCAzOjEzIFBNLCBST1MgRGlkaWVyIDxkaWRpZXIucm9zQGVk Zi5mcj4gd3JvdGU6DQouLi4uDQo+IC0gICAgICAgIElOU0VSVCBJTlRPIGNhcnRlZGVjcmVkaXQo dXNlcm5hbWUsY2MpICBTRUxFQ1QgJ2luZGl2aWR1ICcgfHwgeC5pZCwgcGdwX3N5bV9lbmNyeXB0 KCd0ZXN0IHZhbHVlICcgfHwgeC5pZCwgJ21vdGRlcGFzc2UnLCdjb21wcmVzcy1hbGdvPTIsIGNp cGhlci1hbGdvPWFlczI1NicpIEZST00gZ2VuZXJhdGVfc2VyaWVzKDEsMTAwMDAwKSBBUyB4KGlk KTsNCj4gLSAgICAgICAgQ1JFQVRFIElOREVYIGlkeF9jYXJ0ZWRlY3JlZGl0X2NjMDIgT04gY2Fy dGVkZWNyZWRpdChwZ3Bfc3ltX2RlY3J5cHQoY2MsICdtb3RkZXBhc3NlJywnY29tcHJlc3MtYWxn bz0yLCBjaXBoZXItYWxnbz1hZXMyNTYnKSk7DQoNCklmIG15IGZyZW5jaCBpcyBub3QgdG9vIHJ1 c3R5IHlvdSBhcmUgZW5jcnlwdGluZyBhIGNyZWRpdC1jYXJkLCBhbmQgdGhlbiBzdG9yaW5nIGFu IFVORU5DUllQVEVEIGNvcHkgaW4gdGhlIGluZGV4LiBTbywgZ2V0dGluZyBpdCBmcm9tIHRoZSBz ZXJ2ZXIgaXMgdHJpdmlhbCBmb3IgYW55b25lIHdpdGggZmlsZXN5c3RlbSBhY2Nlc3MuDQoNCkZy YW5jaXNjbyBPbGFydGUuDQoNCg0KDQpDZSBtZXNzYWdlIGV0IHRvdXRlcyBsZXMgcGnDqGNlcyBq b2ludGVzIChjaS1hcHLDqHMgbGUgJ01lc3NhZ2UnKSBzb250IMOpdGFibGlzIMOgIGwnaW50ZW50 aW9uIGV4Y2x1c2l2ZSBkZXMgZGVzdGluYXRhaXJlcyBldCBsZXMgaW5mb3JtYXRpb25zIHF1aSB5 IGZpZ3VyZW50IHNvbnQgc3RyaWN0ZW1lbnQgY29uZmlkZW50aWVsbGVzLiBUb3V0ZSB1dGlsaXNh dGlvbiBkZSBjZSBNZXNzYWdlIG5vbiBjb25mb3JtZSDDoCBzYSBkZXN0aW5hdGlvbiwgdG91dGUg ZGlmZnVzaW9uIG91IHRvdXRlIHB1YmxpY2F0aW9uIHRvdGFsZSBvdSBwYXJ0aWVsbGUsIGVzdCBp bnRlcmRpdGUgc2F1ZiBhdXRvcmlzYXRpb24gZXhwcmVzc2UuDQoNClNpIHZvdXMgbifDqnRlcyBw YXMgbGUgZGVzdGluYXRhaXJlIGRlIGNlIE1lc3NhZ2UsIGlsIHZvdXMgZXN0IGludGVyZGl0IGRl IGxlIGNvcGllciwgZGUgbGUgZmFpcmUgc3VpdnJlLCBkZSBsZSBkaXZ1bGd1ZXIgb3UgZCdlbiB1 dGlsaXNlciB0b3V0IG91IHBhcnRpZS4gU2kgdm91cyBhdmV6IHJlw6d1IGNlIE1lc3NhZ2UgcGFy IGVycmV1ciwgbWVyY2kgZGUgbGUgc3VwcHJpbWVyIGRlIHZvdHJlIHN5c3TDqG1lLCBhaW5zaSBx dWUgdG91dGVzIHNlcyBjb3BpZXMsIGV0IGRlIG4nZW4gZ2FyZGVyIGF1Y3VuZSB0cmFjZSBzdXIg cXVlbHF1ZSBzdXBwb3J0IHF1ZSBjZSBzb2l0LiBOb3VzIHZvdXMgcmVtZXJjaW9ucyDDqWdhbGVt ZW50IGQnZW4gYXZlcnRpciBpbW3DqWRpYXRlbWVudCBsJ2V4cMOpZGl0ZXVyIHBhciByZXRvdXIg ZHUgbWVzc2FnZS4NCg0KSWwgZXN0IGltcG9zc2libGUgZGUgZ2FyYW50aXIgcXVlIGxlcyBjb21t dW5pY2F0aW9ucyBwYXIgbWVzc2FnZXJpZSDDqWxlY3Ryb25pcXVlIGFycml2ZW50IGVuIHRlbXBz IHV0aWxlLCBzb250IHPDqWN1cmlzw6llcyBvdSBkw6ludcOpZXMgZGUgdG91dGUgZXJyZXVyIG91 IHZpcnVzLg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fXw0KDQpUaGlzIG1lc3NhZ2UgYW5kIGFueSBhdHRhY2htZW50cyAodGhlICdNZXNzYWdlJykg YXJlIGludGVuZGVkIHNvbGVseSBmb3IgdGhlIGFkZHJlc3NlZXMuIFRoZSBpbmZvcm1hdGlvbiBj b250YWluZWQgaW4gdGhpcyBNZXNzYWdlIGlzIGNvbmZpZGVudGlhbC4gQW55IHVzZSBvZiBpbmZv cm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBNZXNzYWdlIG5vdCBpbiBhY2NvcmQgd2l0aCBpdHMg cHVycG9zZSwgYW55IGRpc3NlbWluYXRpb24gb3IgZGlzY2xvc3VyZSwgZWl0aGVyIHdob2xlIG9y IHBhcnRpYWwsIGlzIHByb2hpYml0ZWQgZXhjZXB0IGZvcm1hbCBhcHByb3ZhbC4NCg0KSWYgeW91 IGFyZSBub3QgdGhlIGFkZHJlc3NlZSwgeW91IG1heSBub3QgY29weSwgZm9yd2FyZCwgZGlzY2xv c2Ugb3IgdXNlIGFueSBwYXJ0IG9mIGl0LiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIG1lc3Nh Z2UgaW4gZXJyb3IsIHBsZWFzZSBkZWxldGUgaXQgYW5kIGFsbCBjb3BpZXMgZnJvbSB5b3VyIHN5 c3RlbSBhbmQgbm90aWZ5IHRoZSBzZW5kZXIgaW1tZWRpYXRlbHkgYnkgcmV0dXJuIG1lc3NhZ2Uu DQoNCkUtbWFpbCBjb21tdW5pY2F0aW9uIGNhbm5vdCBiZSBndWFyYW50ZWVkIHRvIGJlIHRpbWVs eSBzZWN1cmUsIGVycm9yIG9yIHZpcnVzLWZyZWUuDQoNCl9fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fDQoNClRoaXMgbWVzc2FnZSBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgdXNlIG9m IHRoZSBhZGRyZXNzZWUgYW5kIG1heSBjb250YWluIGluZm9ybWF0aW9uIHRoYXQgaXMgUFJJVklM RUdFRCBBTkQgQ09ORklERU5USUFMLg0KDQpJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVj aXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IGFueSBkaXNzZW1pbmF0aW9uIG9m IHRoaXMgY29tbXVuaWNhdGlvbiBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgaGF2ZSBy ZWNlaXZlZCB0aGlzIGNvbW11bmljYXRpb24gaW4gZXJyb3IsIHBsZWFzZSBlcmFzZSBhbGwgY29w aWVzIG9mIHRoZSBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMgYW5kIG5vdGlmeSB0aGUgc2Vu ZGVyIGltbWVkaWF0ZWx5LiBUaGFuayB5b3UuDQoKCgpDZSBtZXNzYWdlIGV0IHRvdXRlcyBsZXMg cGnDqGNlcyBqb2ludGVzIChjaS1hcHLDqHMgbGUgJ01lc3NhZ2UnKSBzb250IMOpdGFibGlzIMOg IGwnaW50ZW50aW9uIGV4Y2x1c2l2ZSBkZXMgZGVzdGluYXRhaXJlcyBldCBsZXMgaW5mb3JtYXRp b25zIHF1aSB5IGZpZ3VyZW50IHNvbnQgc3RyaWN0ZW1lbnQgY29uZmlkZW50aWVsbGVzLiBUb3V0 ZSB1dGlsaXNhdGlvbiBkZSBjZSBNZXNzYWdlIG5vbiBjb25mb3JtZSDDoCBzYSBkZXN0aW5hdGlv biwgdG91dGUgZGlmZnVzaW9uIG91IHRvdXRlIHB1YmxpY2F0aW9uIHRvdGFsZSBvdSBwYXJ0aWVs bGUsIGVzdCBpbnRlcmRpdGUgc2F1ZiBhdXRvcmlzYXRpb24gZXhwcmVzc2UuCgpTaSB2b3VzIG4n w6p0ZXMgcGFzIGxlIGRlc3RpbmF0YWlyZSBkZSBjZSBNZXNzYWdlLCBpbCB2b3VzIGVzdCBpbnRl cmRpdCBkZSBsZSBjb3BpZXIsIGRlIGxlIGZhaXJlIHN1aXZyZSwgZGUgbGUgZGl2dWxndWVyIG91 IGQnZW4gdXRpbGlzZXIgdG91dCBvdSBwYXJ0aWUuIFNpIHZvdXMgYXZleiByZcOndSBjZSBNZXNz YWdlIHBhciBlcnJldXIsIG1lcmNpIGRlIGxlIHN1cHByaW1lciBkZSB2b3RyZSBzeXN0w6htZSwg YWluc2kgcXVlIHRvdXRlcyBzZXMgY29waWVzLCBldCBkZSBuJ2VuIGdhcmRlciBhdWN1bmUgdHJh Y2Ugc3VyIHF1ZWxxdWUgc3VwcG9ydCBxdWUgY2Ugc29pdC4gTm91cyB2b3VzIHJlbWVyY2lvbnMg w6lnYWxlbWVudCBkJ2VuIGF2ZXJ0aXIgaW1tw6lkaWF0ZW1lbnQgbCdleHDDqWRpdGV1ciBwYXIg cmV0b3VyIGR1IG1lc3NhZ2UuCgpJbCBlc3QgaW1wb3NzaWJsZSBkZSBnYXJhbnRpciBxdWUgbGVz IGNvbW11bmljYXRpb25zIHBhciBtZXNzYWdlcmllIMOpbGVjdHJvbmlxdWUgYXJyaXZlbnQgZW4g dGVtcHMgdXRpbGUsIHNvbnQgc8OpY3VyaXPDqWVzIG91IGTDqW51w6llcyBkZSB0b3V0ZSBlcnJl dXIgb3UgdmlydXMuCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX18KClRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1lbnRzICh0aGUgJ01lc3NhZ2Un KSBhcmUgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUgYWRkcmVzc2Vlcy4gVGhlIGluZm9ybWF0aW9u IGNvbnRhaW5lZCBpbiB0aGlzIE1lc3NhZ2UgaXMgY29uZmlkZW50aWFsLiBBbnkgdXNlIG9mIGlu Zm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIE1lc3NhZ2Ugbm90IGluIGFjY29yZCB3aXRoIGl0 cyBwdXJwb3NlLCBhbnkgZGlzc2VtaW5hdGlvbiBvciBkaXNjbG9zdXJlLCBlaXRoZXIgd2hvbGUg b3IgcGFydGlhbCwgaXMgcHJvaGliaXRlZCBleGNlcHQgZm9ybWFsIGFwcHJvdmFsLgoKSWYgeW91 IGFyZSBub3QgdGhlIGFkZHJlc3NlZSwgeW91IG1heSBub3QgY29weSwgZm9yd2FyZCwgZGlzY2xv c2Ugb3IgdXNlIGFueSBwYXJ0IG9mIGl0LiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIG1lc3Nh Z2UgaW4gZXJyb3IsIHBsZWFzZSBkZWxldGUgaXQgYW5kIGFsbCBjb3BpZXMgZnJvbSB5b3VyIHN5 c3RlbSBhbmQgbm90aWZ5IHRoZSBzZW5kZXIgaW1tZWRpYXRlbHkgYnkgcmV0dXJuIG1lc3NhZ2Uu CgpFLW1haWwgY29tbXVuaWNhdGlvbiBjYW5ub3QgYmUgZ3VhcmFudGVlZCB0byBiZSB0aW1lbHkg c2VjdXJlLCBlcnJvciBvciB2aXJ1cy1mcmVlLgo=