Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D032263617E for ; Mon, 2 Mar 2009 20:18:44 -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 43182-03 for ; Mon, 2 Mar 2009 20:18:38 -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.245]) by mail.postgresql.org (Postfix) with ESMTP id 97A586359D9 for ; Mon, 2 Mar 2009 20:18:32 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c3so1446703ana.28 for ; Mon, 02 Mar 2009 16:18:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=etEblEuecqalkF9kS5gQnpKzDzCtngroaMEPl6Pstuk=; b=jvjmxbjCWtVLoQcfX2IVnRU3VM4yjlsK49IU7PolXeCFMnZzDDbjRGKcy8MHfGPJ/q i5OpC4rJJOTP+MmctF2i3BQ0gqh7quB1lciC7vvcNRYOKD1L6Pz6MMA4x9fLkly6jNlx LhMlEF79YCUEXC10Hvu6M3wOYWS8FtQq+NojQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=axbyhn9Evi9XnRIqLqe+thnFGzqUEKXPTDO9AsHmlcvtkWHLtHYAaOnjuqng4Ouy4k uEJPp+Wms3e3juIjqWRqztKpxlFUVaxFHTcpqeb2JBZUz0XEyjhlrp2FfF/ETopuRK2k edX716HocMDM3wv8zoHCbRTykvQL2T71wixXk= MIME-Version: 1.0 Received: by 10.100.133.2 with SMTP id g2mr5299102and.134.1236039510707; Mon, 02 Mar 2009 16:18:30 -0800 (PST) Date: Mon, 2 Mar 2009 19:18:30 -0500 Message-ID: Subject: Postgres 8.3, four times slower queries? From: Aaron Guyon To: pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary=0016e644c2cef6cfa504642bdf8f 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/21 X-Sequence-Number: 32943 --0016e644c2cef6cfa504642bdf8f Content-Type: multipart/alternative; boundary=0016e644c2cef6cf9e04642bdf8d --0016e644c2cef6cf9e04642bdf8d Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi, We are currently running postgres 8.2 and are evaluating the upgrade to 8.3. Some of our tests are indicating that postgresql 8.3 is actually degrading the performance of some of our queries by a factor of 10 or more. The queries in question are selects that are heavy on joins (~10 tables) with a lot of timestamp-based conditions in where clauses. The tables and queries are tuned, that is, there is no issue with the table structure, or missing indexes. This is a side-by-side query performance measurement between 8.2 and 8.3 with an identical dataset and schema. 8.2.12 8.3.3 Time (ms) Time (ms) 1st 2nd 1st 2nd time time time time Query 1 759 130 3294 1758 attached you will find the explain analyze for this query. Any insight into this issue would be very appreciated. Thanks. --0016e644c2cef6cf9e04642bdf8d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

We are curr= ently running postgres 8.2 and are evaluating the upgrade to 8.3. Some of our tests are i= ndicating that postgresql 8.3 is actually degrading the
performance of some of our queries by a factor of 10 or more.= =A0 The queries in
question are selects th= at are heavy on joins (~10 tables) with a lot of
timestamp-based conditions in where clauses.=A0 The tables and queri= es are tuned,
that is, there is no is= sue with the table structure, or missing indexes.=A0 This
is a side-by-side query performance measurement between 8= .2 and 8.3 with an
identical dataset and s= chema.


=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 8.2.12= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 8.3.3
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 Time (ms)=A0=A0=A0=A0=A0=A0=A0 Time (ms)
=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 1st=A0=A0 2nd= =A0=A0=A0=A0=A0=A0=A0 1st=A0=A0 2nd
=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 time=A0 time=A0=A0=A0=A0=A0=A0 time=A0 time

Query 1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 759 =A0 130 =A0=A0=A0=A0=A0=A0 3294=A0 1758
attached you will find = the explain analyze for this query.=A0 Any insight into
this issue would be very appreciated.=A0 Thanks.





