Received: from epimetheus.hosting4u.net (epimetheus.hosting4u.net [209.15.2.70]) by postgresql.org (Postfix) with SMTP id B7150475FA7 for ; Tue, 19 Mar 2002 13:51:38 -0500 (EST) Received: (qmail 2112 invoked from network); 19 Mar 2002 18:51:38 -0000 Received: from hades.hosting4u.net (HELO tradebotsystems.com) (209.15.2.61) by mail-gate.hosting4u.net with SMTP; 19 Mar 2002 18:51:38 -0000 Received: from krbdev ([65.68.40.177]) by tradebotsystems.com ; Tue, 19 Mar 2002 12:51:36 -0600 Content-Type: Multipart/Mixed; charset="iso-8859-1"; boundary="------------Boundary-00=_YPH8IJ0XJ0SQN0U0D2LD" From: Kelly Burkhart Organization: Tradebot Systems, Inc. To: Tom Lane Subject: Re: optimizer tuning/forcing correct index use Date: Tue, 19 Mar 2002 12:51:34 -0600 X-Mailer: KMail [version 1.2] Cc: pgsql-sql@postgresql.org References: <02031907224907.00735@krbdev> <02031911121009.00735@krbdev> <160.1016559143@sss.pgh.pa.us> In-Reply-To: <160.1016559143@sss.pgh.pa.us> MIME-Version: 1.0 Message-Id: <0203191226350A.00735@krbdev> Content-Transfer-Encoding: 8bit X-Rcpt-To: X-Archive-Number: 200203/239 X-Sequence-Number: 7118 --------------Boundary-00=_YPH8IJ0XJ0SQN0U0D2LD Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit On Tuesday 19 March 2002 11:32 am, Tom Lane wrote: > > Hmm. So the correlation of fill_ts with physical position is actually > negative, according to the analyze results. Still, -0.54 represents > rather strong correlation which would reduce the cost of the index scan. > > There was some discussion a couple weeks ago on the pgsql-bugs list about > changing the equation the planner uses to estimate the effects of > correlation order. Are you interested in experimenting? I previously > > said: > : If you look in cost_index (see approx. lines 270-340 in > : src/backend/optimizer/path/costsize.c) you'll see that it computes > : access cost estimates for both the perfectly sequential case and > : the perfectly uncorrelated case, and then tries to interpolate > : between them. I have reasonable faith in both of the endpoint > : estimation methods, but very little in the interpolation equation --- > : it was chosen on the spur of the moment and hasn't really been tested. > : > : It might be interesting to replace csquared with just > : fabs(indexCorrelation) to see if the results are better. in costsize.c:334 I've changed: csquared = indexCorrelation * indexCorrelation; to: csquared = fabs(indexCorrelation); It looks like the estimated cost of the fill index scan is lower, but not enough to change the plan. I'll be happy to run more tests if you can think of other things to try. -K --------------Boundary-00=_YPH8IJ0XJ0SQN0U0D2LD Content-Type: text/plain; charset="iso-8859-1"; name="test_results.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="test_results.txt" ZXhwbGFpbiBhbmFseXplCnNlbGVjdAogICB0LnRiX29yZGVyX251bWJlciwg Zi5hY2NvdW50X251bWJlciwgZi5jbGVhcmluZ19hY2NvdW50X2lkLAogICBm LnN5bWJvbF9mdWxsX25hbWUsIGYuZmlsbF9xdWFudGl0eSwgZi5idXlfb3Jf c2VsbCwKICAgZi50cmFkZXJfdXNlcm5hbWUsIGYuZmlsbF9wcmljZSwgZi5m aWxsX3F1YW50aXR5LCBmLmZpbGxfdHMsCiAgIGYubGFzdF91cGRhdGVfdHMs IHMuc3ltYm9sX3R5cGUsIHMuYmFzZV9zeW1ib2xfZnVsbF9uYW1lLAogICBz LnN5bWJvbF9uYW1lLCBjYS5jbGVhcmluZ19hY2NvdW50X251bWJlciwgY2Eu Y2xlYXJpbmdfZmlybSwKICAgY28udGlja192YWx1ZQpmcm9tCiAgIGZpbGwg ZiwKICAgdGJfb3JkZXIgdCwKICAgc3ltYm9sIHMsCiAgIGNsZWFyaW5nX2Fj Y291bnQgY2EsCiAgIGNvbnRyYWN0IGNvCndoZXJlCiAgIGYuZmlsbF90cyA+ ICcyMDAyLTAyLTA0IDAwOjAwOjAwJyBhbmQKICAgZi5maWxsX3RzIDw9ICcy MDAyLTAyLTA2IDIzOjU5OjU5JyBhbmQKICAgdC5vcmRlcl9pZCA9IGYub3Jk ZXJfaWQgYW5kCiAgIHMuZnVsbF9uYW1lID0gZi5zeW1ib2xfZnVsbF9uYW1l IGFuZAogICBjby5jb250cmFjdF9uYW1lID0gcy5jb250cmFjdF9uYW1lIGFu ZAogICBjYS5jbGVhcmluZ19hY2NvdW50X2lkID0gZi5jbGVhcmluZ19hY2Nv dW50X2lkIGFuZAogICBzLnN5bWJvbF9uYW1lIG5vdCBpbiAoJ0lTTEQ6VEVT VEEnLCAnSVNMRDpURVNUQicsICdJU0xEOlRFU1RDJyk7CgotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQp1c2luZyBjc3F1YXJlZCA9IGZhYnMo aW5kZXhDb3JyZWxhdGlvbik7CiAgIGYuZmlsbF90cyA+ICcyMDAyLTAyLTA0 IDAwOjAwOjAwJyBhbmQKICAgZi5maWxsX3RzIDw9ICcyMDAyLTAyLTA0IDIz OjU5OjU5JyBhbmQKCkhhc2ggSm9pbiAgKGNvc3Q9MzUuOTguLjI1MDI2OS44 NSByb3dzPTI1ODMwIHdpZHRoPTE3MCkgKGFjdHVhbCB0aW1lPTI1MS4yNy4u NDU3OC43MyByb3dzPTQ4NjMzIGxvb3BzPTEpCiAgLT4gIE5lc3RlZCBMb29w ICAoY29zdD0zNC4yNi4uMjQ5ODE2LjExIHJvd3M9MjU4MzAgd2lkdGg9MTQ2 KSAoYWN0dWFsIHRpbWU9MjM1LjUyLi40MTkzLjExIHJvd3M9NDg2MzMgbG9v cHM9MSkKICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0zNC4yNi4uMTA3 MTU5LjU0IHJvd3M9MjU4MzAgd2lkdGg9MTI4KSAoYWN0dWFsIHRpbWU9MTQx LjkxLi4yMDM1LjQ1IHJvd3M9NDg2MzMgbG9vcHM9MSkKICAgICAgICAgICAg ICAtPiAgSW5kZXggU2NhbiB1c2luZyBmaWxsX2FrMiBvbiBmaWxsIGYgIChj b3N0PTAuMDAuLjEwNjYxOS44MSByb3dzPTM2NTE4IHdpZHRoPTY2KSAoYWN0 dWFsIHRpbWU9MTI1LjcwLi4xNjQ1LjEwIHJvd3M9NDg2MzMgbG9vcHM9MSkK ICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9MzIuODkuLjMyLjg5IHJv d3M9NTQ3IHdpZHRoPTYyKSAoYWN0dWFsIHRpbWU9MTYuMTYuLjE2LjE2IHJv d3M9MCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoIEpv aW4gIChjb3N0PTEuMTYuLjMyLjg5IHJvd3M9NTQ3IHdpZHRoPTYyKSAoYWN0 dWFsIHRpbWU9MTAuNzkuLjE1LjI2IHJvd3M9NTU5IGxvb3BzPTEpCiAgICAg ICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHN5bWJvbCBz ICAoY29zdD0wLjAwLi4yMC43OCByb3dzPTU0NyB3aWR0aD00OCkgKGFjdHVh bCB0aW1lPTAuMDcuLjIuNDAgcm93cz01NTkgbG9vcHM9MSkKICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9MS4xMy4uMS4xMyBy b3dzPTEzIHdpZHRoPTE0KSAoYWN0dWFsIHRpbWU9MTAuNjcuLjEwLjY3IHJv d3M9MCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IC0+ICBTZXEgU2NhbiBvbiBjb250cmFjdCBjbyAgKGNvc3Q9MC4wMC4uMS4x MyByb3dzPTEzIHdpZHRoPTE0KSAoYWN0dWFsIHRpbWU9MTAuNjIuLjEwLjY0 IHJvd3M9MTMgbG9vcHM9MSkKICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2lu ZyBvcmRlcl9wayBvbiB0Yl9vcmRlciB0ICAoY29zdD0wLjAwLi41LjUxIHJv d3M9MSB3aWR0aD0xOCkgKGFjdHVhbCB0aW1lPTAuMDMuLjAuMDQgcm93cz0x IGxvb3BzPTQ4NjMzKQogIC0+ICBIYXNoICAoY29zdD0xLjU3Li4xLjU3IHJv d3M9NTcgd2lkdGg9MjQpIChhY3R1YWwgdGltZT0xNS42OC4uMTUuNjggcm93 cz0wIGxvb3BzPTEpCiAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGNsZWFyaW5n X2FjY291bnQgY2EgIChjb3N0PTAuMDAuLjEuNTcgcm93cz01NyB3aWR0aD0y NCkgKGFjdHVhbCB0aW1lPTE1LjUyLi4xNS42MSByb3dzPTU3IGxvb3BzPTEp ClRvdGFsIHJ1bnRpbWU6IDQ1OTkuNzUgbXNlYwoKLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0KdXNpbmcgY3NxdWFyZWQgPSBmYWJzKGluZGV4 Q29ycmVsYXRpb24pOwogICBmLmZpbGxfdHMgPiAnMjAwMi0wMi0wNCAwMDow MDowMCcgYW5kCiAgIGYuZmlsbF90cyA8PSAnMjAwMi0wMi0wNSAyMzo1OTo1 OScgYW5kCgpIYXNoIEpvaW4gIChjb3N0PTM1Ljk4Li40OTU1NjQuNzYgcm93 cz01MTE1MiB3aWR0aD0xNzApIChhY3R1YWwgdGltZT02LjQxLi42NDE4LjMy IHJvd3M9MTEzMDI2IGxvb3BzPTEpCiAgLT4gIE5lc3RlZCBMb29wICAoY29z dD0zNC4yNi4uNDk0NjY3Ljg5IHJvd3M9NTExNTIgd2lkdGg9MTQ2KSAoYWN0 dWFsIHRpbWU9Ni4xMy4uNTU1NS4yMSByb3dzPTExMzAyNiBsb29wcz0xKQog ICAgICAgIC0+ICBIYXNoIEpvaW4gIChjb3N0PTM0LjI2Li4yMTIxNjUuNjYg cm93cz01MTE1MiB3aWR0aD0xMjgpIChhY3R1YWwgdGltZT01Ljk5Li4yNDM1 LjAwIHJvd3M9MTEzMDI2IGxvb3BzPTEpCiAgICAgICAgICAgICAgLT4gIElu ZGV4IFNjYW4gdXNpbmcgZmlsbF9hazIgb24gZmlsbCBmICAoY29zdD0wLjAw Li4yMTExMzAuNDIgcm93cz03MjMxNiB3aWR0aD02NikgKGFjdHVhbCB0aW1l PTAuMjcuLjE1NTkuNzkgcm93cz0xMTMwMjYgbG9vcHM9MSkKICAgICAgICAg ICAgICAtPiAgSGFzaCAgKGNvc3Q9MzIuODkuLjMyLjg5IHJvd3M9NTQ3IHdp ZHRoPTYyKSAoYWN0dWFsIHRpbWU9NS42Ny4uNS42NyByb3dzPTAgbG9vcHM9 MSkKICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0x LjE2Li4zMi44OSByb3dzPTU0NyB3aWR0aD02MikgKGFjdHVhbCB0aW1lPTAu MjEuLjQuNzIgcm93cz01NTkgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgU2VxIFNjYW4gb24gc3ltYm9sIHMgIChjb3N0PTAuMDAu LjIwLjc4IHJvd3M9NTQ3IHdpZHRoPTQ4KSAoYWN0dWFsIHRpbWU9MC4wNS4u Mi4zNyByb3dzPTU1OSBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAg ICAgIC0+ICBIYXNoICAoY29zdD0xLjEzLi4xLjEzIHJvd3M9MTMgd2lkdGg9 MTQpIChhY3R1YWwgdGltZT0wLjEwLi4wLjEwIHJvd3M9MCBsb29wcz0xKQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBv biBjb250cmFjdCBjbyAgKGNvc3Q9MC4wMC4uMS4xMyByb3dzPTEzIHdpZHRo PTE0KSAoYWN0dWFsIHRpbWU9MC4wNS4uMC4wNyByb3dzPTEzIGxvb3BzPTEp CiAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgb3JkZXJfcGsgb24gdGJf b3JkZXIgdCAgKGNvc3Q9MC4wMC4uNS41MSByb3dzPTEgd2lkdGg9MTgpIChh Y3R1YWwgdGltZT0wLjAyLi4wLjAyIHJvd3M9MSBsb29wcz0xMTMwMjYpCiAg LT4gIEhhc2ggIChjb3N0PTEuNTcuLjEuNTcgcm93cz01NyB3aWR0aD0yNCkg KGFjdHVhbCB0aW1lPTAuMjMuLjAuMjMgcm93cz0wIGxvb3BzPTEpCiAgICAg ICAgLT4gIFNlcSBTY2FuIG9uIGNsZWFyaW5nX2FjY291bnQgY2EgIChjb3N0 PTAuMDAuLjEuNTcgcm93cz01NyB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTAu MDcuLjAuMTYgcm93cz01NyBsb29wcz0xKQpUb3RhbCBydW50aW1lOiA2NDY1 LjE4IG1zZWMKCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCnVz aW5nIGNzcXVhcmVkID0gZmFicyhpbmRleENvcnJlbGF0aW9uKTsKICAgZi5m aWxsX3RzID4gJzIwMDItMDItMDQgMDA6MDA6MDAnIGFuZAogICBmLmZpbGxf dHMgPD0gJzIwMDItMDItMDYgMjM6NTk6NTknIGFuZAoKTmVzdGVkIExvb3Ag IChjb3N0PTM1Ljk4Li43Mzk3NDIuNjYgcm93cz03NjQ3MyB3aWR0aD0xNzAp IChhY3R1YWwgdGltZT00OTExOC41Ni4uMTMwODkwLjA3IHJvd3M9MTkxNDgz IGxvb3BzPTEpCiAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9MzUuOTguLjMxNzM5 NC43NyByb3dzPTc2NDczIHdpZHRoPTE1MikgKGFjdHVhbCB0aW1lPTQ5MDY3 LjgwLi4xMjU2NjMuMjYgcm93cz0xOTE0ODMgbG9vcHM9MSkKICAgICAgICAt PiAgSGFzaCBKb2luICAoY29zdD0zNC4yNi4uMzE2MDU0Ljc5IHJvd3M9NzY0 NzMgd2lkdGg9MTI4KSAoYWN0dWFsIHRpbWU9NDkwNjcuNTEuLjEyNDAwMi42 NCByb3dzPTE5MTQ4MyBsb29wcz0xKQogICAgICAgICAgICAgIC0+ICBTZXEg U2NhbiBvbiBmaWxsIGYgIChjb3N0PTAuMDAuLjMxNDUyNC4wNCByb3dzPTEw ODExNSB3aWR0aD02NikgKGFjdHVhbCB0aW1lPTQ5MDYxLjg4Li4xMjI1NTYu MDMgcm93cz0xOTE0ODMgbG9vcHM9MSkKICAgICAgICAgICAgICAtPiAgSGFz aCAgKGNvc3Q9MzIuODkuLjMyLjg5IHJvd3M9NTQ3IHdpZHRoPTYyKSAoYWN0 dWFsIHRpbWU9NS41Ny4uNS41NyByb3dzPTAgbG9vcHM9MSkKICAgICAgICAg ICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0xLjE2Li4zMi44OSBy b3dzPTU0NyB3aWR0aD02MikgKGFjdHVhbCB0aW1lPTAuMTkuLjQuNjcgcm93 cz01NTkgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U2VxIFNjYW4gb24gc3ltYm9sIHMgIChjb3N0PTAuMDAuLjIwLjc4IHJvd3M9 NTQ3IHdpZHRoPTQ4KSAoYWN0dWFsIHRpbWU9MC4wNS4uMi4zNyByb3dzPTU1 OSBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNo ICAoY29zdD0xLjEzLi4xLjEzIHJvd3M9MTMgd2lkdGg9MTQpIChhY3R1YWwg dGltZT0wLjA5Li4wLjA5IHJvd3M9MCBsb29wcz0xKQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBjb250cmFjdCBj byAgKGNvc3Q9MC4wMC4uMS4xMyByb3dzPTEzIHdpZHRoPTE0KSAoYWN0dWFs IHRpbWU9MC4wNC4uMC4wNiByb3dzPTEzIGxvb3BzPTEpCiAgICAgICAgLT4g IEhhc2ggIChjb3N0PTEuNTcuLjEuNTcgcm93cz01NyB3aWR0aD0yNCkgKGFj dHVhbCB0aW1lPTAuMjMuLjAuMjMgcm93cz0wIGxvb3BzPTEpCiAgICAgICAg ICAgICAgLT4gIFNlcSBTY2FuIG9uIGNsZWFyaW5nX2FjY291bnQgY2EgIChj b3N0PTAuMDAuLjEuNTcgcm93cz01NyB3aWR0aD0yNCkgKGFjdHVhbCB0aW1l PTAuMDYuLjAuMTUgcm93cz01NyBsb29wcz0xKQogIC0+ICBJbmRleCBTY2Fu IHVzaW5nIG9yZGVyX3BrIG9uIHRiX29yZGVyIHQgIChjb3N0PTAuMDAuLjUu NTEgcm93cz0xIHdpZHRoPTE4KSAoYWN0dWFsIHRpbWU9MC4wMi4uMC4wMiBy b3dzPTEgbG9vcHM9MTkxNDgzKQpUb3RhbCBydW50aW1lOiAxMzA5NzMuODIg bXNlYwotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQotLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQpjc3F1YXJlZCA9IGluZGV4Q29ycmVsYXRpb24gKiBp bmRleENvcnJlbGF0aW9uOwogICBmLmZpbGxfdHMgPiAnMjAwMi0wMi0wNCAw MDowMDowMCcgYW5kCiAgIGYuZmlsbF90cyA8PSAnMjAwMi0wMi0wNCAyMzo1 OTo1OScgYW5kCgpOZXN0ZWQgTG9vcCAgKGNvc3Q9MzUuOTguLjI4OTc3My41 NCByb3dzPTI1ODMwIHdpZHRoPTE3MCkgKGFjdHVhbCB0aW1lPTE4NC4yNi4u MjQxOC4xNCByb3dzPTQ4NjMzIGxvb3BzPTEpCiAgLT4gIEhhc2ggSm9pbiAg KGNvc3Q9MzUuOTguLjEzNjMwMC4yNiByb3dzPTI1ODMwIHdpZHRoPTE1Mikg KGFjdHVhbCB0aW1lPTEzOS43OC4uMTM0MC40MiByb3dzPTQ4NjMzIGxvb3Bz PTEpCiAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9MzQuMjYuLjEzNTg0 Ni41MiByb3dzPTI1ODMwIHdpZHRoPTEyOCkgKGFjdHVhbCB0aW1lPTEyNC4w Ni4uOTAxLjYwIHJvd3M9NDg2MzMgbG9vcHM9MSkKICAgICAgICAgICAgICAt PiAgSW5kZXggU2NhbiB1c2luZyBmaWxsX2FrMiBvbiBmaWxsIGYgIChjb3N0 PTAuMDAuLjEzNTMwNi43OSByb3dzPTM2NTE4IHdpZHRoPTY2KSAoYWN0dWFs IHRpbWU9MTA3Ljg2Li41MDkuNTIgcm93cz00ODYzMyBsb29wcz0xKQogICAg ICAgICAgICAgIC0+ICBIYXNoICAoY29zdD0zMi44OS4uMzIuODkgcm93cz01 NDcgd2lkdGg9NjIpIChhY3R1YWwgdGltZT0xNi4xMy4uMTYuMTMgcm93cz0w IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggSm9pbiAg KGNvc3Q9MS4xNi4uMzIuODkgcm93cz01NDcgd2lkdGg9NjIpIChhY3R1YWwg dGltZT0xMC43OS4uMTUuMjMgcm93cz01NTkgbG9vcHM9MSkKICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gc3ltYm9sIHMgIChj b3N0PTAuMDAuLjIwLjc4IHJvd3M9NTQ3IHdpZHRoPTQ4KSAoYWN0dWFsIHRp bWU9MC4wNy4uMi40MCByb3dzPTU1OSBsb29wcz0xKQogICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD0xLjEzLi4xLjEzIHJvd3M9 MTMgd2lkdGg9MTQpIChhY3R1YWwgdGltZT0xMC42Ny4uMTAuNjcgcm93cz0w IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IFNlcSBTY2FuIG9uIGNvbnRyYWN0IGNvICAoY29zdD0wLjAwLi4xLjEzIHJv d3M9MTMgd2lkdGg9MTQpIChhY3R1YWwgdGltZT0xMC42My4uMTAuNjQgcm93 cz0xMyBsb29wcz0xKQogICAgICAgIC0+ICBIYXNoICAoY29zdD0xLjU3Li4x LjU3IHJvd3M9NTcgd2lkdGg9MjQpIChhY3R1YWwgdGltZT0xNS42Ny4uMTUu Njcgcm93cz0wIGxvb3BzPTEpCiAgICAgICAgICAgICAgLT4gIFNlcSBTY2Fu IG9uIGNsZWFyaW5nX2FjY291bnQgY2EgIChjb3N0PTAuMDAuLjEuNTcgcm93 cz01NyB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTE1LjUwLi4xNS41OSByb3dz PTU3IGxvb3BzPTEpCiAgLT4gIEluZGV4IFNjYW4gdXNpbmcgb3JkZXJfcGsg b24gdGJfb3JkZXIgdCAgKGNvc3Q9MC4wMC4uNS45MyByb3dzPTEgd2lkdGg9 MTgpIChhY3R1YWwgdGltZT0wLjAxLi4wLjAxIHJvd3M9MSBsb29wcz00ODYz MykKVG90YWwgcnVudGltZTogMjQzOS42NCBtc2VjCgotLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQpjc3F1YXJlZCA9IGluZGV4Q29ycmVsYXRp b24gKiBpbmRleENvcnJlbGF0aW9uOwogICBmLmZpbGxfdHMgPiAnMjAwMi0w Mi0wNCAwMDowMDowMCcgYW5kCiAgIGYuZmlsbF90cyA8PSAnMjAwMi0wMi0w NSAyMzo1OTo1OScgYW5kCgpOZXN0ZWQgTG9vcCAgKGNvc3Q9MzUuOTguLjU3 Mzc5Mi4xNyByb3dzPTUxMTUyIHdpZHRoPTE3MCkgKGFjdHVhbCB0aW1lPTYu MjMuLjY5MTkuMjkgcm93cz0xMTMwMjYgbG9vcHM9MSkKICAtPiAgSGFzaCBK b2luICAoY29zdD0zNS45OC4uMjY5ODY5LjY1IHJvd3M9NTExNTIgd2lkdGg9 MTUyKSAoYWN0dWFsIHRpbWU9Ni4wOS4uMzcxMi4yNyByb3dzPTExMzAyNiBs b29wcz0xKQogICAgICAgIC0+ICBIYXNoIEpvaW4gIChjb3N0PTM0LjI2Li4y Njg5NzIuNzkgcm93cz01MTE1MiB3aWR0aD0xMjgpIChhY3R1YWwgdGltZT01 LjgxLi4yNzI3Ljk4IHJvd3M9MTEzMDI2IGxvb3BzPTEpCiAgICAgICAgICAg ICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgZmlsbF9hazIgb24gZmlsbCBmICAo Y29zdD0wLjAwLi4yNjc5MzcuNTUgcm93cz03MjMxNiB3aWR0aD02NikgKGFj dHVhbCB0aW1lPTAuMjcuLjE4NDguNjcgcm93cz0xMTMwMjYgbG9vcHM9MSkK ICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9MzIuODkuLjMyLjg5IHJv d3M9NTQ3IHdpZHRoPTYyKSAoYWN0dWFsIHRpbWU9NS40OS4uNS40OSByb3dz PTAgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCBKb2lu ICAoY29zdD0xLjE2Li4zMi44OSByb3dzPTU0NyB3aWR0aD02MikgKGFjdHVh bCB0aW1lPTAuMTkuLjQuNTkgcm93cz01NTkgbG9vcHM9MSkKICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gc3ltYm9sIHMgIChj b3N0PTAuMDAuLjIwLjc4IHJvd3M9NTQ3IHdpZHRoPTQ4KSAoYWN0dWFsIHRp bWU9MC4wNi4uMi4zNSByb3dzPTU1OSBsb29wcz0xKQogICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD0xLjEzLi4xLjEzIHJvd3M9 MTMgd2lkdGg9MTQpIChhY3R1YWwgdGltZT0wLjA5Li4wLjA5IHJvd3M9MCBs b29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBT ZXEgU2NhbiBvbiBjb250cmFjdCBjbyAgKGNvc3Q9MC4wMC4uMS4xMyByb3dz PTEzIHdpZHRoPTE0KSAoYWN0dWFsIHRpbWU9MC4wNC4uMC4wNiByb3dzPTEz IGxvb3BzPTEpCiAgICAgICAgLT4gIEhhc2ggIChjb3N0PTEuNTcuLjEuNTcg cm93cz01NyB3aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTAuMjMuLjAuMjMgcm93 cz0wIGxvb3BzPTEpCiAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGNs ZWFyaW5nX2FjY291bnQgY2EgIChjb3N0PTAuMDAuLjEuNTcgcm93cz01NyB3 aWR0aD0yNCkgKGFjdHVhbCB0aW1lPTAuMDcuLjAuMTYgcm93cz01NyBsb29w cz0xKQogIC0+ICBJbmRleCBTY2FuIHVzaW5nIG9yZGVyX3BrIG9uIHRiX29y ZGVyIHQgIChjb3N0PTAuMDAuLjUuOTMgcm93cz0xIHdpZHRoPTE4KSAoYWN0 dWFsIHRpbWU9MC4wMi4uMC4wMiByb3dzPTEgbG9vcHM9MTEzMDI2KQpUb3Rh bCBydW50aW1lOiA2OTY3LjkxIG1zZWMKCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tCmNzcXVhcmVkID0gaW5kZXhDb3JyZWxhdGlvbiAqIGlu ZGV4Q29ycmVsYXRpb247CiAgIGYuZmlsbF90cyA+ICcyMDAyLTAyLTA0IDAw OjAwOjAwJyBhbmQKICAgZi5maWxsX3RzIDw9ICcyMDAyLTAyLTA2IDIzOjU5 OjU5JyBhbmQKCk5lc3RlZCBMb29wICAoY29zdD0zNS45OC4uNzcxNzY2LjUz IHJvd3M9NzY0NzMgd2lkdGg9MTcwKSAoYWN0dWFsIHRpbWU9NDkxODUuODcu LjEzMTQ2MC43OSByb3dzPTE5MTQ4MyBsb29wcz0xKQogIC0+ICBIYXNoIEpv aW4gIChjb3N0PTM1Ljk4Li4zMTczOTQuNzcgcm93cz03NjQ3MyB3aWR0aD0x NTIpIChhY3R1YWwgdGltZT00OTEzNS4wNC4uMTI2MTI4LjQ3IHJvd3M9MTkx NDgzIGxvb3BzPTEpCiAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9MzQu MjYuLjMxNjA1NC43OSByb3dzPTc2NDczIHdpZHRoPTEyOCkgKGFjdHVhbCB0 aW1lPTQ5MTM0Ljc1Li4xMjQ0NjUuMTEgcm93cz0xOTE0ODMgbG9vcHM9MSkK ICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gZmlsbCBmICAoY29zdD0w LjAwLi4zMTQ1MjQuMDQgcm93cz0xMDgxMTUgd2lkdGg9NjYpIChhY3R1YWwg dGltZT00OTEyOS4wOC4uMTIzMDE5LjI3IHJvd3M9MTkxNDgzIGxvb3BzPTEp CiAgICAgICAgICAgICAgLT4gIEhhc2ggIChjb3N0PTMyLjg5Li4zMi44OSBy b3dzPTU0NyB3aWR0aD02MikgKGFjdHVhbCB0aW1lPTUuNjAuLjUuNjAgcm93 cz0wIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggSm9p biAgKGNvc3Q9MS4xNi4uMzIuODkgcm93cz01NDcgd2lkdGg9NjIpIChhY3R1 YWwgdGltZT0wLjE5Li40LjY4IHJvd3M9NTU5IGxvb3BzPTEpCiAgICAgICAg ICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHN5bWJvbCBzICAo Y29zdD0wLjAwLi4yMC43OCByb3dzPTU0NyB3aWR0aD00OCkgKGFjdHVhbCB0 aW1lPTAuMDUuLjIuMzggcm93cz01NTkgbG9vcHM9MSkKICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9MS4xMy4uMS4xMyByb3dz PTEzIHdpZHRoPTE0KSAoYWN0dWFsIHRpbWU9MC4wOS4uMC4wOSByb3dzPTAg bG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U2VxIFNjYW4gb24gY29udHJhY3QgY28gIChjb3N0PTAuMDAuLjEuMTMgcm93 cz0xMyB3aWR0aD0xNCkgKGFjdHVhbCB0aW1lPTAuMDQuLjAuMDYgcm93cz0x MyBsb29wcz0xKQogICAgICAgIC0+ICBIYXNoICAoY29zdD0xLjU3Li4xLjU3 IHJvd3M9NTcgd2lkdGg9MjQpIChhY3R1YWwgdGltZT0wLjIzLi4wLjIzIHJv d3M9MCBsb29wcz0xKQogICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBj bGVhcmluZ19hY2NvdW50IGNhICAoY29zdD0wLjAwLi4xLjU3IHJvd3M9NTcg d2lkdGg9MjQpIChhY3R1YWwgdGltZT0wLjA3Li4wLjE1IHJvd3M9NTcgbG9v cHM9MSkKICAtPiAgSW5kZXggU2NhbiB1c2luZyBvcmRlcl9wayBvbiB0Yl9v cmRlciB0ICAoY29zdD0wLjAwLi41LjkzIHJvd3M9MSB3aWR0aD0xOCkgKGFj dHVhbCB0aW1lPTAuMDIuLjAuMDIgcm93cz0xIGxvb3BzPTE5MTQ4MykKVG90 YWwgcnVudGltZTogMTMxNTQyLjE3IG1zZWMK --------------Boundary-00=_YPH8IJ0XJ0SQN0U0D2LD--