Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A5E7A6362FE for ; Thu, 5 Mar 2009 14:16:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11312-01-8 for ; Thu, 5 Mar 2009 14:16:18 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by mail.postgresql.org (Postfix) with ESMTP id 47787636768 for ; Thu, 5 Mar 2009 13:02:04 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c3so13913ana.28 for ; Thu, 05 Mar 2009 09:02:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=rQRPlvCWeeume//u6GvSy6EkbuYVPiit+7zbQhM8dFA=; b=ukg2m6u0bwgg5roCXT4N+pgtnualupQ19X61osGpfE6M7MBb0XdACYBrazptmTHDO/ z4u4H/SMkl1f2vQMj5KcwxqgVH6vS9zE+Dj1BldvPBkQL8IP03TRpOz2vvbbEMFND8ht v3EGG2clalJ7m1Xla0E/V65NANYe+PEFZpypI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=fGLNmxcBfPu71Cubc4Cd4kuKve703GWLDrOqPNeDzVOC6wanQ1yRKx1tKRmKYsTo2Z Ek9ZYwVG8N9Z8C0UFvfspRbcvyc0bXBsXrITObSTSchLAcD7Mv9CzvYx8PDfmsBz203n TncxTLUkm4cHlsAQs8XVM0flFg6Rt0/+4UXCg= MIME-Version: 1.0 Received: by 10.100.13.6 with SMTP id 6mr1004526anm.9.1236269181865; Thu, 05 Mar 2009 08:06:21 -0800 (PST) In-Reply-To: References: <2870.1236050632@sss.pgh.pa.us> <17797.1236119652@sss.pgh.pa.us> Date: Thu, 5 Mar 2009 11:06:21 -0500 Message-ID: Subject: Re: Postgres 8.3, four times slower queries? From: Aaron Guyon To: pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary=0016e644ce1c6e8f310464615926 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/52 X-Sequence-Number: 32974 --0016e644ce1c6e8f310464615926 Content-Type: multipart/alternative; boundary=0016e644ce1c6e8f2b0464615924 --0016e644ce1c6e8f2b0464615924 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Matching query plans with numerics changed to integers. I sent the wrong query plans earlier 8.3.3: 1195 ms 8.2.12: 611 ms --0016e644ce1c6e8f2b0464615924 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Matching query plans with numerics changed to integers.

I sent the wrong query plans earlier

