X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C454E475CE5 for ; Wed, 30 Apr 2003 11:55:39 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 6AB71475A45 for ; Wed, 30 Apr 2003 11:55:33 -0400 (EDT) Received: from matrix.gatewaynet.com (localhost [127.0.0.1]) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h3UKvW1s009311 for ; Wed, 30 Apr 2003 18:57:32 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h3UKvVwK009307 for ; Wed, 30 Apr 2003 18:57:32 -0200 Date: Wed, 30 Apr 2003 18:57:31 -0200 (GMT+2) From: Achilleus Mantzios To: pgsql-sql@postgresql.org Subject: 7.3 analyze & vacuum analyze problem In-Reply-To: <3E92E3B1.7070405@eselx.ipl.pt> Message-ID: MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="333001285-2121937442-1051736251=:8921" X-Spam-Status: No, hits=-15.5 required=5.0 tests=BAYES_01,IN_REP_TO,USER_AGENT_PINE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/440 X-Sequence-Number: 13141 This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. --333001285-2121937442-1051736251=:8921 Content-Type: TEXT/PLAIN; charset=US-ASCII Hi, i think i have an issue regarding the statistics that a) (plain) ANALYZE status and b) VACUUM ANALYZE status produce. I have a table status: dynacom=# \d status Table "public.status" Column | Type | Modifiers -------------+--------------------------+--------------------------------------------------- id | integer | not null default nextval('"status_id_seq"'::text) checkdate | timestamp with time zone | assettable | character varying(50) | assetidval | integer | appname | character varying(100) | apptblname | character varying(50) | apptblidval | integer | colname | character varying(50) | colval | double precision | status | character varying(5) | isvalid | boolean | username | character varying(50) | Indexes: status_id_key unique btree (id), status_all btree (assettable, assetidval, appname, apptblname, status, isvalid), status_all_wo_astidval btree (assettable, appname, apptblname, status, isvalid), status_appname btree (appname), status_apptblidval btree (apptblidval), status_apptblname btree (apptblname), status_assetidval btree (assetidval), status_assettable btree (assettable), status_checkdate btree (checkdate), status_colname btree (colname), status_isvalid btree (isvalid), status_status btree (status) dynacom=# dynacom=# SELECT count(*) from status ; count ------- 33565 (1 row) dynacom=# I very often perform queries of the form: select count(*) from status where assettable='vessels' and appname='ISM PMS' and apptblname='items' and status='warn' and isvalid and assetidval=; Altho i dont understand exactly why the stats created by VACUUM ANALYZE are more accurate (meaning producing faster plans) than the ones created by plain ANALYZE, (altho for some attributes they are false for sure) the performance is much much better when VACUUM ANALYZE is run than plain ANALYZE. In the former case, some times the status_all index is used, and sometimes (when the selectivity is small) a sequential scan is performed. In the latter case, no index is ever used even for crazy statements (assetidval is always >0) like: select count(*) from status where assettable='vessels' and appname='ISM PMS' and apptblname='items' and status='warn' and isvalid and assetidval=-10000000; I attach the statistics of either case. My app just performs the above query for most of the assetidval values (And for all most popular assetidval values) So the elapsed time of the app i think is a good measure of the overall performance of these queries. In the "VACUUM ANALYZE" case it takes 1.2 - 1.5 secs, while in the "ANALYZE" case it takes >=3+ -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr --333001285-2121937442-1051736251=:8921 Content-Type: TEXT/PLAIN; charset=US-ASCII; name=2see-VACUUM_ANALYZE Content-Transfer-Encoding: BASE64 Content-ID: Content-Description: Content-Disposition: attachment; filename=2see-VACUUM_ANALYZE ICAgYXR0bmFtZSAgIHwgbnVsbF9mcmFjIHwgYXZnX3dpZHRoIHwgbl9kaXN0 aW5jdCB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBtb3N0 X2NvbW1vbl92YWxzICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IG1vc3RfY29tbW9uX2ZyZXFzICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBoaXN0b2dyYW1f Ym91bmRzICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgfCBjb3JyZWxhdGlvbiANCi0tLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQogaWQgICAgICAg ICAgfCAgICAgICAgIDAgfCAgICAgICAgIDQgfCAgICAgICAgIC0xIHwgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgfCB7MjQsNzA3OSwxMzM4OSwxNzYyNCwyMTA4NCwyNDM5MiwyNTg3 NiwyODAzMywyOTg5NSwzMjEzMiwzMzg2Nn0gICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICB8ICAgIDAuODAxNjg2DQogY2hlY2tkYXRlICAgfCAg ICAgICAgIDAgfCAgICAgICAgIDggfCAgICAgICAgIC0xIHwgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg fCB7IjIwMDItMTAtMTkgMTA6NTk6NTQuMzk5KzAzIiwiMjAwMy0wMy0wMyAw NTowMDoyNS4zNTkrMDIiLCIyMDAzLTAzLTI5IDA1OjAwOjI4LjM4MiswMiIs IjIwMDMtMDQtMDEgMDU6MDE6MDAuMDY1KzAzIiwiMjAwMy0wNC0xMSAwNTow MToyNy4yMzQrMDMiLCIyMDAzLTA0LTI5IDA1OjAwOjQxLjMxOCswMyIsIjIw MDMtMDQtMjkgMDU6MDE6MjQuMDg0KzAzIiwiMjAwMy0wNC0zMCAwNTowMDo0 MC43MTkrMDMiLCIyMDAzLTA0LTMwIDA1OjAxOjA2LjIwMyswMyIsIjIwMDMt MDQtMzAgMDU6MDE6MjUuNDM1KzAzIiwiMjAwMy0wNC0zMCAwNTowMTo0Ni42 MzYrMDMifSB8ICAgIDAuOTIzNzI2DQogYXNzZXR0YWJsZSAgfCAgICAgICAg IDAgfCAgICAgICAgMTEgfCAgICAgICAgICAxIHwge3Zlc3NlbHN9ICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIHwgezF9ICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICB8ICAgICAgICAgICAxDQogYXNzZXRpZHZhbCAgfCAgICAgICAgIDAgfCAg ICAgICAgIDQgfCAgICAgICAgIDE4IHwgezUzLDU3LDQ4LDY1fSAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHwgezAuMTM2NjY3LDAuMTA3MzMzLDAuMTAw MzMzLDAuMDc2NjY2N30gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCB7MjAsMjYsMjks MzIsMzMsMzUsNDQsNDcsNDksNjEsNzR9ICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAg IDAuMTE3NDMxDQogYXBwbmFtZSAgICAgfCAgICAgICAgIDAgfCAgICAgICAg MTEgfCAgICAgICAgICA2IHwgeyJJU00gUE1TIixDbGFzcy5DZXJ0aWZpY2F0 ZXMsQ2xhc3MuU3VydmV5cyxSZXBhaXJzLENsYXNzLkNNUyxDbGFzcy5SZWNv bW1lbmRhdGlvbnN9IHwgezAuOTg5MzMzLDAuMDA1LDAuMDAyNjY2NjcsMC4w MDE2NjY2NywwLjAwMDY2NjY2NywwLjAwMDY2NjY2N30gICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDAuOTkw Mjg2DQogYXBwdGJsbmFtZSAgfCAgICAgICAgIDAgfCAgICAgICAgIDkgfCAg ICAgICAgICA1IHwge2l0ZW1zLGNlcnRpZmljYXRlcyxzdXJ2ZXlzLHJlcGRh dCxyZWNvbW1lbmRhdGlvbnN9ICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIHwgezAuOTksMC4wMDUsMC4wMDI2NjY2NywwLjAwMTY2NjY3LDAu MDAwNjY2NjY3fSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDAuOTc1ODgzDQog YXBwdGJsaWR2YWwgfCAgICAgICAgIDAgfCAgICAgICAgIDQgfCAgICAgICA1 MDAyIHwgezcxNjEsMTEwOTksNzE2MiwxMjM5MiwyODE5LDgzNDYsMTIyNDEs MTI0NjUsMTQ5MzIsMTcwMDd9ICAgICAgICAgICAgICAgICAgICAgICAgICAg IHwgezAuMDAyLDAuMDAyLDAuMDAxNjY2NjcsMC4wMDE2NjY2NywwLjAwMTMz MzMzLDAuMDAxMzMzMzMsMC4wMDEzMzMzMywwLjAwMTMzMzMzLDAuMDAxMzMz MzMsMC4wMDEzMzMzM30gfCB7Nyw1MDE2LDgyOTYsMTI0NDMsMTQ0NDMsMTcx MTUsMjAxNjYsMjE5OTYsMjI4NjYsMjQyMDksMzI3OTZ9ICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICB8ICAgMC4wNjA0MzY3DQogY29sbmFt ZSAgICAgfCAgICAgICAgIDAgfCAgICAgICAgMTQgfCAgICAgICAgICA2IHwg e2xhc3RyZXBkYXRlLGxhc3RpbnNwZGF0ZSxyaCxOL0Esc3RhdHVzLGNsYXNz c3VydmV5fSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgezAu NjYwNjY3LDAuMjk4NjY3LDAuMDMsMC4wMDgzMzMzMywwLjAwMTY2NjY3LDAu MDAwNjY2NjY3fSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAgICAwLjM4MDM2DQogY29sdmFsICAgICAg fCAgICAgICAgIDAgfCAgICAgICAgIDggfCAgLTAuNDMzMDc0IHwgezAsMSwx NjI0LDM3NDIsMTQ2LDU5NCw4NjQsOTE1LDEyNSwyMjR9ICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgezAuMDA5LDAu MDAxNjY2NjcsMC4wMDE2NjY2NywwLjAwMTMzMzMzLDAuMDAxLDAuMDAxLDAu MDAxLDAuMDAxLDAuMDAwNjY2NjY3LDAuMDAwNjY2NjY3fSAgICAgICAgICAg ICAgfCB7MjEsMTQ0NjMuOTQ3LDE0NDk4LjY1LDE4MDMxLjc2MiwxODA0My41 OCwxODA1MS41MTcsMTgwNTkuNzEyLDE4MDY3LjY4OCwxODA3OC42NywyMTY0 Ni4zOSw4MjgxMTU5NC4xNDZ9ICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICB8ICAgIDAuMjg4NjU2DQogc3RhdHVzICAgICAgfCAgICAg ICAgIDAgfCAgICAgICAgIDggfCAgICAgICAgICAyIHwge3dhcm4sYWxhcm19 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgezAuNTUsMC40NX0gICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8ICAgIDAuNDAxMDUzDQogaXN2YWxpZCAgICAgfCAgICAgICAgIDAg fCAgICAgICAgIDEgfCAgICAgICAgICAyIHwge2YsdH0gICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIHwgezAuNjUwNjY3LDAuMzQ5MzMzfSAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8 ICAgIDAuOTQ0ODI3DQogdXNlcm5hbWUgICAgfCAgICAgICAgIDAgfCAgICAg ICAgMTIgfCAgICAgICAgICA3IHwge3BlcmlvZGljLGNrYWtsYW1hbixhbWFu dHppbyxzZWNyZXR1c2VyLG1pdHNpb3MsbGlnbm9zLGJpcnRzaWF9ICAgICAg ICAgICAgICAgICAgICAgIHwgezAuODg2MzMzLDAuMDU0NjY2NywwLjAzMzY2 NjcsMC4wMTIsMC4wMTE2NjY3LDAuMDAxLDAuMDAwNjY2NjY3fSAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDAu ODA1NjA4DQooMTIgcm93cykNCg0K --333001285-2121937442-1051736251=:8921 Content-Type: TEXT/PLAIN; charset=US-ASCII; name=2see-ANALYZE Content-Transfer-Encoding: BASE64 Content-ID: Content-Description: Content-Disposition: attachment; filename=2see-ANALYZE ICAgYXR0bmFtZSAgIHwgbnVsbF9mcmFjIHwgYXZnX3dpZHRoIHwgbl9kaXN0 aW5jdCB8ICAgICAgICAgICAgICAgICAgICAgICAgbW9zdF9jb21tb25fdmFs cyAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgbW9zdF9jb21tb25fZnJlcXMg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg fCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgaGlzdG9ncmFtX2JvdW5kcyAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgfCBjb3JyZWxhdGlvbiANCi0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQog aWQgICAgICAgICAgfCAgICAgICAgIDAgfCAgICAgICAgIDQgfCAgICAgICAg IC0xIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8 IHs5LDYzNTIsMTIyMDEsMTY3NzIsMjAzMDMsMjQxMzAsMjU0MTgsMjc2ODgs Mjk0MjcsMzE5MzgsMzM4Njh9ICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8ICAgIDAuODIxNjY0DQogY2hlY2tkYXRlICAgfCAgICAgICAgIDAg fCAgICAgICAgIDggfCAgICAgICAgIC0xIHwgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IHwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICB8IHsiMjAwMi0xMC0xOSAxMTowMTo1Ni4z MjUrMDMiLCIyMDAzLTAzLTAxIDA1OjAwOjUzLjA1KzAyIiwiMjAwMy0wMy0y MCAwNTowMDozMC43NjkrMDIiLCIyMDAzLTAzLTMwIDA1OjAwOjIyLjk4MSsw MyIsIjIwMDMtMDQtMDcgMDU6MDA6NTIuMjkrMDMiLCIyMDAzLTA0LTI2IDA1 OjAyOjQwLjY3MSswMyIsIjIwMDMtMDQtMjkgMDU6MDE6MTcuMzE0KzAzIiwi MjAwMy0wNC0zMCAwNTowMDozMC4yNDgrMDMiLCIyMDAzLTA0LTMwIDA1OjAx OjAxLjk0NSswMyIsIjIwMDMtMDQtMzAgMDU6MDE6MjMuOTAzKzAzIiwiMjAw My0wNC0zMCAwNTowMTo0Ni43MzcrMDMifSB8ICAgIDAuOTIyODY4DQogYXNz ZXR0YWJsZSAgfCAgICAgICAgIDAgfCAgICAgICAgMTEgfCAgICAgICAgICAx IHwge3Zlc3NlbHN9ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIHwgezF9ICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICB8ICAgICAgICAgICAxDQogYXNzZXRpZHZhbCAgfCAgICAgICAgIDAgfCAg ICAgICAgIDQgfCAgICAgICAgIDE5IHwgezUzLDU3LDQ4LDY1LDQ5fSAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwg ezAuMTE2LDAuMTAxLDAuMDkzMzMzMywwLjA4MjMzMzMsMC4wNjczMzMzfSAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICB8IHsyMCwyNCwyOSwzMiwzMywzNSw0Myw0NCw0 Nyw2MSw3NH0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDAuMTAxNjQxDQogYXBwbmFt ZSAgICAgfCAgICAgICAgIDAgfCAgICAgICAgMTEgfCAgICAgICAgICA1IHwg eyJJU00gUE1TIixDbGFzcy5DZXJ0aWZpY2F0ZXMsQ2xhc3MuU3VydmV5cyxS ZXBhaXJzLENsYXNzLkNNU30gIHwgezAuOTg0NjY3LDAuMDA2NjY2NjcsMC4w MDQzMzMzMywwLjAwMzMzMzMzLDAuMDAxfSAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8 ICAgIDAuOTgwNjM0DQogYXBwdGJsbmFtZSAgfCAgICAgICAgIDAgfCAgICAg ICAgIDkgfCAgICAgICAgICA0IHwge2l0ZW1zLGNlcnRpZmljYXRlcyxzdXJ2 ZXlzLHJlcGRhdH0gICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgezAu OTg1NjY3LDAuMDA2NjY2NjcsMC4wMDQzMzMzMywwLjAwMzMzMzMzfSAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICB8ICAgIDAuOTY4OTY5DQogYXBwdGJsaWR2 YWwgfCAgICAgICAgIDAgfCAgICAgICAgIDQgfCAgICAgICA0NzY0IHwgezc0 MjgsMjAyNTcsMjMzNCw0NjU2LDkwNDAsOTg2NCwxMTA3MCwxMjk3NSwxNTM0 MiwxNTg0NX0gICAgICAgIHwgezAuMDAyLDAuMDAxNjY2NjcsMC4wMDEzMzMz MywwLjAwMTMzMzMzLDAuMDAxMzMzMzMsMC4wMDEzMzMzMywwLjAwMTMzMzMz LDAuMDAxMzMzMzMsMC4wMDEzMzMzMywwLjAwMTMzMzMzfSB8IHsxLDU4MDcs ODQ1NywxMjUwMywxNDUxMiwxNzAwNywxOTk2NywyMTgyMSwyMjkwOSwyNDIw MiwzNTI4NH0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAg MC4wNTk2MDU2DQogY29sbmFtZSAgICAgfCAgICAgICAgIDAgfCAgICAgICAg MTQgfCAgICAgICAgICA2IHwge2xhc3RyZXBkYXRlLGxhc3RpbnNwZGF0ZSxy aCxOL0Esc3RhdHVzLGNsYXNzc3VydmV5fSAgICAgICAgICAgIHwgezAuNjM3 LDAuMzE2NjY3LDAuMDMxLDAuMDExLDAuMDAzMzMzMzMsMC4wMDF9ICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAgIDAuMzY1MzIzDQogY29sdmFsICAgICAg fCAgICAgICAgIDAgfCAgICAgICAgIDggfCAgLTAuMzQ1NTU3IHwgezAsMSw1 OTQsMTIwMCw3ODQsMTYyNCwyMSwxMzYsNTI2LDEyMzF9ICAgICAgICAgICAg ICAgICAgICAgICAgIHwgezAuMDEyLDAuMDAzNjY2NjcsMC4wMDE2NjY2Nyww LjAwMTY2NjY3LDAuMDAxMzMzMzMsMC4wMDEzMzMzMywwLjAwMSwwLjAwMSww LjAwMSwwLjAwMX0gICAgICAgICAgICAgICAgICAgICB8IHsyNCwxNDQ2NC41 NDksMTQ0OTQuMDE3LDE4MDMwLjc3OCwxODA0My40MiwxODA1MS43OSwxODA2 MC4wODksMTgwNjguMTE3LDE4MDc4LjMxOSwxMjI3NDUuOTg4LDc0MjYyMDU2 LjM2N30gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDAu MjM5NDQ4DQogc3RhdHVzICAgICAgfCAgICAgICAgIDAgfCAgICAgICAgIDgg fCAgICAgICAgICAyIHwge3dhcm4sYWxhcm19ICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgezAuNTYxNjY3 LDAuNDM4MzMzfSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICB8ICAgIDAuNDM2MzAyDQogaXN2YWxpZCAgICAgfCAg ICAgICAgIDAgfCAgICAgICAgIDEgfCAgICAgICAgICAyIHwge2YsdH0gICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIHwgezAuNjc1LDAuMzI1fSAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgICAwLjk1 MDA4DQogdXNlcm5hbWUgICAgfCAgICAgICAgIDAgfCAgICAgICAgMTIgfCAg ICAgICAgICA3IHwge3BlcmlvZGljLGNrYWtsYW1hbixhbWFudHppbyxzZWNy ZXR1c2VyLG1pdHNpb3MsbGlnbm9zLGJpcnRzaWF9IHwgezAuODc2MzMzLDAu MDUyMzMzMywwLjA0MSwwLjAxNDMzMzMsMC4wMTIsMC4wMDI2NjY2NywwLjAw MTMzMzMzfSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICB8ICAgIDAuODE3MDk2DQooMTIgcm93cykNCg0K --333001285-2121937442-1051736251=:8921--