X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 664B952859 for ; Thu, 26 May 2005 23:40:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93543-03 for ; Fri, 27 May 2005 02:40:05 +0000 (GMT) Received: from mammoth.utopiasystems.net (meridian1.utopiasystems.net [66.150.45.40]) by svr1.postgresql.org (Postfix) with ESMTP id 9B2D452848 for ; Thu, 26 May 2005 23:40:00 -0300 (ADT) Received: from 67.173.111.107 ([67.173.111.107]) by mammoth.utopiasystems.net ([172.16.1.40]) via Exchange Front-End Server mail.utopiasystems.net ([172.16.1.42]) with Microsoft Exchange Server HTTP-DAV ; Fri, 27 May 2005 02:39:28 +0000 User-Agent: Microsoft-Entourage/11.1.0.040913 Date: Thu, 26 May 2005 21:39:26 -0500 Subject: Convenient dump of table and object size in PG 7.4 From: Steve Lane To: Message-ID: In-Reply-To: <4294CFC0.6040901@ca.afilias.info> Mime-version: 1.0 Content-type: multipart/mixed; boundary="B_3199988368_14448028" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.565 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200505/279 X-Sequence-Number: 17708 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3199988368_14448028 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Hello all: Attached is a view I wrote for postgres 7.4 that seems to provide pretty accurate reporting of table sizes. For each non-system table in a database it shows base table size, size of any related TOAST data, and aggregate size of indexes. The code is somewhat ugly in that it contains a bunch of CASE statements the sole point of which is to transform the occasional NULL into a 0. Object sizes are computed from pg_class.relpages with an assumed page size of 8192. Comments and improvements most welcome. -- sgl -------- Steve Lane Vice President Soliant Consulting, Inc. (312) 850-3830 (V) (312) 850-3930 (F) slane@soliantconsulting.com --B_3199988368_14448028 Content-type: text/plain; name="table_size.txt"; x-mac-creator="522A6368"; x-mac-type="54455854" Content-disposition: attachment; filename="table_size.txt" Content-transfer-encoding: base64 aWVwX2RiPSMgc2VsZWN0ICogZnJvbSB0YWJsZV9zaXplczsKICAgICAgICAgICAgTmFtZSAg ICAgICAgICAgICB8ICAgIFJvd3MgICAgIHwgQmFzZSBTaXplIHwgVG9hc3QgU2l6ZSB8IFRv YXN0IEluZGV4IFNpemUgfCBpbmRleF9zaXplIHwgVG90YWwgU2l6ZSBNQiAKLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0K IGllcF9sb2cgICAgICAgICAgICAgICAgICAgICB8IDEuMDI3NjhlKzA3IHwgICAgOTkyLjk1 IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAxMjQzLjY4IHwgICAgICAg MjIzNi42NQogaWVwX2xvZ19vbGQgICAgICAgICAgICAgICAgIHwgOC4wNDI0NGUrMDYgfCAg ICA3NzQuNjQgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICA5NzMuMzAg fCAgICAgICAxNzQ3Ljk1CiBzdHVkZW50X3NlYXJjaDQgICAgICAgICAgICAgfCAyLjA5NDE0 ZSswNiB8ICAgIDM0Mi40OSB8ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAg IDQyNi44OSB8ICAgICAgICA3NjkuMzgKIGllcF9mb3JtXzAwNCAgICAgICAgICAgICAgICB8 ICAgICAgIDc4OTIxIHwgICAgMTU5Ljk3IHwgICAgIDI0NS41NiB8ICAgICAgICAgICAgMTYu ODYgfCAgICAgICA0LjMwIHwgICAgICAgIDQyNi42OQogaWVwX2Zvcm1fMDA0X2dvYWwgICAg ICAgICAgIHwgICAgICAyMzI5MDAgfCAgICAyMTMuNTAgfCAgICAgICAwLjcwIHwgICAgICAg ICAgICAgMC4wMyB8ICAgICAgMTYuODEgfCAgICAgICAgMjMxLjA0CiBpZXBfZm9ybV8wMDRf Z29hbF9wcm9ncmVzcyAgfCAgICAgIDQ4NjMzOSB8ICAgIDEzMS4zMyB8ICAgICAgIDAuMjkg fCAgICAgICAgICAgICAwLjAyIHwgICAgICA0My43MCB8ICAgICAgICAxNzUuMzUKIGllcF9m b3JtXzAwMiAgICAgICAgICAgICAgICB8ICAgICAgIDQyMjM0IHwgICAgIDUwLjM2IHwgICAg ICA2Ny44OCB8ICAgICAgICAgICAgIDAuOTYgfCAgICAgICAxLjU2IHwgICAgICAgIDEyMC43 NQogaWVwX2d1YXJkaWFuICAgICAgICAgICAgICAgIHwgICAgICAxNjAxNTEgfCAgICAgNDMu NTcgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgMjguMzkgfCAgICAg ICAgIDcxLjk3CiBpZXBfZm9ybV8wMDMgICAgICAgICAgICAgICAgfCAgICAgICA3NDQ5MiB8 ICAgICA1Ni4xNyB8ICAgICAgIDAuMDEgfCAgICAgICAgICAgICAwLjAyIHwgICAgICAgMi43 MCB8ICAgICAgICAgNTguOTAKIGllcF9mb3JtXzAxMCAgICAgICAgICAgICAgICB8ICAgICAg MTY1ODI3IHwgICAgIDQ4LjA1IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAg ICAgICA5LjAyIHwgICAgICAgICA1Ny4wNwogaWVwX3N0dWRlbnQgICAgICAgICAgICAgICAg IHwgICAgICAxMDQyOTcgfCAgICAgMzYuMTMgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAg MC4wMSB8ICAgICAgMTcuODAgfCAgICAgICAgIDUzLjk0CiBkZWxldGVkX2Zvcm1zICAgICAg ICAgICAgICAgfCAgICAgICAxNDc2OSB8ICAgICAyMi44NCB8ICAgICAgMTIuNTAgfCAgICAg ICAgICAgICAwLjE4IHwgICAgICAgMC4wMCB8ICAgICAgICAgMzUuNTIKIGllcF9mb3JtXzAw NF9zdXBwICAgICAgICAgICB8ICAgICAgIDE2NDI5IHwgICAgIDEzLjAwIHwgICAgICAxOS45 MSB8ICAgICAgICAgICAgIDAuMjcgfCAgICAgICAwLjMxIHwgICAgICAgICAzMy41MAogaWVw X3N0dWRlbnRfdGVhbSAgICAgICAgICAgIHwgICAgICAxMzg4MTIgfCAgICAgMTQuMTkgfCAg ICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgMTAuMDMgfCAgICAgICAgIDI0 LjIyCiBpZXBfZm9ybV8wMDEgICAgICAgICAgICAgICAgfCAgICAgICAxNTI2NSB8ICAgICAx Ni4xMiB8ICAgICAgIDAuNTQgfCAgICAgICAgICAgICAwLjA0IHwgICAgICAgMC41OSB8ICAg ICAgICAgMTcuMjkKIGllcF9mb3JtXzAxMSAgICAgICAgICAgICAgICB8ICAgICAgIDIwMTM4 IHwgICAgIDEzLjc5IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAw Ljc1IHwgICAgICAgICAxNC41NQogaWVwX3Nlc3Npb24gICAgICAgICAgICAgICAgIHwgICAg ICAgIDU2ODAgfCAgICAgIDQuNDIgfCAgICAgICA5LjI3IHwgICAgICAgICAgICAgMC4xNSB8 ICAgICAgIDAuNjAgfCAgICAgICAgIDE0LjQ0CiBpZXBfZm9ybV8wMDcgICAgICAgICAgICAg ICAgfCAgICAgICAxMjY1NSB8ICAgICAxMi45NCB8ICAgICAgIDAuMzQgfCAgICAgICAgICAg ICAwLjAzIHwgICAgICAgMC40OSB8ICAgICAgICAgMTMuODAKIGllcF9mb3JtXzAwNSAgICAg ICAgICAgICAgICB8ICAgICAgIDEzMDI3IHwgICAgICA5Ljk5IHwgICAgICAgMC4yMSB8ICAg ICAgICAgICAgIDAuMDIgfCAgICAgICAwLjUxIHwgICAgICAgICAxMC43MwogaWVwX2Zvcm1f MDEzICAgICAgICAgICAgICAgIHwgICAgICAgIDI1MjUgfCAgICAgIDQuNzQgfCAgICAgICA0 LjEyIHwgICAgICAgICAgICAgMC4xOCB8ICAgICAgIDAuMjAgfCAgICAgICAgICA5LjI0CiBp ZnNwX2dvYWxzICAgICAgICAgICAgICAgICAgfCAgICAgICAgNzkzMyB8ICAgICAgNy45MiB8 ICAgICAgIDAuMTcgfCAgICAgICAgICAgICAwLjAyIHwgICAgICAgMC4xNiB8ICAgICAgICAg IDguMjcKIGllcF9mb3JtXzAwOSAgICAgICAgICAgICAgICB8ICAgICAgIDEwMzY3IHwgICAg ICA2Ljg0IHwgICAgICAgMC4xNiB8ICAgICAgICAgICAgIDAuMDIgfCAgICAgICAwLjQxIHwg ICAgICAgICAgNy40MgogaWVwX21lc3NhZ2UgICAgICAgICAgICAgICAgIHwgICAgICAgMTYx NTcgfCAgICAgIDYuOTYgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAg IDAuMzEgfCAgICAgICAgICA3LjI3CiBpZXBfZm9ybV8wMDggICAgICAgICAgICAgICAgfCAg ICAgICAgNjk5NyB8ICAgICAgNS45NiB8ICAgICAgIDAuMDcgfCAgICAgICAgICAgICAwLjAy IHwgICAgICAgMC4yOSB8ICAgICAgICAgIDYuMzUKIGllcF9wZXJzb25uZWwgICAgICAgICAg ICAgICB8ICAgICAgICA5NDgwIHwgICAgICAyLjgwIHwgICAgICAgMC4wMCB8ICAgICAgICAg ICAgIDAuMDEgfCAgICAgICAwLjgyIHwgICAgICAgICAgMy42MwogaWVwX2Zvcm1fMDEyICAg ICAgICAgICAgICAgIHwgICAgICAgIDIyNjggfCAgICAgIDIuNjUgfCAgICAgICAwLjUyIHwg ICAgICAgICAgICAgMC4wMyB8ICAgICAgIDAuMTEgfCAgICAgICAgICAzLjMyCiBpZXBfZm9y bV8wMTcgICAgICAgICAgICAgICAgfCAgICAgICAgMzI0MiB8ICAgICAgMi40MCB8ICAgICAg IDAuNjYgfCAgICAgICAgICAgICAwLjAzIHwgICAgICAgMC4xNiB8ICAgICAgICAgIDMuMjYK IGllcF9wcml2aWxlZ2VzICAgICAgICAgICAgICB8ICAgICAgIDE4NjYzIHwgICAgICAyLjQy IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjcwIHwgICAgICAg ICAgMy4xNAogaWVwX2d1YXJkaWFuX3RlbXAgICAgICAgICAgIHwgICAgICAgMTcyNzQgfCAg ICAgIDIuOTggfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgIDAuMDAg fCAgICAgICAgICAyLjk5CiBpZXBfdHJhbnNmZXJfcmVxdWVzdCAgICAgICAgfCAgICAgICAg ODM3OSB8ICAgICAgMS40NyB8ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAg ICAgMS40NyB8ICAgICAgICAgIDIuOTQKIGlmc3BfdGVhbV9tZW1iZXJzICAgICAgICAgICB8 ICAgICAgIDE0NjcyIHwgICAgICAyLjQyIHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAu MDEgfCAgICAgICAwLjI5IHwgICAgICAgICAgMi43MQogaWZzcF9zZXJ2aWNlcyAgICAgICAg ICAgICAgIHwgICAgICAgIDgwNTkgfCAgICAgIDIuMTYgfCAgICAgICAwLjAwIHwgICAgICAg ICAgICAgMC4wMSB8ICAgICAgIDAuMTYgfCAgICAgICAgICAyLjMzCiBpZXBfc3VwcCAgICAg ICAgICAgICAgICAgICAgfCAgICAgICAgMTA4NiB8ICAgICAgMC43NiB8ICAgICAgIDAuOTMg fCAgICAgICAgICAgICAwLjAzIHwgICAgICAgMC4wOCB8ICAgICAgICAgIDEuODEKIGllcF9m b3JtXzAxNCAgICAgICAgICAgICAgICB8ICAgICAgICAyMDUzIHwgICAgICAxLjQ5IHwgICAg ICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjExIHwgICAgICAgICAgMS42 MQogZGVsZXRlX2dvYWxfYmFja3VwX2J1ZzI0NjUgIHwgICAgICAgIDEzODIgfCAgICAgIDEu MjQgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgIDAuMDAgfCAgICAg ICAgICAxLjI1CiBpZXBfZ29hbF9vYmplY3RpdmUgICAgICAgICAgfCAgICAgICAgNTIyOCB8 ICAgICAgMC44OCB8ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAgICAgMC4x OSB8ICAgICAgICAgIDEuMDcKIGllcF9mb3JtXzAxNSAgICAgICAgICAgICAgICB8ICAgICAg ICAgODM5IHwgICAgICAwLjgzIHwgICAgICAgMC4wMSB8ICAgICAgICAgICAgIDAuMDIgfCAg ICAgICAwLjA3IHwgICAgICAgICAgMC45MgogaWZzcF9wYXJlbnRzICAgICAgICAgICAgICAg IHwgICAgICAgIDQ3MzEgfCAgICAgIDAuNzYgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAg MC4wMSB8ICAgICAgIDAuMTEgfCAgICAgICAgICAwLjg4CiBpZnNwX3RyYW5fcGxhbl9wYXJ0 aWNpcGFudHMgfCAgICAgICAgMzM0NCB8ICAgICAgMC41OSB8ICAgICAgIDAuMDAgfCAgICAg ICAgICAgICAwLjAxIHwgICAgICAgMC4wOCB8ICAgICAgICAgIDAuNjgKIGlmc3BfdGVhbV9v dGhlciAgICAgICAgICAgICB8ICAgICAgICA0MjU0IHwgICAgICAwLjUyIHwgICAgICAgMC4w MCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjEwIHwgICAgICAgICAgMC42MwogaWVw X3N0dWRlbnRfdGVhbWJ1ICAgICAgICAgIHwgICAgICAgIDU3NDcgfCAgICAgIDAuNjAgfCAg ICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgIDAuMDAgfCAgICAgICAgICAw LjYxCiBpZXBfZ29hbF9jb25kaXRpb24gICAgICAgICAgfCAgICAgICAgMjA5MiB8ICAgICAg MC41NyB8ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAgICAgMC4wMCB8ICAg ICAgICAgIDAuNTcKIGllcF9zdHVkZW50X2RlbGV0ZWQgICAgICAgICB8ICAgICAgICAxNjk2 IHwgICAgICAwLjU1IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAw LjAwIHwgICAgICAgICAgMC41NgogaWVwX3NjaG9vbCAgICAgICAgICAgICAgICAgIHwgICAg ICAgIDEyNzAgfCAgICAgIDAuMjggfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8 ICAgICAgIDAuMjUgfCAgICAgICAgICAwLjU0CiBpZXBfZm9ybV8wMTYgICAgICAgICAgICAg ICAgfCAgICAgICAgIDYwNyB8ICAgICAgMC40MCB8ICAgICAgIDAuMDIgfCAgICAgICAgICAg ICAwLjAyIHwgICAgICAgMC4wNyB8ICAgICAgICAgIDAuNTAKIGllcF9ydWxlNTEgICAgICAg ICAgICAgICAgICB8ICAgICAgICAxNDcwIHwgICAgICAwLjM0IHwgICAgICAgMC4wMCB8ICAg ICAgICAgICAgIDAuMDEgfCAgICAgICAwLjA3IHwgICAgICAgICAgMC40MgogaWVwX3NjaG9v bF9uYW1lICAgICAgICAgICAgIHwgICAgICAgIDEyNjMgfCAgICAgIDAuMTkgfCAgICAgICAw LjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgIDAuMTMgfCAgICAgICAgICAwLjMzCiBp ZXBfZXh0cmFjdXJyaWN1bGFyc19zYXZlZCAgfCAgICAgICAgMjIyOSB8ICAgICAgMC4yOSB8 ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAgICAgMC4wMCB8ICAgICAgICAg IDAuMzAKIGllcF9kaXN0cmljdCAgICAgICAgICAgICAgICB8ICAgICAgICAgNTEwIHwgICAg ICAwLjE5IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjEwIHwg ICAgICAgICAgMC4yOQogaWVwX2Zvcm1fMDA2ICAgICAgICAgICAgICAgIHwgICAgICAgICAy ODAgfCAgICAgIDAuMjAgfCAgICAgICAwLjAxIHwgICAgICAgICAgICAgMC4wMiB8ICAgICAg IDAuMDMgfCAgICAgICAgICAwLjI2CiBscHNfbWR0X3BhcmFncmFwaHMgICAgICAgICAgfCAg ICAgICAgIDM4NSB8ICAgICAgMC4xNCB8ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAx IHwgICAgICAgMC4wMyB8ICAgICAgICAgIDAuMTgKIGllcF9zdXJ2ZXkgICAgICAgICAgICAg ICAgICB8ICAgICAgICAgMjM5IHwgICAgICAwLjExIHwgICAgICAgMC4wMSB8ICAgICAgICAg ICAgIDAuMDIgfCAgICAgICAwLjAzIHwgICAgICAgICAgMC4xNwogaWVwX3NjaG9vbF9yZXBv cnRfZGF0ZSAgICAgIHwgICAgICAgIDE3MzAgfCAgICAgIDAuMTUgfCAgICAgICAwLjAwIHwg ICAgICAgICAgICAgMC4wMCB8ICAgICAgIDAuMDAgfCAgICAgICAgICAwLjE1CiBpZXBfc2Vz aXNfc25hcHNob3QyICAgICAgICAgfCAgICAgICAgIDEzNCB8ICAgICAgMC4xMyB8ICAgICAg IDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAgICAgMC4wMCB8ICAgICAgICAgIDAuMTQK IGllcF9zZXNpc19zbmFwc2hvdCAgICAgICAgICB8ICAgICAgICAgMjA2IHwgICAgICAwLjEy IHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjAwIHwgICAgICAg ICAgMC4xMwogaWVwX3NjaG9vbF9ub25fcHVibGljICAgICAgIHwgICAgICAgICA0OTQgfCAg ICAgIDAuMDcgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgIDAuMDMg fCAgICAgICAgICAwLjExCiBpZXBfbWVzc2FnZXMgICAgICAgICAgICAgICAgfCAgICAgICAg ICA0OSB8ICAgICAgMC4wNCB8ICAgICAgIDAuMDAgfCAgICAgICAgICAgICAwLjAxIHwgICAg ICAgMC4wMiB8ICAgICAgICAgIDAuMDcKIGllcF9jb3VudHkgICAgICAgICAgICAgICAgICB8 ICAgICAgICAgIDk1IHwgICAgICAwLjAyIHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAu MDEgfCAgICAgICAwLjAzIHwgICAgICAgICAgMC4wNgogaWVwX2dvYWxfc3VidG9waWMgICAg ICAgICAgIHwgICAgICAgICAzNTEgfCAgICAgIDAuMDMgfCAgICAgICAwLjAwIHwgICAgICAg ICAgICAgMC4wMSB8ICAgICAgIDAuMDIgfCAgICAgICAgICAwLjA2CiBpZXBfZ29hbF90b3Bp YyAgICAgICAgICAgICAgfCAgICAgICAgIDE1MyB8ICAgICAgMC4wMiB8ICAgICAgIDAuMDAg fCAgICAgICAgICAgICAwLjAxIHwgICAgICAgMC4wMiB8ICAgICAgICAgIDAuMDQKIGllcF9n b2FsX2RvbWFpbiAgICAgICAgICAgICB8ICAgICAgICAgIDIxIHwgICAgICAwLjAxIHwgICAg ICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjAyIHwgICAgICAgICAgMC4w MwogaWVwX2dvYWxfc3RhbmRhcmQgICAgICAgICAgIHwgICAgICAgICAyMjkgfCAgICAgIDAu MDIgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAgMC4wMSB8ICAgICAgIDAuMDAgfCAgICAg ICAgICAwLjAzCiBpZXBfZm9ybV9uZXdkdXBlcyAgICAgICAgICAgfCAgICAgICAgICAgNCB8 ICAgICAgMC4wMSB8ICAgICAgIDAuMDEgfCAgICAgICAgICAgICAwLjAyIHwgICAgICAgMC4w MCB8ICAgICAgICAgIDAuMDMKIG1hc3Rlcl9mb3JtICAgICAgICAgICAgICAgICB8ICAgICAg ICAgICAwIHwgICAgICAwLjAwIHwgICAgICAgMC4wMCB8ICAgICAgICAgICAgIDAuMDEgfCAg ICAgICAwLjAxIHwgICAgICAgICAgMC4wMgogaWVwX2FjY29tX2NoZWNrbGlzdCAgICAgICAg IHwgICAgICAgICAgIDkgfCAgICAgIDAuMDEgfCAgICAgICAwLjAwIHwgICAgICAgICAgICAg MC4wMSB8ICAgICAgIDAuMDAgfCAgICAgICAgICAwLjAyCiBoZWxwZXJfc3R1ZGVudF90ZWFt ICAgICAgICAgfCAgICAgICAgICAgMyB8ICAgICAgMC4wMSB8ICAgICAgIDAuMDAgfCAgICAg ICAgICAgICAwLjAxIHwgICAgICAgMC4wMCB8ICAgICAgICAgIDAuMDIKIGllcF9wYWdldmll d3MgICAgICAgICAgICAgICB8ICAgICAgICAgICAwIHwgICAgICAwLjAwIHwgICAgICAgMC4w MCB8ICAgICAgICAgICAgIDAuMDEgfCAgICAgICAwLjAwIHwgICAgICAgICAgMC4wMQooNjcg cm93cykKCmllcF9kYj0jIFxkIHRhYmxlX3NpemVzCiAgICAgICBWaWV3ICJwdWJsaWMudGFi bGVfc2l6ZXMiCiAgICAgIENvbHVtbiAgICAgIHwgIFR5cGUgICB8IE1vZGlmaWVycyAKLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLQogTmFtZSAgICAgICAgICAg ICB8IG5hbWUgICAgfCAKIFJvd3MgICAgICAgICAgICAgfCByZWFsICAgIHwgCiBCYXNlIFNp emUgICAgICAgIHwgbnVtZXJpYyB8IAogVG9hc3QgU2l6ZSAgICAgICB8IG51bWVyaWMgfCAK IFRvYXN0IEluZGV4IFNpemUgfCBudW1lcmljIHwgCiBpbmRleF9zaXplICAgICAgIHwgbnVt ZXJpYyB8IAogVG90YWwgU2l6ZSBNQiAgICB8IG51bWVyaWMgfCAKVmlldyBkZWZpbml0aW9u OgogU0VMRUNUIHJlbG5hbWUgQVMgIk5hbWUiLCByZWx0dXBsZXMgQVMgIlJvd3MiLCByb3Vu ZCgwLjAwODE5MiAqIHJlbHBhZ2VzOjpudW1lcmljLCAyKSBBUyAiQmFzZSBTaXplIiwgcm91 bmQoMC4wMDgxOTIgKiAKICAgICAgICBDQVNFCiAgICAgICAgICAgIFdIRU4gKCggU0VMRUNU IGMyLnJlbHBhZ2VzCiAgICAgICAgICAgICAgIEZST00gcGdfY2xhc3MgYzIKICAgICAgICAg ICAgICBXSEVSRSBjMi5vaWQgPSBjMS5yZWx0b2FzdHJlbGlkKSkgSVMgTlVMTCBUSEVOIDAK ICAgICAgICAgICAgRUxTRSAoIFNFTEVDVCBjMi5yZWxwYWdlcwogICAgICAgICAgICAgICBG Uk9NIHBnX2NsYXNzIGMyCiAgICAgICAgICAgICAgV0hFUkUgYzIub2lkID0gYzEucmVsdG9h c3RyZWxpZCkKICAgICAgICBFTkQ6Om51bWVyaWMsIDIpIEFTICJUb2FzdCBTaXplIiwgcm91 bmQoMC4wMDgxOTIgKiAKICAgICAgICBDQVNFCiAgICAgICAgICAgIFdIRU4gKCggU0VMRUNU IGMzLnJlbHBhZ2VzCiAgICAgICAgICAgICAgIEZST00gcGdfY2xhc3MgYzIsIHBnX2NsYXNz IGMzCiAgICAgICAgICAgICAgV0hFUkUgYzEucmVsdG9hc3RyZWxpZCA9IGMyLm9pZCBBTkQg YzIucmVsdG9hc3RpZHhpZCA9IGMzLm9pZCkpIElTIE5VTEwgVEhFTiAwCiAgICAgICAgICAg IEVMU0UgKCBTRUxFQ1QgYzMucmVscGFnZXMKICAgICAgICAgICAgICAgRlJPTSBwZ19jbGFz cyBjMiwgcGdfY2xhc3MgYzMKICAgICAgICAgICAgICBXSEVSRSBjMS5yZWx0b2FzdHJlbGlk ID0gYzIub2lkIEFORCBjMi5yZWx0b2FzdGlkeGlkID0gYzMub2lkKQogICAgICAgIEVORDo6 bnVtZXJpYywgMikgQVMgIlRvYXN0IEluZGV4IFNpemUiLCByb3VuZCgKICAgICAgICBDQVNF CiAgICAgICAgICAgIFdIRU4gKCggU0VMRUNUIHN1bShjMi5yZWxwYWdlczo6bnVtZXJpYyAq IDAuMDA4MTkyKSBBUyBzdW0KICAgICAgICAgICAgICAgRlJPTSBwZ19jbGFzcyBjMiwgcGdf aW5kZXggaQogICAgICAgICAgICAgIFdIRVJFIGMxLm9pZCA9IGkuaW5kcmVsaWQgQU5EIGku aW5kZXhyZWxpZCA9IGMyLm9pZCkpIElTIE5VTEwgVEhFTiAwOjpudW1lcmljCiAgICAgICAg ICAgIEVMU0UgKCBTRUxFQ1Qgc3VtKGMyLnJlbHBhZ2VzOjpudW1lcmljICogMC4wMDgxOTIp IEFTIHN1bQogICAgICAgICAgICAgICBGUk9NIHBnX2NsYXNzIGMyLCBwZ19pbmRleCBpCiAg ICAgICAgICAgICAgV0hFUkUgYzEub2lkID0gaS5pbmRyZWxpZCBBTkQgaS5pbmRleHJlbGlk ID0gYzIub2lkKQogICAgICAgIEVORCwgMikgQVMgaW5kZXhfc2l6ZSwgcm91bmQoMC4wMDgx OTIgKiAocmVscGFnZXMgKyAKICAgICAgICBDQVNFCiAgICAgICAgICAgIFdIRU4gKCggU0VM RUNUIGMyLnJlbHBhZ2VzCiAgICAgICAgICAgICAgIEZST00gcGdfY2xhc3MgYzIKICAgICAg ICAgICAgICBXSEVSRSBjMi5vaWQgPSBjMS5yZWx0b2FzdHJlbGlkKSkgSVMgTlVMTCBUSEVO IDAKICAgICAgICAgICAgRUxTRSAoIFNFTEVDVCBjMi5yZWxwYWdlcwogICAgICAgICAgICAg ICBGUk9NIHBnX2NsYXNzIGMyCiAgICAgICAgICAgICAgV0hFUkUgYzIub2lkID0gYzEucmVs dG9hc3RyZWxpZCkKICAgICAgICBFTkQgKyAKICAgICAgICBDQVNFCiAgICAgICAgICAgIFdI RU4gKCggU0VMRUNUIGMzLnJlbHBhZ2VzCiAgICAgICAgICAgICAgIEZST00gcGdfY2xhc3Mg YzIsIHBnX2NsYXNzIGMzCiAgICAgICAgICAgICAgV0hFUkUgYzEucmVsdG9hc3RyZWxpZCA9 IGMyLm9pZCBBTkQgYzIucmVsdG9hc3RpZHhpZCA9IGMzLm9pZCkpIElTIE5VTEwgVEhFTiAw CiAgICAgICAgICAgIEVMU0UgKCBTRUxFQ1QgYzMucmVscGFnZXMKICAgICAgICAgICAgICAg RlJPTSBwZ19jbGFzcyBjMiwgcGdfY2xhc3MgYzMKICAgICAgICAgICAgICBXSEVSRSBjMS5y ZWx0b2FzdHJlbGlkID0gYzIub2lkIEFORCBjMi5yZWx0b2FzdGlkeGlkID0gYzMub2lkKQog ICAgICAgIEVORCk6Om51bWVyaWMgKyAKICAgICAgICBDQVNFCiAgICAgICAgICAgIFdIRU4g KCggU0VMRUNUIHN1bShjMi5yZWxwYWdlczo6bnVtZXJpYyAqIDAuMDA4MTkyKSBBUyBzdW0K ICAgICAgICAgICAgICAgRlJPTSBwZ19jbGFzcyBjMiwgcGdfaW5kZXggaQogICAgICAgICAg ICAgIFdIRVJFIGMxLm9pZCA9IGkuaW5kcmVsaWQgQU5EIGkuaW5kZXhyZWxpZCA9IGMyLm9p ZCkpIElTIE5VTEwgVEhFTiAwOjpudW1lcmljCiAgICAgICAgICAgIEVMU0UgKCBTRUxFQ1Qg c3VtKGMyLnJlbHBhZ2VzOjpudW1lcmljICogMC4wMDgxOTIpIEFTIHN1bQogICAgICAgICAg ICAgICBGUk9NIHBnX2NsYXNzIGMyLCBwZ19pbmRleCBpCiAgICAgICAgICAgICAgV0hFUkUg YzEub2lkID0gaS5pbmRyZWxpZCBBTkQgaS5pbmRleHJlbGlkID0gYzIub2lkKQogICAgICAg IEVORCwgMikgQVMgIlRvdGFsIFNpemUgTUIiCiAgIEZST00gcGdfY2xhc3MgYzEKICAgTEVG VCBKT0lOIHBnX25hbWVzcGFjZSBuIE9OIG4ub2lkID0gYzEucmVsbmFtZXNwYWNlCiAgV0hF UkUgKGMxLnJlbGtpbmQgPSAncic6OiJjaGFyIiBPUiBjMS5yZWxraW5kID0gJyc6OiJjaGFy IikgQU5EIG4ubnNwbmFtZSA8PiAncGdfY2F0YWxvZyc6Om5hbWUgQU5EIG4ubnNwbmFtZSA8 PiAncGdfdG9hc3QnOjpuYW1lIEFORCBwZ190YWJsZV9pc192aXNpYmxlKGMxLm9pZCkKICBP UkRFUiBCWSByb3VuZCgwLjAwODE5MiAqIChyZWxwYWdlcyArIAogICAgICAgIENBU0UKICAg ICAgICAgICAgV0hFTiAoKCBTRUxFQ1QgYzIucmVscGFnZXMKICAgICAgICAgICAgICAgRlJP TSBwZ19jbGFzcyBjMgogICAgICAgICAgICAgIFdIRVJFIGMyLm9pZCA9IGMxLnJlbHRvYXN0 cmVsaWQpKSBJUyBOVUxMIFRIRU4gMAogICAgICAgICAgICBFTFNFICggU0VMRUNUIGMyLnJl bHBhZ2VzCiAgICAgICAgICAgICAgIEZST00gcGdfY2xhc3MgYzIKICAgICAgICAgICAgICBX SEVSRSBjMi5vaWQgPSBjMS5yZWx0b2FzdHJlbGlkKQogICAgICAgIEVORCArIAogICAgICAg IENBU0UKICAgICAgICAgICAgV0hFTiAoKCBTRUxFQ1QgYzMucmVscGFnZXMKICAgICAgICAg ICAgICAgRlJPTSBwZ19jbGFzcyBjMiwgcGdfY2xhc3MgYzMKICAgICAgICAgICAgICBXSEVS RSBjMS5yZWx0b2FzdHJlbGlkID0gYzIub2lkIEFORCBjMi5yZWx0b2FzdGlkeGlkID0gYzMu b2lkKSkgSVMgTlVMTCBUSEVOIDAKICAgICAgICAgICAgRUxTRSAoIFNFTEVDVCBjMy5yZWxw YWdlcwogICAgICAgICAgICAgICBGUk9NIHBnX2NsYXNzIGMyLCBwZ19jbGFzcyBjMwogICAg ICAgICAgICAgIFdIRVJFIGMxLnJlbHRvYXN0cmVsaWQgPSBjMi5vaWQgQU5EIGMyLnJlbHRv YXN0aWR4aWQgPSBjMy5vaWQpCiAgICAgICAgRU5EKTo6bnVtZXJpYyArIAogICAgICAgIENB U0UKICAgICAgICAgICAgV0hFTiAoKCBTRUxFQ1Qgc3VtKGMyLnJlbHBhZ2VzOjpudW1lcmlj ICogMC4wMDgxOTIpIEFTIHN1bQogICAgICAgICAgICAgICBGUk9NIHBnX2NsYXNzIGMyLCBw Z19pbmRleCBpCiAgICAgICAgICAgICAgV0hFUkUgYzEub2lkID0gaS5pbmRyZWxpZCBBTkQg aS5pbmRleHJlbGlkID0gYzIub2lkKSkgSVMgTlVMTCBUSEVOIDA6Om51bWVyaWMKICAgICAg ICAgICAgRUxTRSAoIFNFTEVDVCBzdW0oYzIucmVscGFnZXM6Om51bWVyaWMgKiAwLjAwODE5 MikgQVMgc3VtCiAgICAgICAgICAgICAgIEZST00gcGdfY2xhc3MgYzIsIHBnX2luZGV4IGkK ICAgICAgICAgICAgICBXSEVSRSBjMS5vaWQgPSBpLmluZHJlbGlkIEFORCBpLmluZGV4cmVs aWQgPSBjMi5vaWQpCiAgICAgICAgRU5ELCAyKSBERVNDOwo= --B_3199988368_14448028--