8.3.3: 1195 ms
8.2.12: 611 ms
--0016e644ce1c6e8f2b0464615924-- --0016e644ce1c6e8f310464615926 Content-Type: text/plain; charset=US-ASCII; name="query_plans.txt" Content-Disposition: attachment; filename="query_plans.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_frxmqfo51 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBVbmlxdWUgIChjb3N0PTY5ODYuMDEuLjY5ODYuMDIg cm93cz0xIHdpZHRoPTIwKSAoYWN0dWFsIHRpbWU9NjExLjA2MS4uNjExLjA2MSByb3dzPTAgbG9v cHM9MSkNCiAgIC0+ICBTb3J0ICAoY29zdD02OTg2LjAxLi42OTg2LjAyIHJvd3M9MSB3aWR0aD0y MCkgKGFjdHVhbCB0aW1lPTYxMS4wNTMuLjYxMS4wNTMgcm93cz0wIGxvb3BzPTEpDQogICAgICAg ICBTb3J0IEtleTogdDguaWQNCiAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9OTU1Ljkw Li42OTg2LjAwIHJvd3M9MSB3aWR0aD0yMCkgKGFjdHVhbCB0aW1lPTYxMC45NDIuLjYxMC45NDIg cm93cz0wIGxvb3BzPTEpDQogICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCh0Mi5ub3RfbW9k aWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwg J1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQzLm5vdF9tb2RpZmllZF9zaW5jZSA+ PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBI SDpNSTpTUyc6OnRleHQpKSBPUiAodDYubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFt cCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4 dCkpIE9SICh0Ny5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0 VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ4Lm5v dF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0 ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDkubm90X21vZGlmaWVkX3Np bmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01N L0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0MTAubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3Rp bWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNT Jzo6dGV4dCkpIE9SICh0MTEubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAw OS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpKQ0K ICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD05NTUuOTAuLjQ5ODkuMjcgcm93 cz01MjMgd2lkdGg9NzYpIChhY3R1YWwgdGltZT0yOC4yNzQuLjU0OC42NjQgcm93cz0xMTA0IGxv b3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD05NTUuOTAu LjMxOTUuNTYgcm93cz01MjYgd2lkdGg9NTIpIChhY3R1YWwgdGltZT0yOC4xMjMuLjUyMC42MjAg cm93cz0xMTA0IGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICBIYXNoIENvbmQ6 ICh0Ni5pbnZvaWNlX2lkID0gdDcuaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U2VxIFNjYW4gb24gcGF5bWVudCB0NiAgKGNvc3Q9MC4wMC4uMjAwMi42OSByb3dzPTYxNzg5IHdp ZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMjYuLjI1My4zNjAgcm93cz02MDkyMCBsb29wcz0xKQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDApDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9OTU0LjE1Li45NTQuMTUg cm93cz0xNDAgd2lkdGg9NDQpIChhY3R1YWwgdGltZT0yNS43OTUuLjI1Ljc5NSByb3dzPTMzMiBs b29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29w ICAoY29zdD0wLjAwLi45NTQuMTUgcm93cz0xNDAgd2lkdGg9NDQpIChhY3R1YWwgdGltZT0wLjU0 Ni4uMjQuMzY0IHJvd3M9MzMyIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjU2Mi42MiByb3dzPTEwMCB3 aWR0aD00MCkgKGFjdHVhbCB0aW1lPTAuNDcxLi4xNS43NTkgcm93cz0zMzYgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9v cCAgKGNvc3Q9MC4wMC4uNzQuNDAgcm93cz0xNTYgd2lkdGg9MjgpIChhY3R1YWwgdGltZT0wLjIz My4uNi40MDQgcm93cz0zNzYgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4wMC4uNDUuMDQg cm93cz00IHdpZHRoPTIwKSAoYWN0dWFsIHRpbWU9MC4xNTcuLjAuMzI0IHJvd3M9NCBsb29wcz0x KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X2RlcGFydG1lbnRfZHUgb24gZGVwYXJ0bWVudCB0 MTAgIChjb3N0PTAuMDAuLjcuMzAgcm93cz02IHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wNzYu LjAuMTA4IHJvd3M9NyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNvbXBhbnlfaWQgPSAy NTA4OTMpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMCkNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5n IGlkeF9wcm9qZWN0X2RlcGFydG1lbnRfaWQgb24gcHJvamVjdCB0MiAgKGNvc3Q9MC4wMC4uNi4y OCByb3dzPTEgd2lkdGg9MTYpIChhY3R1YWwgdGltZT0wLjAxNi4uMC4wMTggcm93cz0xIGxvb3Bz PTcpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBJbmRleCBDb25kOiAodDIuZGVwYXJ0bWVudF9pZCA9IHQxMC5pZCkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IEZpbHRlcjogKGFjdGl2ZSA8PiAwKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3Byb2plY3RfdHlwZV9w cm9qZWN0X2lkIG9uIHByb2plY3RfdHlwZSB0MTEgIChjb3N0PTAuMDAuLjYuMDkgcm93cz0xMDAg d2lkdGg9MTYpIChhY3R1YWwgdGltZT0wLjAzMC4uMC44MTcgcm93cz05NCBsb29wcz00KQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5k ZXggQ29uZDogKHQyLmlkID0gdDExLnByb2plY3RfaWQpDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMCkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBT Y2FuIHVzaW5nIHByb2plY3RfaW52b2ljZV9wa2V5IG9uIHByb2plY3RfaW52b2ljZSB0MyAgKGNv c3Q9MC4wMC4uMy4xMiByb3dzPTEgd2lkdGg9MTIpIChhY3R1YWwgdGltZT0wLjAwNy4uMC4wMTEg cm93cz0xIGxvb3BzPTM3NikNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0MTEuc2xvdF9pZCA9IHQzLmlkKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZl IDw+IDApDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXgg U2NhbiB1c2luZyBpZHhfaW52b2ljZV9vd25lcl9yZXNvdXJjZV9pZCBvbiBpbnZvaWNlIHQ3ICAo Y29zdD0wLjAwLi4zLjkwIHJvd3M9MSB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAx MSByb3dzPTEgbG9vcHM9MzM2KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgSW5kZXggQ29uZDogKHQzLmlkID0gdDcub3duZXJfcmVzb3VyY2VfaWQpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUg PD4gMCkNCiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9wYXlt ZW50X2Ftb3VudF9wYXltZW50X2lkIG9uIHBheW1lbnRfYW1vdW50IHQ4ICAoY29zdD0wLjAwLi4z LjQwIHJvd3M9MSB3aWR0aD0yOCkgKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAxMSByb3dzPTEgbG9v cHM9MTEwNCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0Ni5pZCA9 IHQ4LnBheW1lbnRfaWQpDQogICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBhbW91 bnRfcGtleSBvbiBhbW91bnQgdDkgIChjb3N0PTAuMDAuLjMuNzcgcm93cz0xIHdpZHRoPTEyKSAo YWN0dWFsIHRpbWU9MC4wMDcuLjAuMDExIHJvd3M9MSBsb29wcz0xMTA0KQ0KICAgICAgICAgICAg ICAgICAgICAgSW5kZXggQ29uZDogKHQ4LmFtb3VudF9pZCA9IHQ5LmlkKQ0KIFRvdGFsIHJ1bnRp bWU6IDYxMS42ODAgbXMNCigzNSByb3dzKQ0KDQoNCg0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFO ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiBVbmlxdWUgIChjb3N0PTY4OTEuODkuLjY4OTEuOTAgcm93cz0xIHdpZHRoPTIwKSAoYWN0dWFs IHRpbWU9MTE5NC44MTEuLjExOTQuODExIHJvd3M9MCBsb29wcz0xKQ0KICAgLT4gIFNvcnQgIChj b3N0PTY4OTEuODkuLjY4OTEuODkgcm93cz0xIHdpZHRoPTIwKSAoYWN0dWFsIHRpbWU9MTE5NC44 MDMuLjExOTQuODAzIHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAgU29ydCBLZXk6IHQ4LmlkDQog ICAgICAgICBTb3J0IE1ldGhvZDogIHF1aWNrc29ydCAgTWVtb3J5OiAxN2tCDQogICAgICAgICAt PiAgTmVzdGVkIExvb3AgIChjb3N0PTMxMDguNjMuLjY4OTEuODggcm93cz0xIHdpZHRoPTIwKSAo YWN0dWFsIHRpbWU9MTE5NC43MzMuLjExOTQuNzMzIHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAg ICAgICAgSm9pbiBGaWx0ZXI6ICgodDIubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFt cCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4 dCkpIE9SICh0My5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0 VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ2Lm5v dF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0 ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDcubm90X21vZGlmaWVkX3Np bmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01N L0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0OC5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGlt ZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1Mn Ojp0ZXh0KSkgT1IgKHQ5Lm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDkt MDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAo dDEwLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6 NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDExLm5vdF9tb2Rp ZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAn WVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSkNCiAgICAgICAgICAgICAgIC0+ICBIYXNoIEpv aW4gIChjb3N0PTMxMDguNjMuLjQ4MTYuNTcgcm93cz01NzEgd2lkdGg9NzYpIChhY3R1YWwgdGlt ZT03OTkuMTE0Li4xMTM1LjUyNCByb3dzPTExMDQgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAg ICAgIEhhc2ggQ29uZDogKHQ4LnBheW1lbnRfaWQgPSB0Ni5pZCkNCiAgICAgICAgICAgICAgICAg ICAgIC0+ICBTZXEgU2NhbiBvbiBwYXltZW50X2Ftb3VudCB0OCAgKGNvc3Q9MC4wMC4uMTQ0MS4x NyByb3dzPTY5NjE3IHdpZHRoPTI4KSAoYWN0dWFsIHRpbWU9MC4wNDIuLjI2My44MTUgcm93cz02 OTYxNyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggIChjb3N0PTMxMDEu NDQuLjMxMDEuNDQgcm93cz01NzUgd2lkdGg9NTIpIChhY3R1YWwgdGltZT01OTMuMjI3Li41OTMu MjI3IHJvd3M9MTEwNCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhh c2ggSm9pbiAgKGNvc3Q9OTc1LjYyLi4zMTAxLjQ0IHJvd3M9NTc1IHdpZHRoPTUyKSAoYWN0dWFs IHRpbWU9OTguNzM5Li41ODguMzg5IHJvd3M9MTEwNCBsb29wcz0xKQ0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgSGFzaCBDb25kOiAodDYuaW52b2ljZV9pZCA9IHQ3LmlkKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHBheW1lbnQgdDYg IChjb3N0PTAuMDAuLjE4OTEuNjkgcm93cz02MDkwMSB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAu MDM1Li4yNDkuOTkzIHJvd3M9NjA5MjAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIEZpbHRlcjogKGFjdGl2ZSA8PiAwKQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgLT4gIEhhc2ggIChjb3N0PTk3My42Ni4uOTczLjY2IHJvd3M9MTU3IHdp ZHRoPTQ0KSAoYWN0dWFsIHRpbWU9OTYuNDA0Li45Ni40MDQgcm93cz0zMzIgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNv c3Q9ODQuMjcuLjk3My42NiByb3dzPTE1NyB3aWR0aD00NCkgKGFjdHVhbCB0aW1lPTIzLjAyMC4u OTQuOTI0IHJvd3M9MzMyIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD04NC4yNy4uNTM5LjMyIHJvd3M9MTIw IHdpZHRoPTQwKSAoYWN0dWFsIHRpbWU9MjIuODgxLi44Ni4yMjUgcm93cz0zMzYgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEhhc2gg Q29uZDogKHQzLmlkID0gdDExLnNsb3RfaWQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gcHJvamVjdF9pbnZvaWNlIHQz ICAoY29zdD0wLjAwLi4zNjIuNTYgcm93cz05MTI5IHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4w NTIuLjM4LjUwMSByb3dzPTg5NTEgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKGFjdGl2ZSA8PiAwKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2gg IChjb3N0PTgxLjk3Li44MS45NyByb3dzPTE4NCB3aWR0aD0yOCkgKGFjdHVhbCB0aW1lPTEzLjM3 OS4uMTMuMzc5IHJvd3M9Mzc2IGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAu LjgxLjk3IHJvd3M9MTg0IHdpZHRoPTI4KSAoYWN0dWFsIHRpbWU9My4xODguLjExLjcxNiByb3dz PTM3NiBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi41MS45OCBy b3dzPTQgd2lkdGg9MjApIChhY3R1YWwgdGltZT0wLjMwOS4uMC40OTkgcm93cz00IGxvb3BzPTEp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfZGVwYXJ0bWVudF9kdSBvbiBk ZXBhcnRtZW50IHQxMCAgKGNvc3Q9MC4wMC4uNy45NiByb3dzPTcgd2lkdGg9MTIpIChhY3R1YWwg dGltZT0wLjE4MS4uMC4yMTUgcm93cz03IGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRl eCBDb25kOiAoY29tcGFueV9pZCA9IDI1MDg5MykNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjog KGFjdGl2ZSA8PiAwKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3Byb2pl Y3RfZGVwYXJ0bWVudF9pZCBvbiBwcm9qZWN0IHQyICAoY29zdD0wLjAwLi42LjI4IHJvd3M9MSB3 aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMDI0Li4wLjAyNyByb3dzPTEgbG9vcHM9NykNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0Mi5kZXBhcnRtZW50X2lkID0gdDEwLmlkKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgRmlsdGVyOiAodDIuYWN0aXZlIDw+IDApDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXgg U2NhbiB1c2luZyBpZHhfcHJvamVjdF90eXBlX3Byb2plY3RfaWQgb24gcHJvamVjdF90eXBlIHQx MSAgKGNvc3Q9MC4wMC4uNi4xNiByb3dzPTEwNyB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuNzI5 Li4yLjEwMCByb3dzPTk0IGxvb3BzPTQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDExLnBy b2plY3RfaWQgPSB0Mi5pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKHQxMS5hY3RpdmUgPD4gMCkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBT Y2FuIHVzaW5nIGlkeF9pbnZvaWNlX293bmVyX3Jlc291cmNlX2lkIG9uIGludm9pY2UgdDcgIChj b3N0PTAuMDAuLjMuNjEgcm93cz0xIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMDcuLjAuMDEx IHJvd3M9MSBsb29wcz0zMzYpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDcub3duZXJfcmVzb3VyY2VfaWQgPSB0My5pZCkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRl cjogKHQ3LmFjdGl2ZSA8PiAwKQ0KICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcg YW1vdW50X3BrZXkgb24gYW1vdW50IHQ5ICAoY29zdD0wLjAwLi4zLjU4IHJvd3M9MSB3aWR0aD0x MikgKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAxMSByb3dzPTEgbG9vcHM9MTEwNCkNCiAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0OS5pZCA9IHQ4LmFtb3VudF9pZCkNCiBUb3RhbCBy dW50aW1lOiAxMTk1LjYxNSBtcw0KKDM4IHJvd3MpDQoNCg0K --0016e644ce1c6e8f310464615926--