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 1gf44c-0000FC-1W for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2019 14:34:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gf44a-0005Gv-OB for pgsql-performance@arkaria.postgresql.org; Thu, 03 Jan 2019 14:34:12 +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 1gf44a-0005Go-5q for pgsql-performance@lists.postgresql.org; Thu, 03 Jan 2019 14:34:12 +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 1gf44V-000338-LD for pgsql-performance@lists.postgresql.org; Thu, 03 Jan 2019 14:34:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iter.org; l=18204; q=dns/txt; s=20170425; t=1546526047; x=1547130847; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=qje2eAK75t+6NjasVzJsFubJMglpQPi/FgAKRVQZMzs=; b=XRtbrNtJvgS6HKNXgz3O/WQdtfo5wJoOlIA48yDx7CKfPQNBdKeeZfx9 QbvXrf0CHQTNotM33iS2aCSjkdHri8gH/DLx+pVKInD6QwtFlwcDOgrmE xgZ85JWf/0Zfbi2K0K0ZMYsXHsm1+xACrFzaUWnj+im9Mo/hHFVGkClhf Y=; Received: from XCH-CLU1N3.iter.org (10.10.242.164) by XCH-CLU1N1.iter.org (10.10.240.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 15:34:03 +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 15:34:03 +0100 From: Abadie Lana To: Abadie Lana , 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//+6z4P//yO9w Date: Thu, 3 Jan 2019 14:34:03 +0000 Message-ID: <21c842f922fd4ae8927bf9c15e4df7c5@iter.org> 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 ZXcNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IHBnc3FsLXBlcmZvcm1hbmNl LW93bmVyK00yMjg4OC0xMTIyOThAbGlzdHMucG9zdGdyZXNxbC5vcmcgPHBnc3FsLXBlcmZvcm1h bmNlLW93bmVyK00yMjg4OC0xMTIyOThAbGlzdHMucG9zdGdyZXNxbC5vcmc+IE9uIEJlaGFsZiBP ZiBBYmFkaWUgTGFuYQ0KU2VudDogMDMgSmFudWFyeSAyMDE5IDE0OjIxDQpUbzogRGF2aWQgUm93 bGV5IDxkYXZpZC5yb3dsZXlAMm5kcXVhZHJhbnQuY29tPg0KQ2M6IHBnc3FsLXBlcmZvcm1hbmNl QGxpc3RzLnBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBbUG9zc2libGUgU3Bvb2ZdIFJFOiBzZWxl Y3QgcXVlcnkgZG9lcyBub3QgcGljayB1cCB0aGUgcmlnaHQgaW5kZXgNCg0KV2FybmluZzogVGhp cyBtZXNzYWdlIHdhcyBzZW50IGJ5IHBnc3FsLXBlcmZvcm1hbmNlLW93bmVyK00yMjg4OC0xMTIy OThAbGlzdHMucG9zdGdyZXNxbC5vcmcgc3VwcG9zZWRseSBvbiBiZWhhbGYgb2YgQWJhZGllIExh bmEgPExhbmEuQWJhZGllQGl0ZXIub3JnPi4gUGxlYXNlIGNvbnRhY3QNCg0KDQoNCg0KTGFuYSBB QkFESUUNCkRhdGFiYXNlIEVuZ2luZWVyDQpDT0RBQyBTZWN0aW9uDQoNCklURVIgT3JnYW5pemF0 aW9uLCBCdWlsZGluZyA3Mi80MTA4LCBTQ09ELCBDb250cm9sIFN5c3RlbSBEaXZpc2lvbiBSb3V0 ZSBkZSBWaW5vbi1zdXItVmVyZG9uIC0gQ1MgOTAgMDQ2IC0gMTMwNjcgU3QgUGF1bCBMZXogRHVy YW5jZSBDZWRleCAtIEZyYW5jZQ0KUGhvbmU6ICszMyA0IDQyIDE3IDg0IDAyDQpHZXQgdGhlIGxh dGVzdCBJVEVSIG5ld3Mgb24gaHR0cDovL3d3dy5pdGVyLm9yZy93aGF0c25ldw0KDQotLS0tLU9y aWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogRGF2aWQgUm93bGV5IDxkYXZpZC5yb3dsZXlAMm5k cXVhZHJhbnQuY29tPg0KU2VudDogMDMgSmFudWFyeSAyMDE5IDE0OjE4DQpUbzogQWJhZGllIExh bmEgPExhbmEuQWJhZGllQGl0ZXIub3JnPg0KQ2M6IHBnc3FsLXBlcmZvcm1hbmNlQGxpc3RzLnBv c3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogc2VsZWN0IHF1ZXJ5IGRvZXMgbm90IHBpY2sgdXAg dGhlIHJpZ2h0IGluZGV4DQoNCj4gRnJvbTogRGF2aWQgUm93bGV5IDxkYXZpZC5yb3dsZXlAMm5k cXVhZHJhbnQuY29tPg0KPiBTZW50OiAwMyBKYW51YXJ5IDIwMTkgMTQ6MDENCj4gVGhhdCdzIHN1 cnByaXNpbmdseSBzbG93LiBDYW4geW91IHNoYXJlIHRoZSBFWFBMQUlOIChBTkFMWVpFLCBCVUZG RVJTKSBvZiB0aGF0Pw0KPg0KPiBleHBsYWluIChhbmFseXplLGJ1ZmZlcnMpIHNlbGVjdA0KPiAn QlVJTC1CMzYtVkEtUlQtUlQxOkNMMDAwMS0yLUFCVycsYy5zbXBsX3RpbWUsYy5uYW5vc2Vjcyxj LmZsb2F0X3ZhbCxjDQo+IC5udW1fdmFsLGMuc3RyX3ZhbCxjLmRhdGF0eXBlLGMuYXJyYXlfdmFs IGZyb20gc2FtcGxlIGMgV0hFUkUgDQo+IGMuY2hhbm5lbF9pZCA9IChTRUxFQ1QgY2hhbm5lbF9p ZCBGUk9NIGNoYW5uZWwgV0hFUkUNCj4gbmFtZT0nQlVJTC1CMzYtVkEtUlQtUlQxOkNMMDAwMS0y LUFCVycpIG9yZGVyIGJ5IGMuc21wbF90aW1lIGRlc2MgDQo+IGxpbWl0IDU7DQoNCg0KPiAgICAg ICAgICAgICAgICAtPiAgSW5kZXggU2NhbiBCYWNrd2FyZCB1c2luZyBzbXBsX3RpbWVfYngyX2lk eCBvbiANCj4gc2FtcGxlX2J1aWxfeWVhciBjXzUgIChjb3N0PTAuNTYuLjIwMjM5MjUuMzAgcm93 cz0zMTYyMzY0DQo+IHdpZHRoPTMyMCkgKGFjdHVhbCB0aW1lPTE1MTY3LjMzMC4uMTUxNjcuMzMw IHJvd3M9MCBsb29wcz0xKQ0KPiAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChjaGFubmVs X2lkID0gJDApDQo+ICAgICAgICAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6 IDUwNTk3ODM0DQo+ICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MjU5 MTMxNDcgcmVhZD03MTMyMjENCj4gICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gQmFja3dh cmQgdXNpbmcgc2FtcGxlX3RpbWVfY21faWR4IG9uIA0KPiBzYW1wbGVfY3RybF9tb250aCBjXzYg IChjb3N0PTAuNTYuLjE4NjI1ODcuMTIgcm93cz01Mzc1NjINCj4gIHdpZHRoPTc3KSAoYWN0dWFs IHRpbWU9MC4wNDguLjAuMDQ4IHJvd3M9MCBsb29wcz0xKQ0KPiAgICAgICAgICAgICAgICAgICAg ICBJbmRleCBDb25kOiAoY2hhbm5lbF9pZCA9ICQwKQ0KPiAgICAgICAgICAgICAgICAgICAgICBC dWZmZXJzOiBzaGFyZWQgcmVhZD00DQo+ICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIEJh Y2t3YXJkIHVzaW5nIHNtcGxfdGltZV9jbXgyX2lkeCBvbiANCj4gc2FtcGxlX2N0cmxfeWVhciBj XzcgIChjb3N0PTAuNTcuLjMxODYzMDUuNjcgcm93cz0yMDk0MTg2DQo+ICB3aWR0aD02OCkgKGFj dHVhbCB0aW1lPTI1ODQ3LjU0OS4uMjU4NDcuNTQ5IHJvd3M9MCBsb29wcz0xKQ0KPiAgICAgICAg ICAgICAgICAgICAgICBGaWx0ZXI6IChjaGFubmVsX2lkID0gJDApDQo+ICAgICAgICAgICAgICAg ICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDc5NTc5MDc1DQo+ICAgICAgICAgICAgICAg ICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9NDk4Njg5OTEgcmVhZD0xMTIxNzE1DQoNClJpZ2h0 LCBzbyB5b3UgbmVlZCB0byBjaGVjayB5b3VyIGluZGV4ZXMgb24gc2FtcGxlX2N0cmxfeWVhciBh bmQgc2FtcGxlX2J1aWxfeWVhci4gWW91IG5lZWQgYW4gaW5kZXggb24gKGNoYW5uZWxfaWQsIHNt cGxfdGltZSkgb24gdGhvc2UuDQoNCg0KVGhlc2UgaW5kZXhlcyBleGlzdCBhbHJlYWR5DQpcZCBz YW1wbGVfY3RybF95ZWFyDQogICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLnNh bXBsZV9jdHJsX3llYXIiDQogICBDb2x1bW4gICAgfCAgICAgICAgICAgIFR5cGUgICAgICAgICAg ICAgfCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8ICAgRGVmYXVsdA0KLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tDQot LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t LS0tLS0tLS0rLS0tLS0NCi0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0NCiBjaGFubmVsX2lkICB8IGJpZ2ludCAgICAg ICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBzbXBsX3RpbWUgICB8 IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBu YW5vc2VjcyAgICB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5v dCBudWxsIHwNCiBzZXZlcml0eV9pZCB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8ICAg ICAgICAgICB8IG5vdCBudWxsIHwNCiBzdGF0dXNfaWQgICB8IGJpZ2ludCAgICAgICAgICAgICAg ICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBudW1fdmFsICAgICB8IGludGVnZXIg ICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwNCiBmbG9hdF92YWwg ICB8IGRvdWJsZSBwcmVjaXNpb24gICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwN CiBzdHJfdmFsICAgICB8IGNoYXJhY3RlciB2YXJ5aW5nKDEyMCkgICAgICB8ICAgICAgICAgICB8 ICAgICAgICAgIHwNCiBkYXRhdHlwZSAgICB8IGNoYXJhY3RlcigxKSAgICAgICAgICAgICAgICB8 ICAgICAgICAgICB8ICAgICAgICAgIHwgJyAnOjpicGNoYXINCiBhcnJheV92YWwgICB8IGJ5dGVh ICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwNCkluZGV4ZXM6 DQogICAgInNhbXBsZV90aW1lX2N5X2lkeCIgYnRyZWUgKGNoYW5uZWxfaWQsIHNtcGxfdGltZSkN CiAgICAic2FtcGxlX3RpbWVfeWMxX2lkeCIgYnRyZWUgKHNtcGxfdGltZSwgY2hhbm5lbF9pZCkN CiAgICAic21wbF90aW1lX2NteDJfaWR4IiBidHJlZSAoc21wbF90aW1lKSBDaGVjayBjb25zdHJh aW50czoNCiAgICAic2FtcGxlX2N0cmxfeWVhcl9zbXBsX3RpbWVfY2hlY2siIENIRUNLIChzbXBs X3RpbWUgPj0gKG5vdygpIC0gJzEgeWVhciAxIG1vbic6OmludGVydmFsKTo6dGltZXN0YW1wIHdp dGhvdXQgdGltZSB6b25lIEFORCBzbXBsX3RpbWUgPD0gbm93KCkpDQpJbmhlcml0czogc2FtcGxl X2N0cmwNCg0KY3NzX2FyY2hpdmVfM18wXzA9IyBcZCBzYW1wbGVfYnVpbF95ZWFyDQogICAgICAg ICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLnNhbXBsZV9idWlsX3llYXIiDQogICBDb2x1 bW4gICAgfCAgICAgICAgICAgIFR5cGUgICAgICAgICAgICAgfCBDb2xsYXRpb24gfCBOdWxsYWJs ZSB8ICAgRGVmYXVsdA0KLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tDQotLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0NCi0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0t LSstLS0NCiBjaGFubmVsX2lkICB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8ICAgICAg ICAgICB8IG5vdCBudWxsIHwNCiBzbXBsX3RpbWUgICB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUg em9uZSB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBuYW5vc2VjcyAgICB8IGJpZ2ludCAgICAg ICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBzZXZlcml0eV9pZCB8 IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwNCiBz dGF0dXNfaWQgICB8IGJpZ2ludCAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5v dCBudWxsIHwNCiBudW1fdmFsICAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8ICAg ICAgICAgICB8ICAgICAgICAgIHwNCiBmbG9hdF92YWwgICB8IGRvdWJsZSBwcmVjaXNpb24gICAg ICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwNCiBzdHJfdmFsICAgICB8IGNoYXJhY3Rl ciB2YXJ5aW5nKDEyMCkgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwNCiBkYXRhdHlwZSAg ICB8IGNoYXJhY3RlcigxKSAgICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwg JyAnOjpicGNoYXINCiBhcnJheV92YWwgICB8IGJ5dGVhICAgICAgICAgICAgICAgICAgICAgICB8 ICAgICAgICAgICB8ICAgICAgICAgIHwNCkluZGV4ZXM6DQogICAgInNhbXBsZV90aW1lX2J5X2lk eCIgYnRyZWUgKGNoYW5uZWxfaWQsIHNtcGxfdGltZSkNCiAgICAic2FtcGxlX3RpbWVfeWIxX2lk eCIgYnRyZWUgKHNtcGxfdGltZSwgY2hhbm5lbF9pZCkNCiAgICAic21wbF90aW1lX2J4Ml9pZHgi IGJ0cmVlIChzbXBsX3RpbWUpIENoZWNrIGNvbnN0cmFpbnRzOg0KICAgICJzYW1wbGVfYnVpbF95 ZWFyX3NtcGxfdGltZV9jaGVjayIgQ0hFQ0sgKHNtcGxfdGltZSA+PSAobm93KCkgLSAnMSB5ZWFy IDEgbW9uJzo6aW50ZXJ2YWwpOjp0aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpvbmUgQU5EIHNtcGxf dGltZSA8PSBub3coKSkNCkluaGVyaXRzOiBzYW1wbGVfYnVpbA0KDQpjc3NfYXJjaGl2ZV8zXzBf MD0jDQoNCi0tIA0KIERhdmlkIFJvd2xleSAgICAgICAgICAgICAgICAgICBodHRwOi8vd3d3LjJu ZFF1YWRyYW50LmNvbS8NCiBQb3N0Z3JlU1FMIERldmVsb3BtZW50LCAyNHg3IFN1cHBvcnQsIFRy YWluaW5nICYgU2VydmljZXMNCg0KSW4gY2FzZSBJJ20gYWxzbyBwb3N0aW5nIHRoZSBleHBsYWlu IGFuYWx5c2Ugb2YgdGhlIG90aGVyIHF1ZXJ5DQpleHBsYWluIChhbmFseXplLGJ1ZmZlcnMpIHNl bGVjdCB0Lm5hbWUsIGMuc21wbF90aW1lLGMubmFub3NlY3MsYy5mbG9hdF92YWwsYy5udW1fdmFs LGMuc3RyX3ZhbCxjLmRhdGF0eXBlLGMuYXJyYXlfdmFsIGZyb20gc2FtcGxlIGMsIGNoYW5uZWwg dCB3aGVyZSB0LmNoYW5uZWxfaWQ9Yy5jaGFubmVsX2lkIGFuZCB0Lm5hbWU9J0JVSUwtQjM2LVZB LVJULVJUMTpDTDAwMDEtMi1BQlcnICAgb3JkZXIgYnkgYy5zbXBsX3RpbWUgK0lOVEVSVkFMICcw IHNlYycgZGVzYyBsaW1pdCA1OyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBRVUVSWSBQTEFODQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCiBMaW1pdCAgKGNvc3Q9Mjc0NjY1MC41Ny4uMjc0NjY1MC41OSByb3dzPTUgd2lk dGg9MTU4KSAoYWN0dWFsIHRpbWU9MTE5LjkyNy4uMTE5LjkyOSByb3dzPTMgbG9vcHM9MSkNCiAg IEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MyByZWFkPTUzMQ0KICAgLT4gIFNvcnQgIChjb3N0PTI3NDY2 NTAuNTcuLjI3NDY2NzQuNjYgcm93cz05NjM2IHdpZHRoPTE1OCkgKGFjdHVhbCB0aW1lPTExOS45 MjUuLjExOS45MjYgcm93cz0zIGxvb3BzPTEpDQogICAgICAgICBTb3J0IEtleTogKChjLnNtcGxf dGltZSArICcwMDowMDowMCc6OmludGVydmFsKSkgREVTQw0KICAgICAgICAgU29ydCBNZXRob2Q6 IHF1aWNrc29ydCAgTWVtb3J5OiAyNWtCDQogICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTMg cmVhZD01MzENCiAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4wMC4uMjc0NjQ5MC41 MiByb3dzPTk2MzYgd2lkdGg9MTU4KSAoYWN0dWFsIHRpbWU9NDYuOTQ2Li4xMTkuODk3IHJvd3M9 MyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhpdD0zIHJlYWQ9NTMx DQogICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gY2hhbm5lbCB0ICAoY29zdD0wLjAwLi45 MTUuODMgcm93cz0xIHdpZHRoPTQxKSAoYWN0dWFsIHRpbWU9MTYuMjE3Li4xOC4yNTcgcm93cz0x IGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6ICgobmFtZSk6OnRleHQgPSAn QlVJTC1CMzYtVkEtUlQtUlQxOkNMMDAwMS0yLUFCVyc6OnRleHQpDQogICAgICAgICAgICAgICAg ICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiAzMzQyNQ0KICAgICAgICAgICAgICAgICAgICAg QnVmZmVyczogc2hhcmVkIGhpdD0xIHJlYWQ9NDk3DQogICAgICAgICAgICAgICAtPiAgQXBwZW5k ICAoY29zdD0wLjAwLi4yNjg0Mzc3LjM4IHJvd3M9NjExNzMyMyB3aWR0aD0xMjUpIChhY3R1YWwg dGltZT0zMC43MTcuLjEwMS42MjQgcm93cz0zIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAg ICBCdWZmZXJzOiBzaGFyZWQgaGl0PTIgcmVhZD0zNA0KICAgICAgICAgICAgICAgICAgICAgLT4g IFNlcSBTY2FuIG9uIHNhbXBsZSBjICAoY29zdD0wLjAwLi4wLjAwIHJvd3M9MSB3aWR0aD0zMzQp IChhY3R1YWwgdGltZT0wLjAwMi4uMC4wMDIgcm93cz0wIGxvb3BzPTEpDQogICAgICAgICAgICAg ICAgICAgICAgICAgICBGaWx0ZXI6ICh0LmNoYW5uZWxfaWQgPSBjaGFubmVsX2lkKQ0KICAgICAg ICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4gb24gc2FtcGxlX2J1aWwgY18xICAo Y29zdD0xNDkuMjUuLjEwNDA0LjMyIHJvd3M9NjMwMCB3aWR0aD0zMjgpIChhY3R1YWwgdGltZT05 LjI0MQ0KLi45LjI0MiByb3dzPTAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAg IFJlY2hlY2sgQ29uZDogKGNoYW5uZWxfaWQgPSB0LmNoYW5uZWxfaWQpDQogICAgICAgICAgICAg ICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgcmVhZD0zDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gc2FtcGxlX3RpbWVfYl9pZHggIChjb3N0 PTAuMDAuLjE0Ny42OCByb3dzPTYzMDAgd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTkuDQoyMzcuLjku MjM3IHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5k ZXggQ29uZDogKGNoYW5uZWxfaWQgPSB0LmNoYW5uZWxfaWQpDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFyZWQgcmVhZD0zDQogICAgICAgICAgICAgICAgICAg ICAtPiAgQml0bWFwIEhlYXAgU2NhbiBvbiBzYW1wbGVfY3RybCBjXzIgIChjb3N0PTc4MS4zMC4u MTE5MTIuMDYgcm93cz0zMzY2MSB3aWR0aD0zMjgpIChhY3R1YWwgdGltZT0wLjAyDQowLi4wLjAy MCByb3dzPTAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIFJlY2hlY2sgQ29u ZDogKGNoYW5uZWxfaWQgPSB0LmNoYW5uZWxfaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAg ICBCdWZmZXJzOiBzaGFyZWQgcmVhZD0zDQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg Qml0bWFwIEluZGV4IFNjYW4gb24gc2FtcGxlX3RpbWVfY19pZHggIChjb3N0PTAuMDAuLjc3Mi44 OCByb3dzPTMzNjYxIHdpZHRoPTApIChhY3R1YWwgdGltZT0wDQouMDE4Li4wLjAxOCByb3dzPTAg bG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChj aGFubmVsX2lkID0gdC5jaGFubmVsX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgQnVmZmVyczogc2hhcmVkIHJlYWQ9Mw0KICAgICAgICAgICAgICAgICAgICAgLT4gIEJpdG1h cCBIZWFwIFNjYW4gb24gc2FtcGxlX3V0aWwgY18zICAoY29zdD0yMjEuOTMuLjI1NDAxLjM3IHJv d3M9OTQ4MyB3aWR0aD0zMjgpIChhY3R1YWwgdGltZT03Ljg4OA0KLi43Ljg4OCByb3dzPTAgbG9v cHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIFJlY2hlY2sgQ29uZDogKGNoYW5uZWxf aWQgPSB0LmNoYW5uZWxfaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICBCdWZmZXJzOiBz aGFyZWQgcmVhZD0zDQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgQml0bWFwIEluZGV4 IFNjYW4gb24gc2FtcGxlX3RpbWVfdV9pZHggIChjb3N0PTAuMDAuLjIxOS41NiByb3dzPTk0ODMg d2lkdGg9MCkgKGFjdHVhbCB0aW1lPTcuDQo4ODYuLjcuODg2IHJvd3M9MCBsb29wcz0xKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNoYW5uZWxfaWQgPSB0 LmNoYW5uZWxfaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBCdWZmZXJzOiBz aGFyZWQgcmVhZD0zDQogICAgICAgICAgICAgICAgICAgICAtPiAgQml0bWFwIEhlYXAgU2NhbiBv biBzYW1wbGVfYnVpbF9tb250aCBjXzQgIChjb3N0PTM2Ni4zMi4uNDcxMTguMDggcm93cz0xNTcx MSB3aWR0aD04MikgKGFjdHVhbCB0aW1lDQo9MTMuNTU2Li4yNC44NzAgcm93cz0zIGxvb3BzPTEp DQogICAgICAgICAgICAgICAgICAgICAgICAgICBSZWNoZWNrIENvbmQ6IChjaGFubmVsX2lkID0g dC5jaGFubmVsX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgSGVhcCBCbG9ja3M6IGV4 YWN0PTMNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCByZWFkPTcN CiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBCaXRtYXAgSW5kZXggU2NhbiBvbiBzYW1w bGVfdGltZV9ibV9pZHggIChjb3N0PTAuMDAuLjM2Mi4zOSByb3dzPTE1NzExIHdpZHRoPTApIChh Y3R1YWwgdGltZT0NCjYuNzEyLi42LjcxMiByb3dzPTMgbG9vcHM9MSkNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChjaGFubmVsX2lkID0gdC5jaGFubmVsX2lk KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIHJlYWQ9 NA0KICAgICAgICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4gb24gc2FtcGxlX2J1 aWxfeWVhciBjXzUgIChjb3N0PTczMjE2Ljg5Li42ODc3MTguNDQgcm93cz0zMTYyMzY0IHdpZHRo PTMyOCkgKGFjdHVhbA0KIHRpbWU9MTguMDE1Li4xOC4wMTUgcm93cz0wIGxvb3BzPTEpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICBSZWNoZWNrIENvbmQ6IChjaGFubmVsX2lkID0gdC5jaGFu bmVsX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIHJlYWQ9 NA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIHNh bXBsZV90aW1lX2J5X2lkeCAgKGNvc3Q9MC4wMC4uNzI0MjYuMjkgcm93cz0zMTYyMzY0IHdpZHRo PTApIChhY3R1YWwgdA0KaW1lPTE4LjAxMS4uMTguMDExIHJvd3M9MCBsb29wcz0xKQ0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNoYW5uZWxfaWQgPSB0LmNo YW5uZWxfaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBCdWZmZXJzOiBzaGFy ZWQgcmVhZD00DQogICAgICAgICAgICAgICAgICAgICAtPiAgQml0bWFwIEhlYXAgU2NhbiBvbiBz YW1wbGVfY3RybF9tb250aCBjXzYgIChjb3N0PTEyNDQ2LjY3Li4yMjY4NDguMTkgcm93cz01Mzc1 NjIgd2lkdGg9ODUpIChhY3R1YWwNCnRpbWU9MC4wMjkuLjAuMDI5IHJvd3M9MCBsb29wcz0xKQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVjaGVjayBDb25kOiAoY2hhbm5lbF9pZCA9IHQu Y2hhbm5lbF9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBy ZWFkPTQNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBCaXRtYXAgSW5kZXggU2NhbiBv biBzYW1wbGVfdGltZV9jbV9pZHggIChjb3N0PTAuMDAuLjEyMzEyLjI4IHJvd3M9NTM3NTYyIHdp ZHRoPTApIChhY3R1YWwgdGkNCm1lPTAuMDI2Li4wLjAyNiByb3dzPTAgbG9vcHM9MSkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChjaGFubmVsX2lkID0gdC5j aGFubmVsX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQnVmZmVyczogc2hh cmVkIHJlYWQ9NA0KICAgICAgICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4gb24g c2FtcGxlX2N0cmxfeWVhciBjXzcgIChjb3N0PTQ4NDg2LjUxLi45Nzg5NDUuODMgcm93cz0yMDk0 MTg2IHdpZHRoPTc2KSAoYWN0dWFsDQp0aW1lPTIzLjA4OC4uMjMuMDg4IHJvd3M9MCBsb29wcz0x KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVjaGVjayBDb25kOiAoY2hhbm5lbF9pZCA9 IHQuY2hhbm5lbF9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJl ZCByZWFkPTQNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBCaXRtYXAgSW5kZXggU2Nh biBvbiBzYW1wbGVfdGltZV9jeV9pZHggIChjb3N0PTAuMDAuLjQ3OTYyLjk2IHJvd3M9MjA5NDE4 NiB3aWR0aD0wKSAoYWN0dWFsIHQNCmltZT0yMy4wODYuLjIzLjA4NiByb3dzPTAgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChjaGFubmVsX2lk ID0gdC5jaGFubmVsX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQnVmZmVy czogc2hhcmVkIHJlYWQ9NA0KICAgICAgICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBIZWFwIFNj YW4gb24gc2FtcGxlX3V0aWxfbW9udGggY184ICAoY29zdD0yMjQ5LjEwLi4yNzcxMTUuNjMgcm93 cz05NzEwMSB3aWR0aD04MikgKGFjdHVhbCB0aQ0KbWU9Ny42MjMuLjcuNjIzIHJvd3M9MCBsb29w cz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVjaGVjayBDb25kOiAoY2hhbm5lbF9p ZCA9IHQuY2hhbm5lbF9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1ZmZlcnM6IHNo YXJlZCBoaXQ9MSByZWFkPTMNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBCaXRtYXAg SW5kZXggU2NhbiBvbiBzYW1wbGVfdGltZV91bV9pZHggIChjb3N0PTAuMDAuLjIyMjQuODIgcm93 cz05NzEwMSB3aWR0aD0wKSAoYWN0dWFsIHRpbWUNCj03LjYxOS4uNy42MTkgcm93cz0wIGxvb3Bz PTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoY2hhbm5l bF9pZCA9IHQuY2hhbm5lbF9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEJ1 ZmZlcnM6IHNoYXJlZCBoaXQ9MSByZWFkPTMNCiAgICAgICAgICAgICAgICAgICAgIC0+ICBCaXRt YXAgSGVhcCBTY2FuIG9uIHNhbXBsZV91dGlsX3llYXIgY185ICAoY29zdD0zNzI3Ljk2Li40MTg5 MTMuNDUgcm93cz0xNjA5NTQgd2lkdGg9ODMpIChhY3R1YWwgdGkNCm1lPTEwLjgxNS4uMTAuODE1 IHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVjaGVjayBDb25k OiAoY2hhbm5lbF9pZCA9IHQuY2hhbm5lbF9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAg IEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MSByZWFkPTMNCiAgICAgICAgICAgICAgICAgICAgICAgICAg IC0+ICBCaXRtYXAgSW5kZXggU2NhbiBvbiBzYW1wbGVfdGltZV91eV9pZHggIChjb3N0PTAuMDAu LjM2ODcuNzIgcm93cz0xNjA5NTQgd2lkdGg9MCkgKGFjdHVhbCB0aW0NCmU9MTAuODExLi4xMC44 MTEgcm93cz0wIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRl eCBDb25kOiAoY2hhbm5lbF9pZCA9IHQuY2hhbm5lbF9pZCkNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MSByZWFkPTMNCiBQbGFubmluZyB0aW1l OiAxNS42NTYgbXMNCiBFeGVjdXRpb24gdGltZTogMTIwLjA2MiBtcw0KKDczIHJvd3MpDQoNCmNz c19hcmNoaXZlXzNfMF8wPSMNCg==