--0016e644c2cef6cf9e04642bdf8d-- --0016e644c2cef6cfa504642bdf8f Content-Type: text/plain; charset=US-ASCII; name="analyze_8_3_3.txt" Content-Disposition: attachment; filename="analyze_8_3_3.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_frttz44p0 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 LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD04MjUxLjQ3Li44MjUxLjQ4IHJv d3M9MSB3aWR0aD0zNykgKGFjdHVhbCB0aW1lPTMyOTQuMTA0Li4zMjk0LjEwNCByb3dzPTAgbG9v cHM9MSkKICAgLT4gIFNvcnQgIChjb3N0PTgyNTEuNDcuLjgyNTEuNDggcm93cz0xIHdpZHRoPTM3 KSAoYWN0dWFsIHRpbWU9MzI5NC4wOTYuLjMyOTQuMDk2IHJvd3M9MCBsb29wcz0xKQogICAgICAg ICBTb3J0IEtleTogdDguaWQKICAgICAgICAgU29ydCBNZXRob2Q6ICBxdWlja3NvcnQgIE1lbW9y eTogMTdrQgogICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD01NTA5Ljk0Li44MjUxLjQ2IHJv d3M9MSB3aWR0aD0zNykgKGFjdHVhbCB0aW1lPTMyOTQuMDMwLi4zMjk0LjAzMCByb3dzPTAgbG9v cHM9MSkKICAgICAgICAgICAgICAgSGFzaCBDb25kOiAodDkuaWQgPSB0OC5jb250ZW50X2lkKQog ICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCh0Mi5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9f dGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6 U1MnOjp0ZXh0KSkgT1IgKHQzLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIw MDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBP UiAodDYubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMTox OTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0Ny5ub3RfbW9k aWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwg J1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ4Lm5vdF9tb2RpZmllZF9zaW5jZSA+ PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBI SDpNSTpTUyc6OnRleHQpKSBPUiAodDkubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFt cCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4 dCkpIE9SICh0MTAubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0y NFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0MTEu bm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6 OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpKQogICAgICAgICAgICAgICAtPiAg U2VxIFNjYW4gb24gY29udGVudCB0OSAgKGNvc3Q9MC4wMC4uMjI3Mi4yNiByb3dzPTY4MDI2IHdp ZHRoPTE2KSAoYWN0dWFsIHRpbWU9My44OTEuLjM3Ny45NDUgcm93cz02ODA0NSBsb29wcz0xKQog ICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9NTQ5OC45MS4uNTQ5OC45MSByb3dzPTg4MiB3 aWR0aD05MykgKGFjdHVhbCB0aW1lPTI2MjUuNTAxLi4yNjI1LjUwMSByb3dzPTExMDQgbG9vcHM9 MSkKICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9MzU5MC4yNi4uNTQ5 OC45MSByb3dzPTg4MiB3aWR0aD05MykgKGFjdHVhbCB0aW1lPTIyNDEuODg2Li4yNjIwLjE0MSBy b3dzPTExMDQgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgSGFzaCBDb25kOiAo dDguYnVuZGxlX2lkID0gdDYuaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEg U2NhbiBvbiBidW5kbGVfY29udGVudCB0OCAgKGNvc3Q9MC4wMC4uMTYzOC44OSByb3dzPTY5NTg5 IHdpZHRoPTQ1KSAoYWN0dWFsIHRpbWU9NS4xNjAuLjMzNC4yNjMgcm93cz02OTYwNiBsb29wcz0x KQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9MzU3OS4xNy4uMzU3 OS4xNyByb3dzPTg4NyB3aWR0aD01NikgKGFjdHVhbCB0aW1lPTE5OTguNjgxLi4xOTk4LjY4MSBy b3dzPTExMDQgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhh c2ggSm9pbiAgKGNvc3Q9MTMxNy4zNi4uMzU3OS4xNyByb3dzPTg4NyB3aWR0aD01NikgKGFjdHVh bCB0aW1lPTEzNjcuMDYzLi4xOTkzLjU5MiByb3dzPTExMDQgbG9vcHM9MSkKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSGFzaCBDb25kOiAodDYuc2NoZWR1bGVfaWQgPSB0 Ny5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2Fu IG9uIGJ1bmRsZSB0NiAgKGNvc3Q9MC4wMC4uMjAyMy4zNCByb3dzPTYxMjI3IHdpZHRoPTI0KSAo YWN0dWFsIHRpbWU9My43ODUuLjM5MC41Nzggcm93cz02MDkxOSBsb29wcz0xKQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMDo6 bnVtZXJpYykKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2gg IChjb3N0PTEzMTQuNDEuLjEzMTQuNDEgcm93cz0yMzYgd2lkdGg9NDgpIChhY3R1YWwgdGltZT0x MzU1LjEyMS4uMTM1NS4xMjEgcm93cz0zMzIgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD00OTAuODYuLjEz MTQuNDEgcm93cz0yMzYgd2lkdGg9NDgpIChhY3R1YWwgdGltZT0yNTYuMDc3Li4xMzUzLjQ5NSBy b3dzPTMzMiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD00OTAuODYuLjYyOC4zOSByb3dzPTE4MSB3 aWR0aD00OSkgKGFjdHVhbCB0aW1lPTI0MC41OTYuLjEyNzQuNTgyIHJvd3M9MzM2IGxvb3BzPTEp CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IEhhc2ggQ29uZDogKHQxMS5zbG90X2lkID0gdDMuaWQpCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9 MC4wMC4uMTMxLjc2IHJvd3M9Mjg4IHdpZHRoPTMzKSAoYWN0dWFsIHRpbWU9OTIuMDA3Li4xMTQ5 Ljg4NiByb3dzPTM3NiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAu Ljc3Ljk1IHJvd3M9NyB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTQxLjIxNy4uNDEuNDI1IHJvd3M9 NCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfZGF5X3BhcnRf ZHUgb24gZGF5X3BhcnQgdDEwICAoY29zdD0wLjAwLi44LjczIHJvd3M9MTEgd2lkdGg9MTcpIChh Y3R1YWwgdGltZT0yMy44OTMuLjIzLjkyNiByb3dzPTcgbG9vcHM9MSkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgSW5kZXggQ29uZDogKGRpc3BsYXlfdW5pdF9pZCA9IDI1MDg5Mzo6bnVtZXJpYykKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9za2luX2RheV9wYXJ0X2lkIG9uIHNraW4gdDIgIChjb3N0 PTAuMDAuLjYuMjggcm93cz0xIHdpZHRoPTI0KSAoYWN0dWFsIHRpbWU9Mi40ODQuLjIuNDg2IHJv d3M9MSBsb29wcz03KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDIuZGF5X3BhcnRf aWQgPSB0MTAuaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKHQyLmFjdGl2ZSA8PiAwOjpu dW1lcmljKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfc2tpbl9zbG90X3NraW5faWQg b24gc2tpbl9zbG90IHQxMSAgKGNvc3Q9MC4wMC4uNi41NCByb3dzPTkyIHdpZHRoPTI1KSAoYWN0 dWFsIHRpbWU9MTIuNzI2Li4yNzYuNDEyIHJvd3M9OTQgbG9vcHM9NCkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5k ZXggQ29uZDogKHQxMS5za2luX2lkID0gdDIuaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKHQxMS5h Y3RpdmUgPD4gMDo6bnVtZXJpYykKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggIChjb3N0PTM4MC40NS4uMzgwLjQ1IHJvd3M9 ODgzMyB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTEyMS40NTcuLjEyMS40NTcgcm93cz04OTUwIGxv b3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBsb29wX3Nsb3QgdDMgIChjb3N0PTAuMDAuLjM4 MC40NSByb3dzPTg4MzMgd2lkdGg9MTYpIChhY3R1YWwgdGltZT01Ljc0NC4uODQuMTExIHJvd3M9 ODk1MCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMDo6bnVtZXJpYykK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIElu ZGV4IFNjYW4gdXNpbmcgaWR4X3NjaGVkdWxlX293bmVyX3Jlc291cmNlX2lkIG9uIHNjaGVkdWxl IHQ3ICAoY29zdD0wLjAwLi4zLjc4IHJvd3M9MSB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTAuMjE2 Li4wLjIyMCByb3dzPTEgbG9vcHM9MzM2KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDcub3duZXJfcmVzb3VyY2Vf aWQgPSB0My5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgRmlsdGVyOiAodDcuYWN0aXZlIDw+IDA6Om51bWVyaWMpCiBUb3RhbCBydW50 aW1lOiAzMjk0LjcxMiBtcwooMzkgcm93cykKCg== --0016e644c2cef6cfa504642bdf8f Content-Type: text/plain; charset=US-ASCII; name="analyze_8_2_12.txt" Content-Disposition: attachment; filename="analyze_8_2_12.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_frttzcoz1 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 LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD0xMDY3NS41NS4uMTA2NzUuNTYg cm93cz0yIHdpZHRoPTUyKSAoYWN0dWFsIHRpbWU9NzU4LjI1OS4uNzU4LjI1OSByb3dzPTAgbG9v cHM9MSkKICAgLT4gIFNvcnQgIChjb3N0PTEwNjc1LjU1Li4xMDY3NS41NSByb3dzPTIgd2lkdGg9 NTIpIChhY3R1YWwgdGltZT03NTguMjUwLi43NTguMjUwIHJvd3M9MCBsb29wcz0xKQogICAgICAg ICBTb3J0IEtleTogdDguaWQKICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi4x MDY3NS41NCByb3dzPTIgd2lkdGg9NTIpIChhY3R1YWwgdGltZT03NTguMDU1Li43NTguMDU1IHJv d3M9MCBsb29wcz0xKQogICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCh0Mi5ub3RfbW9kaWZp ZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZ WVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQzLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0 b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpN STpTUyc6OnRleHQpKSBPUiAodDYubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgn MjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkp IE9SICh0Ny5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDEx OjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ4Lm5vdF9t b2RpZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0 LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDkubm90X21vZGlmaWVkX3NpbmNl ID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0RE IEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0MTAubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVz dGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6 dGV4dCkpIE9SICh0MTEubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0w Mi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpKQogICAg ICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjc5NjYuNDUgcm93cz02OTgg d2lkdGg9MTA4KSAoYWN0dWFsIHRpbWU9MTEzLjg0My4uNDU4LjQxNiByb3dzPTExMDQgbG9vcHM9 MSkKICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi41NDYz LjczIHJvd3M9NzAzIHdpZHRoPTU5KSAoYWN0dWFsIHRpbWU9OTIuNjk5Li4zOTguOTY4IHJvd3M9 MTEwNCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3Ag IChjb3N0PTAuMDAuLjEyODcuNTcgcm93cz0xODYgd2lkdGg9NTEpIChhY3R1YWwgdGltZT0zOS41 NzAuLjEyOC4xMzIgcm93cz0zMzIgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi43NTUuNzUgcm93cz0xMzUgd2lkdGg9 NTQpIChhY3R1YWwgdGltZT0zOS40NDguLjExOC45MDkgcm93cz0zMzYgbG9vcHM9MSkKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0w LjAwLi45OC44MyByb3dzPTIxMSB3aWR0aD0zNSkgKGFjdHVhbCB0aW1lPTE5LjA1MC4uMjcuNDAz IHJvd3M9Mzc2IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4wMC4uNTguNzUgcm93cz01IHdpZHRoPTI3 KSAoYWN0dWFsIHRpbWU9MTguODkyLi4xOS4wODEgcm93cz00IGxvb3BzPTEpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVz aW5nIGlkeF9kYXlfcGFydF9kdSBvbiBkYXlfcGFydCB0MTAgIChjb3N0PTAuMDAuLjguNDEgcm93 cz04IHdpZHRoPTIwKSAoYWN0dWFsIHRpbWU9MTguNzM5Li4xOC43NzUgcm93cz03IGxvb3BzPTEp CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IEluZGV4IENvbmQ6IChkaXNwbGF5X3VuaXRfaWQgPSAyNTA4OTM6Om51bWVyaWMpCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjog KGFjdGl2ZSA8PiAwOjpudW1lcmljKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfc2tpbl9kYXlfcGFydF9p ZCBvbiBza2luIHQyICAoY29zdD0wLjAwLi42LjI4IHJvd3M9MSB3aWR0aD0zMCkgKGFjdHVhbCB0 aW1lPTAuMDI4Li4wLjAzMSByb3dzPTEgbG9vcHM9NykKICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQyLmRheV9wYXJ0 X2lkID0gdDEwLmlkKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMDo6bnVtZXJpYykKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4 X3NraW5fc2xvdF9za2luX2lkIG9uIHNraW5fc2xvdCB0MTEgIChjb3N0PTAuMDAuLjYuODUgcm93 cz05MyB3aWR0aD0zMCkgKGFjdHVhbCB0aW1lPTAuMDUzLi4xLjM4MiByb3dzPTk0IGxvb3BzPTQp CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6ICh0Mi5pZCA9IHQxMS5za2luX2lkKQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4gMDo6bnVtZXJpYykKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcg bG9vcF9zbG90X3BrZXkgb24gbG9vcF9zbG90IHQzICAoY29zdD0wLjAwLi4zLjEwIHJvd3M9MSB3 aWR0aD0xOSkgKGFjdHVhbCB0aW1lPTAuMjI2Li4wLjIyOSByb3dzPTEgbG9vcHM9Mzc2KQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDEx LnNsb3RfaWQgPSB0My5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9zY2hlZHVsZV9vd25lcl9yZXNv dXJjZV9pZCBvbiBzY2hlZHVsZSB0NyAgKGNvc3Q9MC4wMC4uMy45MyByb3dzPTEgd2lkdGg9MzAp IChhY3R1YWwgdGltZT0wLjAwOS4uMC4wMTMgcm93cz0xIGxvb3BzPTMzNikKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQzLmlkID0gdDcub3duZXJf cmVzb3VyY2VfaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRl cjogKGFjdGl2ZSA8PiAwOjpudW1lcmljKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg SW5kZXggU2NhbiB1c2luZyBpZHhfYnVuZGxlX3NjaGVkdWxlX2lkIG9uIGJ1bmRsZSB0NiAgKGNv c3Q9MC4wMC4uMjIuMDkgcm93cz0yOSB3aWR0aD0zMCkgKGFjdHVhbCB0aW1lPTAuNjk0Li4wLjc4 NCByb3dzPTMgbG9vcHM9MzMyKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRl eCBDb25kOiAodDYuc2NoZWR1bGVfaWQgPSB0Ny5pZCkKICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDA6Om51bWVyaWMpCiAgICAgICAgICAgICAgICAg ICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9idW5kbGVfY29udGVudF9idW5kbGVfaWQgb24g YnVuZGxlX2NvbnRlbnQgdDggIChjb3N0PTAuMDAuLjMuNTUgcm93cz0xIHdpZHRoPTYwKSAoYWN0 dWFsIHRpbWU9MC4wMzQuLjAuMDM5IHJvd3M9MSBsb29wcz0xMTA0KQogICAgICAgICAgICAgICAg ICAgICAgICAgICBJbmRleCBDb25kOiAodDYuaWQgPSB0OC5idW5kbGVfaWQpCiAgICAgICAgICAg ICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGNvbnRlbnRfcGtleSBvbiBjb250ZW50IHQ5ICAoY29z dD0wLjAwLi4zLjgzIHJvd3M9MSB3aWR0aD0xOSkgKGFjdHVhbCB0aW1lPTAuMjI3Li4wLjIzMSBy b3dzPTEgbG9vcHM9MTEwNCkKICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHQ4LmNv bnRlbnRfaWQgPSB0OS5pZCkKIFRvdGFsIHJ1bnRpbWU6IDc1OS4wMDEgbXMKKDM0IHJvd3MpCgo= --0016e644c2cef6cfa504642bdf8f--