Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CCB7B6348C8 for ; Tue, 3 Mar 2009 13:52:42 -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 65361-07 for ; Tue, 3 Mar 2009 13:52:32 -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.241]) by mail.postgresql.org (Postfix) with ESMTP id 26F60634F5A for ; Tue, 3 Mar 2009 13:52:30 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c3so1615870ana.28 for ; Tue, 03 Mar 2009 09:52:28 -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=i/46pwIJ8RO4lH5jQMNpKfN3kLKDE0vhiRXUKe3c3Qw=; b=Heai66fm+aS73dpWFZ2dGWWj3wKHUiDJ+z65DLuVM3FB8Tk96xfqXqp47geIdoyYvg H3acE1Py578CBJ7I6pW+Q8RQbxBh4zYhvMO7KRzQXkLwMMTPQnDfDyylR5Ub/oo2yMDQ 5sv7guIkIQ4myjQ5hpje63e99t3JMdedRjMiI= 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=Pl1nUnXBx57IJ2d8f7VJUngVgR6cV5x9gT3x2ZLQr/mEgbBP3KFXCV/6U2tVJ583A3 yr1NzU04vf2ZpvFoRTNv4w1yKGZ1WLJwi55j7YCfIJGEnDCqf9vjMQLzK5zJnf8TAAhc N6awVjlmzLgg7NC+WAu0RAVhQgEHran+rRrbM= MIME-Version: 1.0 Received: by 10.100.125.14 with SMTP id x14mr2006956anc.104.1236102747665; Tue, 03 Mar 2009 09:52:27 -0800 (PST) In-Reply-To: References: <2870.1236050632@sss.pgh.pa.us> Date: Tue, 3 Mar 2009 12:52:27 -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=0016e645b9b42e360804643a99be 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/32 X-Sequence-Number: 32954 --0016e645b9b42e360804643a99be Content-Type: multipart/alternative; boundary=0016e645b9b42e360404643a99bc --0016e645b9b42e360404643a99bc Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Tue, Mar 3, 2009 at 12:38 PM, wrote: > if you haven't done a vaccum analyse on either installation then postgres' > idea of what sort of data is in the database is unpredictable, and as a > result it's not surprising that the two systems guess differently about what > sort of plan is going to be most efficiant. > > try doing vaccum analyse on both databases and see what the results are. > > David Lang > These are the results with vacuum analyze: 8.2.12: 624.366 ms 8.3.3: 1273.601 ms --0016e645b9b42e360404643a99bc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Tue, Mar 3, 2009 at 12:38 PM, <david@lang.hm> wrote:
if you haven't done a vaccum analyse on either installation then postgr= es' idea of what sort of data is in the database is unpredictable, and = as a result it's not surprising that the two systems guess differently = about what sort of plan is going to be most efficiant.

try doing vaccum analyse on both databases and see what the results are.
David Lang

