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 1g9DrJ-0007i5-MA for pgsql-performance@arkaria.postgresql.org; Sun, 07 Oct 2018 18:32:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9DrH-0002MH-89 for pgsql-performance@arkaria.postgresql.org; Sun, 07 Oct 2018 18:32:51 +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 1g9DrG-0002M2-Sl; Sun, 07 Oct 2018 18:32:51 +0000 Received: from mtagatea.edf.fr ([163.114.23.130]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9Dr8-0007aZ-Sp; Sun, 07 Oct 2018 18:32:49 +0000 From: ROS Didier To: "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//vN6Q Date: Sun, 7 Oct 2018 18:32:38 +0000 Message-ID: <3a14f7f8fbda4e868b663b31e8c5fa16@PCYINTPEXMU001.NEOPROD.EDF.FR> References: <74090066a33740ea8fc442cc70f8afa2@PCYINTPEXMU001.NEOPROD.EDF.FR> In-Reply-To: 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 SGkgRnJhbmNpc2NvDQoNCglUaGFuayB5b3UgZm9yIHlvdXIgcmVtYXJrLiANCglZb3UncmUgcmln aHQsIGJ1dCBpdCdzIHRoZSBvbmx5IHByb2NlZHVyZSBJIGZvdW5kIHRvIG1ha2Ugc2VhcmNoIG9u IGVuY3J5cHRlZCBmaWVsZHMgd2l0aCBnb29kIHJlc3BvbnNlIHRpbWVzICh1c2luZyBpbmRleCkg IQ0KDQoJUmVnYXJkaW5nIGFjY2VzcyB0byB0aGUgZmlsZSBzeXN0ZW0sIG91ciBzZXJ2ZXJzIGFy ZSBpbiBwcm90ZWN0ZWQgbmV0d29yayBhcmVhcy4gZmV3IHBlb3BsZSBjYW4gY29ubmVjdCB0byBp dC4NCg0KCWl0J3Mgbm90IHRoZSBiZXN0IHNvbHV0aW9uLCBidXQgd2UgaGF2ZSBkYXRhIGVuY3J5 cHRpb24gbmVlZHMgYW5kIGdvb2QgcGVyZm9ybWFuY2UgbmVlZHMgdG9vLiBJIGRvIG5vdCBrbm93 IGhvdyB0byBkbyBpdCBleGNlcHQgdGhlIHNwZWNpZmllZCBwcm9jZWR1cmUuLg0KCWlmIGFueW9u ZSBoYXMgYW55IHByb3Bvc2FscyB0byBwdXQgdGhpcyBpbiBwbGFjZSwgSSdtIGludGVyZXN0ZWQu DQoNCglUaGFua3MgaW4gYWR2YW5jZQ0KDQpCZXN0IFJlZ2FyZHMNCkRpZGllciBST1MNCg0KLS0t LS1NZXNzYWdlIGQnb3JpZ2luZS0tLS0tDQpEZcKgOiBmb2xhcnRlQHBlb3BsZWNhbGwuY29tIFtt YWlsdG86Zm9sYXJ0ZUBwZW9wbGVjYWxsLmNvbV0gDQpFbnZvecOpwqA6IGRpbWFuY2hlIDcgb2N0 b2JyZSAyMDE4IDE3OjU4DQrDgMKgOiBST1MgRGlkaWVyIDxkaWRpZXIucm9zQGVkZi5mcj4NCkNj wqA6IHBhdmVsLnN0ZWh1bGVAZ21haWwuY29tOyBwZ3NxbC1zcWxAbGlzdHMucG9zdGdyZXNxbC5v cmc7IHBnc3FsLXBlcmZvcm1hbmNlQGxpc3RzLnBvc3RncmVzcWwub3JnOyBwZ3NxbC1nZW5lcmFs QGxpc3RzLnBvc3RncmVzcWwub3JnDQpPYmpldMKgOiBSZTogV2h5IHRoZSBpbmRleCBpcyBub3Qg dXNlZCA/DQoNClJPUzoNCg0KT24gU3VuLCBPY3QgNywgMjAxOCBhdCAzOjEzIFBNLCBST1MgRGlk aWVyIDxkaWRpZXIucm9zQGVkZi5mcj4gd3JvdGU6DQouLi4uDQo+IC0gICAgICAgIElOU0VSVCBJ TlRPIGNhcnRlZGVjcmVkaXQodXNlcm5hbWUsY2MpICBTRUxFQ1QgJ2luZGl2aWR1ICcgfHwgeC5p ZCwgcGdwX3N5bV9lbmNyeXB0KCd0ZXN0IHZhbHVlICcgfHwgeC5pZCwgJ21vdGRlcGFzc2UnLCdj b21wcmVzcy1hbGdvPTIsIGNpcGhlci1hbGdvPWFlczI1NicpIEZST00gZ2VuZXJhdGVfc2VyaWVz KDEsMTAwMDAwKSBBUyB4KGlkKTsNCj4gLSAgICAgICAgQ1JFQVRFIElOREVYIGlkeF9jYXJ0ZWRl Y3JlZGl0X2NjMDIgT04gY2FydGVkZWNyZWRpdChwZ3Bfc3ltX2RlY3J5cHQoY2MsICdtb3RkZXBh c3NlJywnY29tcHJlc3MtYWxnbz0yLCBjaXBoZXItYWxnbz1hZXMyNTYnKSk7DQoNCklmIG15IGZy ZW5jaCBpcyBub3QgdG9vIHJ1c3R5IHlvdSBhcmUgZW5jcnlwdGluZyBhIGNyZWRpdC1jYXJkLCBh bmQgdGhlbiBzdG9yaW5nIGFuIFVORU5DUllQVEVEIGNvcHkgaW4gdGhlIGluZGV4LiBTbywgZ2V0 dGluZyBpdCBmcm9tIHRoZSBzZXJ2ZXIgaXMgdHJpdmlhbCBmb3IgYW55b25lIHdpdGggZmlsZXN5 c3RlbSBhY2Nlc3MuDQoNCkZyYW5jaXNjbyBPbGFydGUuDQoKCgpDZSBtZXNzYWdlIGV0IHRvdXRl cyBsZXMgcGnDqGNlcyBqb2ludGVzIChjaS1hcHLDqHMgbGUgJ01lc3NhZ2UnKSBzb250IMOpdGFi bGlzIMOgIGwnaW50ZW50aW9uIGV4Y2x1c2l2ZSBkZXMgZGVzdGluYXRhaXJlcyBldCBsZXMgaW5m b3JtYXRpb25zIHF1aSB5IGZpZ3VyZW50IHNvbnQgc3RyaWN0ZW1lbnQgY29uZmlkZW50aWVsbGVz LiBUb3V0ZSB1dGlsaXNhdGlvbiBkZSBjZSBNZXNzYWdlIG5vbiBjb25mb3JtZSDDoCBzYSBkZXN0 aW5hdGlvbiwgdG91dGUgZGlmZnVzaW9uIG91IHRvdXRlIHB1YmxpY2F0aW9uIHRvdGFsZSBvdSBw YXJ0aWVsbGUsIGVzdCBpbnRlcmRpdGUgc2F1ZiBhdXRvcmlzYXRpb24gZXhwcmVzc2UuCgpTaSB2 b3VzIG4nw6p0ZXMgcGFzIGxlIGRlc3RpbmF0YWlyZSBkZSBjZSBNZXNzYWdlLCBpbCB2b3VzIGVz dCBpbnRlcmRpdCBkZSBsZSBjb3BpZXIsIGRlIGxlIGZhaXJlIHN1aXZyZSwgZGUgbGUgZGl2dWxn dWVyIG91IGQnZW4gdXRpbGlzZXIgdG91dCBvdSBwYXJ0aWUuIFNpIHZvdXMgYXZleiByZcOndSBj ZSBNZXNzYWdlIHBhciBlcnJldXIsIG1lcmNpIGRlIGxlIHN1cHByaW1lciBkZSB2b3RyZSBzeXN0 w6htZSwgYWluc2kgcXVlIHRvdXRlcyBzZXMgY29waWVzLCBldCBkZSBuJ2VuIGdhcmRlciBhdWN1 bmUgdHJhY2Ugc3VyIHF1ZWxxdWUgc3VwcG9ydCBxdWUgY2Ugc29pdC4gTm91cyB2b3VzIHJlbWVy Y2lvbnMgw6lnYWxlbWVudCBkJ2VuIGF2ZXJ0aXIgaW1tw6lkaWF0ZW1lbnQgbCdleHDDqWRpdGV1 ciBwYXIgcmV0b3VyIGR1IG1lc3NhZ2UuCgpJbCBlc3QgaW1wb3NzaWJsZSBkZSBnYXJhbnRpciBx dWUgbGVzIGNvbW11bmljYXRpb25zIHBhciBtZXNzYWdlcmllIMOpbGVjdHJvbmlxdWUgYXJyaXZl bnQgZW4gdGVtcHMgdXRpbGUsIHNvbnQgc8OpY3VyaXPDqWVzIG91IGTDqW51w6llcyBkZSB0b3V0 ZSBlcnJldXIgb3UgdmlydXMuCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX18KClRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1lbnRzICh0aGUgJ01l c3NhZ2UnKSBhcmUgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUgYWRkcmVzc2Vlcy4gVGhlIGluZm9y bWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIE1lc3NhZ2UgaXMgY29uZmlkZW50aWFsLiBBbnkgdXNl IG9mIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIE1lc3NhZ2Ugbm90IGluIGFjY29yZCB3 aXRoIGl0cyBwdXJwb3NlLCBhbnkgZGlzc2VtaW5hdGlvbiBvciBkaXNjbG9zdXJlLCBlaXRoZXIg d2hvbGUgb3IgcGFydGlhbCwgaXMgcHJvaGliaXRlZCBleGNlcHQgZm9ybWFsIGFwcHJvdmFsLgoK SWYgeW91IGFyZSBub3QgdGhlIGFkZHJlc3NlZSwgeW91IG1heSBub3QgY29weSwgZm9yd2FyZCwg ZGlzY2xvc2Ugb3IgdXNlIGFueSBwYXJ0IG9mIGl0LiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlz IG1lc3NhZ2UgaW4gZXJyb3IsIHBsZWFzZSBkZWxldGUgaXQgYW5kIGFsbCBjb3BpZXMgZnJvbSB5 b3VyIHN5c3RlbSBhbmQgbm90aWZ5IHRoZSBzZW5kZXIgaW1tZWRpYXRlbHkgYnkgcmV0dXJuIG1l c3NhZ2UuCgpFLW1haWwgY29tbXVuaWNhdGlvbiBjYW5ub3QgYmUgZ3VhcmFudGVlZCB0byBiZSB0 aW1lbHkgc2VjdXJlLCBlcnJvciBvciB2aXJ1cy1mcmVlLgo=