These are the results with vacuum analyze:
8.2.12= : 624.366 ms
8.3.3: 1273.601 ms
--0016e645b9b42e360404643a99bc-- --0016e645b9b42e360804643a99be Content-Type: text/plain; charset=US-ASCII; name="analyze_8_2_12_va.txt" Content-Disposition: attachment; filename="analyze_8_2_12_va.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_fruvmkbu0 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD05ODMyLjkxLi45ODMyLjkyIHJv d3M9MiB3aWR0aD01MikgKGFjdHVhbCB0aW1lPTYyMy44MDguLjYyMy44MDggcm93cz0wIGxvb3Bz PTEpCiAgIC0+ICBTb3J0ICAoY29zdD05ODMyLjkxLi45ODMyLjkyIHJvd3M9MiB3aWR0aD01Mikg KGFjdHVhbCB0aW1lPTYyMy43OTkuLjYyMy43OTkgcm93cz0wIGxvb3BzPTEpCiAgICAgICAgIFNv cnQgS2V5OiB0OC5pZAogICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjk4MzIu OTAgcm93cz0yIHdpZHRoPTUyKSAoYWN0dWFsIHRpbWU9NjIzLjQ2Ny4uNjIzLjQ2NyByb3dzPTAg bG9vcHM9MSkKICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgodDIubm90X21vZGlmaWVkX3Np bmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01N L0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0My5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGlt ZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1Mn Ojp0ZXh0KSkgT1IgKHQ2Lm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDkt MDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAo dDcubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1 Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0OC5ub3RfbW9kaWZp ZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZ WVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ5Lm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0 b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpN STpTUyc6OnRleHQpKSBPUiAodDEwLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAo JzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQp KSBPUiAodDExLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRU MTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSkKICAgICAgICAg ICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi43MzgxLjQ5IHJvd3M9NTk4IHdpZHRo PTEwOCkgKGFjdHVhbCB0aW1lPTc1LjYzNC4uNTU2LjY0MiByb3dzPTExMDQgbG9vcHM9MSkKICAg ICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi41MDg3Ljc2IHJv d3M9NjAyIHdpZHRoPTU5KSAoYWN0dWFsIHRpbWU9NzEuNzQ0Li41MjMuNjkwIHJvd3M9MTEwNCBs b29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0 PTAuMDAuLjExNzEuNjYgcm93cz0xNjUgd2lkdGg9NTEpIChhY3R1YWwgdGltZT02Ni40MjcuLjQ5 OS43OTggcm93cz0zMzIgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg LT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi42ODQuNzcgcm93cz0xMTcgd2lkdGg9NTQpIChh Y3R1YWwgdGltZT0zOC4yNjYuLjQ0MC4wMjQgcm93cz0zMzYgbG9vcHM9MSkKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi44 NC4wOCByb3dzPTE4MiB3aWR0aD0zNSkgKGFjdHVhbCB0aW1lPTE2Ljc4NS4uNDAyLjA0NiByb3dz PTM3NiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjUyLjMzIHJvd3M9NCB3aWR0aD0yNykgKGFj dHVhbCB0aW1lPTExLjM1NS4uMTEuNTQ3IHJvd3M9NCBsb29wcz0xKQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBp ZHhfZGF5X3BhcnRfZHUgb24gZGF5X3BhcnQgdDEwICAoY29zdD0wLjAwLi44LjI4IHJvd3M9NyB3 aWR0aD0xOSkgKGFjdHVhbCB0aW1lPTAuNzEzLi4wLjc0OCByb3dzPTcgbG9vcHM9MSkKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXgg Q29uZDogKGRpc3BsYXlfdW5pdF9pZCA9IDI1MDg5Mzo6bnVtZXJpYykKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZl IDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9za2luX2RheV9wYXJ0X2lkIG9uIHNr aW4gdDIgIChjb3N0PTAuMDAuLjYuMjggcm93cz0xIHdpZHRoPTMwKSAoYWN0dWFsIHRpbWU9MS41 MjYuLjEuNTI5IHJvd3M9MSBsb29wcz03KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDIuZGF5X3BhcnRfaWQgPSB0 MTAuaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIEZpbHRlcjogKGFjdGl2ZSA8PiAwOjpudW1lcmljKQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfc2tpbl9z bG90X3NraW5faWQgb24gc2tpbl9zbG90IHQxMSAgKGNvc3Q9MC4wMC4uNi44MSByb3dzPTkwIHdp ZHRoPTMwKSAoYWN0dWFsIHRpbWU9MS4zNzAuLjk2LjkyNSByb3dzPTk0IGxvb3BzPTQpCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6 ICh0Mi5pZCA9IHQxMS5za2luX2lkKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMDo6bnVtZXJpYykKICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgbG9vcF9z bG90X3BrZXkgb24gbG9vcF9zbG90IHQzICAoY29zdD0wLjAwLi4zLjI5IHJvd3M9MSB3aWR0aD0x OSkgKGFjdHVhbCB0aW1lPTAuMDgzLi4wLjA4NyByb3dzPTEgbG9vcHM9Mzc2KQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDExLnNsb3Rf aWQgPSB0My5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg RmlsdGVyOiAoYWN0aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9zY2hlZHVsZV9vd25lcl9yZXNvdXJjZV9p ZCBvbiBzY2hlZHVsZSB0NyAgKGNvc3Q9MC4wMC4uNC4xNSByb3dzPTEgd2lkdGg9MzApIChhY3R1 YWwgdGltZT0wLjE1NC4uMC4xNjMgcm93cz0xIGxvb3BzPTMzNikKICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQzLmlkID0gdDcub3duZXJfcmVzb3Vy Y2VfaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKGFj dGl2ZSA8PiAwOjpudW1lcmljKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXgg U2NhbiB1c2luZyBpZHhfYnVuZGxlX3NjaGVkdWxlX2lkIG9uIGJ1bmRsZSB0NiAgKGNvc3Q9MC4w MC4uMjMuMzcgcm93cz0yOSB3aWR0aD0zMCkgKGFjdHVhbCB0aW1lPTAuMDI1Li4wLjA0MCByb3dz PTMgbG9vcHM9MzMyKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25k OiAodDYuc2NoZWR1bGVfaWQgPSB0Ny5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgRmlsdGVyOiAoYWN0aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAgICAgIC0+ ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9idW5kbGVfY29udGVudF9idW5kbGVfaWQgb24gYnVuZGxl X2NvbnRlbnQgdDggIChjb3N0PTAuMDAuLjMuODAgcm93cz0xIHdpZHRoPTYwKSAoYWN0dWFsIHRp bWU9MC4wMTEuLjAuMDE1IHJvd3M9MSBsb29wcz0xMTA0KQogICAgICAgICAgICAgICAgICAgICAg ICAgICBJbmRleCBDb25kOiAodDYuaWQgPSB0OC5idW5kbGVfaWQpCiAgICAgICAgICAgICAgIC0+ ICBJbmRleCBTY2FuIHVzaW5nIGNvbnRlbnRfcGtleSBvbiBjb250ZW50IHQ5ICAoY29zdD0wLjAw Li40LjA1IHJvd3M9MSB3aWR0aD0xOSkgKGFjdHVhbCB0aW1lPTAuMDEzLi4wLjAxNyByb3dzPTEg bG9vcHM9MTEwNCkKICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQ4LmNvbnRlbnRf aWQgPSB0OS5pZCkKIFRvdGFsIHJ1bnRpbWU6IDYyNC4zNjYgbXMKKDM0IHJvd3MpCgo= --0016e645b9b42e360804643a99be Content-Type: text/plain; charset=US-ASCII; name="analyze_8_3_3_va.txt" Content-Disposition: attachment; filename="analyze_8_3_3_va.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_fruvmnjd1 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD03Mzg0LjA1Li43Mzg0LjA2IHJv d3M9MSB3aWR0aD0zNykgKGFjdHVhbCB0aW1lPTEyNzMuMDYwLi4xMjczLjA2MCByb3dzPTAgbG9v cHM9MSkKICAgLT4gIFNvcnQgIChjb3N0PTczODQuMDUuLjczODQuMDYgcm93cz0xIHdpZHRoPTM3 KSAoYWN0dWFsIHRpbWU9MTI3My4wNTIuLjEyNzMuMDUyIHJvd3M9MCBsb29wcz0xKQogICAgICAg ICBTb3J0IEtleTogdDguaWQKICAgICAgICAgU29ydCBNZXRob2Q6ICBxdWlja3NvcnQgIE1lbW9y eTogMTdrQgogICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTMzMDMuNTMuLjczODQuMDQg cm93cz0xIHdpZHRoPTM3KSAoYWN0dWFsIHRpbWU9MTI3Mi45NzYuLjEyNzIuOTc2IHJvd3M9MCBs b29wcz0xKQogICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCh0Mi5ub3RfbW9kaWZpZWRfc2lu Y2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0v REQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQzLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1l c3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6 OnRleHQpKSBPUiAodDYubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0w Mi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0 Ny5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3 Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ4Lm5vdF9tb2RpZmll ZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZ WS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDkubm90X21vZGlmaWVkX3NpbmNlID49IHRv X3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1J OlNTJzo6dGV4dCkpIE9SICh0MTAubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgn MjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkp IE9SICh0MTEubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQx MToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpKQogICAgICAgICAg ICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0zMzAzLjUzLi41MjA4Ljc3IHJvd3M9NTE1IHdpZHRo PTkzKSAoYWN0dWFsIHRpbWU9ODYzLjQxNi4uMTIwOS4wMzggcm93cz0xMTA0IGxvb3BzPTEpCiAg ICAgICAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKHQ4LmJ1bmRsZV9pZCA9IHQ2LmlkKQogICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gYnVuZGxlX2NvbnRlbnQgdDggIChjb3N0 PTAuMDAuLjE2MzkuMDYgcm93cz02OTYwNiB3aWR0aD00NSkgKGFjdHVhbCB0aW1lPTAuMDc3Li4y NzIuMzkxIHJvd3M9Njk2MDYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2gg IChjb3N0PTMyOTcuMDYuLjMyOTcuMDYgcm93cz01MTggd2lkdGg9NTYpIChhY3R1YWwgdGltZT02 NTEuOTY4Li42NTEuOTY4IHJvd3M9MTEwNCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAg ICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0xMDQwLjMzLi4zMjk3LjA2IHJvd3M9NTE4IHdpZHRo PTU2KSAoYWN0dWFsIHRpbWU9MTI3LjI5MS4uNjQ2Ljg2NyByb3dzPTExMDQgbG9vcHM9MSkKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSGFzaCBDb25kOiAodDYuc2NoZWR1bGVfaWQg PSB0Ny5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9u IGJ1bmRsZSB0NiAgKGNvc3Q9MC4wMC4uMjAyMy41NSByb3dzPTYwNzk4IHdpZHRoPTI0KSAoYWN0 dWFsIHRpbWU9MC4wNTUuLjI3My4zNTEgcm93cz02MDkxOSBsb29wcz0xKQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMDo6bnVtZXJpYykK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggIChjb3N0PTEwMzguNTQu LjEwMzguNTQgcm93cz0xNDMgd2lkdGg9NDgpIChhY3R1YWwgdGltZT0xMjQuNzQ2Li4xMjQuNzQ2 IHJvd3M9MzMyIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9NzcuODkuLjEwMzguNTQgcm93cz0xNDMgd2lkdGg9NDgp IChhY3R1YWwgdGltZT00Ni4yNTMuLjEyMy4xNjQgcm93cz0zMzIgbG9vcHM9MSkKICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9 NzcuODkuLjU2My40NSByb3dzPTEwNSB3aWR0aD00OSkgKGFjdHVhbCB0aW1lPTQyLjQxNy4uMTA5 LjYzNSByb3dzPTMzNiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBIYXNoIENvbmQ6ICh0My5pZCA9IHQxMS5zbG90X2lkKQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4g b24gbG9vcF9zbG90IHQzICAoY29zdD0wLjAwLi4zODAuNTUgcm93cz05MjQxIHdpZHRoPTE2KSAo YWN0dWFsIHRpbWU9MC4wNDkuLjQyLjQ1NCByb3dzPTg5NTAgbG9vcHM9MSkKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0 aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD03NS45MC4uNzUuOTAgcm93cz0xNTkgd2lkdGg9 MzMpIChhY3R1YWwgdGltZT0zMi41MjYuLjMyLjUyNiByb3dzPTM3NiBsb29wcz0xKQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVz dGVkIExvb3AgIChjb3N0PTAuMDAuLjc1LjkwIHJvd3M9MTU5IHdpZHRoPTMzKSAoYWN0dWFsIHRp bWU9MjEuMTg3Li4zMC44MjAgcm93cz0zNzYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29w ICAoY29zdD0wLjAwLi40NS4xNyByb3dzPTQgd2lkdGg9MjQpIChhY3R1YWwgdGltZT0xNS42MzUu LjE1Ljg0NyByb3dzPTQgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcg aWR4X2RheV9wYXJ0X2R1IG9uIGRheV9wYXJ0IHQxMCAgKGNvc3Q9MC4wMC4uNy40MiByb3dzPTYg d2lkdGg9MTYpIChhY3R1YWwgdGltZT01LjM3OS4uNS40MTMgcm93cz03IGxvb3BzPTEpCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6IChkaXNwbGF5X3VuaXRfaWQgPSAyNTA4OTM6Om51bWVy aWMpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKGFjdGl2ZSA8PiAwOjpudW1lcmljKQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfc2tpbl9kYXlfcGFydF9pZCBvbiBza2lu IHQyICAoY29zdD0wLjAwLi42LjI4IHJvd3M9MSB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTEuNDc0 Li4xLjQ3NyByb3dzPTEgbG9vcHM9NykKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQy LmRheV9wYXJ0X2lkID0gdDEwLmlkKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6ICh0Mi5hY3Rp dmUgPD4gMDo6bnVtZXJpYykKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3NraW5fc2xv dF9za2luX2lkIG9uIHNraW5fc2xvdCB0MTEgIChjb3N0PTAuMDAuLjYuNTIgcm93cz05MyB3aWR0 aD0yNSkgKGFjdHVhbCB0aW1lPTEuNDE2Li4zLjAzNyByb3dzPTk0IGxvb3BzPTQpCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6ICh0MTEuc2tpbl9pZCA9IHQyLmlkKQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6 ICh0MTEuYWN0aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9zY2hlZHVsZV9vd25lcl9y ZXNvdXJjZV9pZCBvbiBzY2hlZHVsZSB0NyAgKGNvc3Q9MC4wMC4uNC41MSByb3dzPTEgd2lkdGg9 MjQpIChhY3R1YWwgdGltZT0wLjAyMi4uMC4wMjYgcm93cz0xIGxvb3BzPTMzNikKICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQ3 Lm93bmVyX3Jlc291cmNlX2lkID0gdDMuaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKHQ3LmFjdGl2ZSA8PiAwOjpudW1lcmljKQog ICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBjb250ZW50X3BrZXkgb24gY29udGVu dCB0OSAgKGNvc3Q9MC4wMC4uNC4xNyByb3dzPTEgd2lkdGg9MTYpIChhY3R1YWwgdGltZT0wLjAx MS4uMC4wMTUgcm93cz0xIGxvb3BzPTExMDQpCiAgICAgICAgICAgICAgICAgICAgIEluZGV4IENv bmQ6ICh0OS5pZCA9IHQ4LmNvbnRlbnRfaWQpCiBUb3RhbCBydW50aW1lOiAxMjczLjYwMSBtcwoo Mzggcm93cykKCg== --0016e645b9b42e360804643a99be--