X-Original-To: pgsql-performance@postgresql.org Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id D90F65E46FE for ; Tue, 24 Aug 2004 05:32:49 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 548CD2BD63 for ; Tue, 24 Aug 2004 10:32:44 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26247-08 for ; Tue, 24 Aug 2004 10:32:40 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id C5CB22BD5C for ; Tue, 24 Aug 2004 10:32:40 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 913D5DA74E for ; Tue, 24 Aug 2004 10:32:40 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 9D048975A0 for ; Tue, 24 Aug 2004 10:32:40 +0200 (SAST) Date: Tue, 24 Aug 2004 10:32:40 +0200 From: Stef To: pgsql-performance@postgresql.org Subject: Query kills machine. Message-Id: <20040824103240.4d909777@svb.ucs.co.za> X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc" X-Virus-Scanned: by amavisd-new at ucs.co.za X-Archive-Number: 200408/320 X-Sequence-Number: 7956 This is a multi-part message in MIME format. --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi all, I've attached all the query in query.sql I'm using postgres 7.3.4 on Linux version 2.4.26-custom ( /proc/sys/vm/overcommit_memory = 0 this time ) free : total used free shared buffers cached Mem: 1810212 1767384 42828 0 5604 1663908 -/+ buffers/cache: 97872 1712340 Swap: 505912 131304 374608 After I rebuilt the database, the query was fast (28255.12 msec). After one night's insertion into the tables that the query select from, the query all of a sudden uses up all resources , and the kernel starts swapping, and I haven't seen the query actually finish when this happens. I did vacuum analyze AND reindex, but that doesn't help. I attached the explain analyze of the query before this happens, and the explain plan from when it actually happens that the query doesn't finish. The one noticeable difference, was that before, it used merge joins, and after, it used hash joins. When the query was slow, I tried to : set enable_hashjoin to off for this query, and the query finished relatively fast again (316245.16 msec) I attached the output of that explain analyze as well, as well as the postgres settings. Can anyone shed some light on what's happening here. I can't figure it out. Kind Regards Stefan --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: application/octet-stream; name="query.sql" Content-Disposition: attachment; filename="query.sql" Content-Transfer-Encoding: base64 U0VMRUNUIHMuc2t1ICAgICAgICAgICAgICAgICAgQVMgU0tVLAogICAgICAg cy5zdGt0eXBlX2NvZGUgICAgICAgICBBUyBTVEtUWVBFX0NPREUsCiAgICAg ICBpLnNrdV9kZXNjciAgICAgICAgICAgIEFTIFNLVV9ERVNDUiwKICAgICAg IGJyLmNsdXN0ZXJfY29kZSAgICAgICAgQVMgQ0xVU1RFUl9DT0RFLAogICAg ICAgYnIuY2x1c3Rlcl9kZXNjciAgICAgICBBUyBDTFVTVEVSX0RFU0NSLAog ICAgICAgTUFYKHMuY3Vycl9yc3BfY3IpICAgICBBUyBQUklDRSwKICAgICAg IFNVTShzLnF0eV9vbl9oYW5kKSAgICAgQVMgU09ILAogICAgICBTVU0ocy5x dHlfaW5fZ29vZHMgLSBzLnF0eV9pbl9zdXBwICsgcy5xdHlfb25fcmVwYWly IAogICAgICApIEFTIFBMVVNfU1RPQ0tfSU4sCiAgICAgIFNVTShzLnF0eV9v dXRfZ29vZHMpICAgQVMgTEVTU19TVE9DS19PVVQsCiAgICAgIFNVTShzLnF0 eV9kcCkgICAgICAgICAgQVMgTEVTU19ESVNQTEFZLAogICAgICAoU1VNKHMu cXR5X29uX2hhbmQpICsgU1VNKHMucXR5X2luX2dvb2RzIC0gcy5xdHlfaW5f c3VwcCArIHMucXR5X29uX3JlcGFpciAgICAgICkgLSBzdW0ocy5xdHlfb3V0 X2dvb2RzKSAtIHN1bShzLnF0eV9kcCkKICAgICAgKSBBUyBPVkVSU09MRCwK ICAgICAgKHNlbGVjdCBjb2FsZXNjZShzdW0ob3V0X3F0eSksMCk6Om51bWVy aWMgCiAgICAgICBmcm9tIGdpcl9vdXRzdGFuZGluZyAKICAgICAgIHdoZXJl IGNsdXN0ZXJfYnJuID0gYnIuY2x1c3Rlcl9jb2RlIAogICAgICAgYW5kIHNr dSA9IHMuc2t1IAogICAgICAgYW5kIHN0a3R5cGVfY29kZSA9IHMuc3RrdHlw ZV9jb2RlCiAgICAgICkgIEFTIFNDX1NUS19PTl9PUkRFUiwKICAgICAgY2Fz ZSB3aGVuIChzdW0ocy5xdHlfb25faGFuZCkgKyAKICAgICAgICAgICAgICAg ICBzdW0ocy5xdHlfaW5fZ29vZHMgLSBzLnF0eV9pbl9zdXBwICsgcy5xdHlf b25fcmVwYWlyKSAtIAogICAgICAgICAgICAgICAgIHN1bShzLnF0eV9kcCkg LSAKICAgICAgICAgICAgICAgICBzdW0ocy5xdHlfb3V0X2dvb2RzKSArCgkJ IChzZWxlY3QgY29hbGVzY2Uoc3VtKG91dF9xdHkpLDApOjpudW1lcmljCgkJ IGZyb20gZ2lyX291dHN0YW5kaW5nCiAgICAgICAgICAgICAgICAgd2hlcmUg Y2x1c3Rlcl9icm4gPSBici5jbHVzdGVyX2NvZGUKICAgICAgICAgICAgICAg ICBhbmQgc2t1ID0gcy5za3UKICAgICAgICAgICAgICAgICBhbmQgc3RrdHlw ZV9jb2RlID0gcy5zdGt0eXBlX2NvZGUpCiAgICAgICAgICAgICAgICApIDwg MCAKICAgICAgICAgIHRoZW4gYWJzKHN1bShzLnF0eV9vbl9oYW5kKSArIAog ICAgICAgICAgICAgICBzdW0ocy5xdHlfaW5fZ29vZHMgLSBzLnF0eV9pbl9z dXBwICsgcy5xdHlfb25fcmVwYWlyKSAtIAogICAgICAgICAgICAgICBzdW0o cy5xdHlfZHApIC0gCiAgICAgICAgICAgICAgIHN1bShzLnF0eV9vdXRfZ29v ZHMpICsKICAgICAgICAgICAgICAgKHNlbGVjdCBjb2FsZXNjZShzdW0ob3V0 X3F0eSksMCk6Om51bWVyaWMKICAgICAgICAgICAgICAgZnJvbSBnaXJfb3V0 c3RhbmRpbmcKICAgICAgICAgICAgICAgd2hlcmUgY2x1c3Rlcl9icm4gPSBi ci5jbHVzdGVyX2NvZGUKICAgICAgICAgICAgICAgYW5kIHNrdSA9IHMuc2t1 CiAgICAgICAgICAgICAgIGFuZCBzdGt0eXBlX2NvZGUgPSBzLnN0a3R5cGVf Y29kZSkKCQkgICkgCiAgICAgICAgICBlbHNlIDAgCiAgICAgIGVuZCBBUyBP UkRFUl9SUVJELAogICAgICAoICAgU0VMRUNUICBjb2FsZXNjZShzdW0oay5x dHlfb25faGFuZCksMCkKICAgICAgICAgIEZST00gICAgc3Rtc3Rfc2t1IGss IAogICAgICAgICAgICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rlc2NyIGIKICAg ICAgICAgIFdIRVJFICAgay5icm5fY29kZSA9IGIuYnJuX2NvZGUKICAgICAg ICAgIEFORCAgICAgay5za3UgPSBzLnNrdQogICAgICAgICAgQU5EICAgICBr LnN0a3R5cGVfY29kZSA9IHMuc3RrdHlwZV9jb2RlCiAgICAgICAgICBBTkQg ICAgIGIuYnJuX2NvZGUgPD4gIGIuY2x1c3Rlcl9jb2RlCiAgICAgICAgICBB TkQgICAgIGIuY2x1c3Rlcl9jb2RlID0gIGJyLmNsdXN0ZXJfY29kZQogICAg ICAgICAgQU5EICAgICBrLmZwcF9jb2RlID0gJzIwMDQwOCcKICAgICAgKSBB UyBCUl9TT0gKRlJPTSAgIHN0bXN0X3NrdSBzLCAKICAgICAgIG1hc3Rlcl9i cmFuY2hfZGVzY3IgYnIsCiAgICAgICBtYXN0ZXJfc2t1X2Rlc2NyIGksCiAg ICAgICBvbGRfc2t1IG9zCldIRVJFICBzLnNrdSA9IGkuc2t1CkFORCAgICBz LmJybl9jb2RlID0gYnIuYnJuX2NvZGUKQU5EICAgIHMuZnBwX2NvZGUgPSAn MjAwNDA4JwpBTkQgICAgcy5ncm91cF9jb2RlID0gaS5ncm91cF9jb2RlCkFO RCAgICBpLnNrdSA9IG9zLnNrdQpBTkQgICAgYnIuY2x1c3Rlcl9jb2RlID0g b3MuY2x1c3Rlcl9icm4KR1JPVVAgQlkgcy5za3UsCiAgICAgICAgIHMuc3Rr dHlwZV9jb2RlLAogICAgICAgICBpLnNrdV9kZXNjciwKICAgICAgICAgYnIu Y2x1c3Rlcl9jb2RlLAogICAgICAgICBici5jbHVzdGVyX2Rlc2NyCkhBVklO RyAoKHN1bShzLnF0eV9vbl9oYW5kKSArIHN1bShzLnF0eV9pbl9nb29kcykg LSBzdW0ocy5xdHlfZHApIC0gc3VtKHMucXR5X291dF9nb29kcykpIDwgMCk7 Cg== --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: text/plain; name="explain_analyze_before.txt" Content-Disposition: attachment; filename="explain_analyze_before.txt" Content-Transfer-Encoding: 7bit Aggregate (cost=87597.84..89421.82 rows=2702 width=484) (actual time=22727.88..28164.74 rows=12040 loops=1) Filter: ((((sum(qty_on_hand) + sum(qty_in_goods)) - sum(qty_dp)) - sum(qty_out_goods)) < 0::numeric) -> Group (cost=87597.84..88003.17 rows=27022 width=484) (actual time=22727.45..23242.01 rows=42705 loops=1) -> Sort (cost=87597.84..87665.40 rows=27022 width=484) (actual time=22727.43..22756.74 rows=42705 loops=1) Sort Key: s.sku, s.stktype_code, i.sku_descr, br.cluster_code, br.cluster_descr -> Merge Join (cost=84388.96..85608.78 rows=27022 width=484) (actual time=20303.41..21814.25 rows=42705 loops=1) Merge Cond: (("outer".group_code = "inner".group_code) AND ("outer".sku = "inner".sku)) -> Sort (cost=64472.34..64489.67 rows=6930 width=388) (actual time=16503.56..16530.23 rows=42705 loops=1) Sort Key: s.group_code, os.sku -> Merge Join (cost=63006.13..64030.25 rows=6930 width=388) (actual time=14394.48..15794.71 rows=42705 loops=1) Merge Cond: (("outer".cluster_brn = "inner".cluster_code) AND ("outer".sku = "inner".sku)) -> Index Scan using old_sku_uidx1 on old_sku os (cost=0.00..797.79 rows=17799 width=64) (actual time=0.02..47.66 rows=17799 loops=1) -> Sort (cost=63006.13..63045.07 rows=15574 width=324) (actual time=14393.77..14556.50 rows=132703 loops=1) Sort Key: br.cluster_code, s.sku -> Merge Join (cost=61645.75..61921.64 rows=15574 width=324) (actual time=4862.56..6078.94 rows=132703 loops=1) Merge Cond: ("outer".brn_code = "inner".brn_code) -> Sort (cost=61587.79..61626.73 rows=15574 width=228) (actual time=4859.23..5043.43 rows=132703 loops=1) Sort Key: s.brn_code -> Index Scan using stmst_sku_idx4 on stmst_sku s (cost=0.00..60503.30 rows=15574 width=228) (actual time=0.07..1078.30 rows=132703 loops=1) Index Cond: (fpp_code = '200408'::text) -> Sort (cost=57.96..59.62 rows=667 width=96) (actual time=3.26..91.93 rows=133005 loops=1) Sort Key: br.brn_code -> Seq Scan on master_branch_descr br (cost=0.00..26.67 rows=667 width=96) (actual time=0.02..1.13 rows=667 loops=1) -> Sort (cost=19916.61..20306.53 rows=155968 width=96) (actual time=3797.71..3914.26 rows=184223 loops=1) Sort Key: i.group_code, i.sku -> Seq Scan on master_sku_descr i (cost=0.00..6463.68 rows=155968 width=96) (actual time=0.01..293.74 rows=155968 loops=1) SubPlan -> Aggregate (cost=6.02..6.02 rows=1 width=8) (actual time=0.04..0.04 rows=1 loops=14456) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..6.01 rows=1 width=8) (actual time=0.03..0.03 rows=0 loops=14456) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=6.02..6.02 rows=1 width=8) (actual time=0.04..0.04 rows=1 loops=14456) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..6.01 rows=1 width=8) (actual time=0.03..0.03 rows=0 loops=14456) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=6.02..6.02 rows=1 width=8) (actual time=0.03..0.03 rows=1 loops=12031) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..6.01 rows=1 width=8) (actual time=0.03..0.03 rows=0 loops=12031) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=11.96..11.96 rows=1 width=82) (actual time=0.16..0.16 rows=1 loops=14456) -> Nested Loop (cost=0.00..11.95 rows=1 width=82) (actual time=0.08..0.15 rows=3 loops=14456) -> Index Scan using stmst_sku_idx3 on stmst_sku k (cost=0.00..6.02 rows=1 width=50) (actual time=0.06..0.08 rows=3 loops=14456) Index Cond: ((fpp_code = '200408'::text) AND (sku = $1) AND (stktype_code = $2)) -> Index Scan using master_branch_descr_pkey on master_branch_descr b (cost=0.00..5.92 rows=1 width=32) (actual time=0.02..0.02 rows=1 loops=42705) Index Cond: ("outer".brn_code = b.brn_code) Filter: ((brn_code <> cluster_code) AND (cluster_code = $0)) Total runtime: 28255.12 msec (44 rows) --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: text/plain; name="explain_after.txt" Content-Disposition: attachment; filename="explain_after.txt" Content-Transfer-Encoding: 7bit Aggregate (cost=316107.28..316114.91 rows=11 width=322) Filter: ((((sum(qty_on_hand) + sum(qty_in_goods)) - sum(qty_dp)) - sum(qty_out_goods)) < 0::numeric) -> Group (cost=316107.28..316108.98 rows=113 width=322) -> Sort (cost=316107.28..316107.57 rows=113 width=322) Sort Key: s.sku, s.stktype_code, i.sku_descr, br.cluster_code, br.cluster_descr -> Hash Join (cost=308622.49..316103.43 rows=113 width=322) Hash Cond: ("outer".sku = "inner".sku) Join Filter: ("inner".group_code = "outer".group_code) -> Seq Scan on master_sku_descr i (cost=0.00..6467.08 rows=156008 width=96) -> Hash (cost=308618.04..308618.04 rows=1781 width=226) -> Hash Join (cost=1698.78..308618.04 rows=1781 width=226) Hash Cond: ("outer".sku = "inner".sku) Join Filter: ("outer".brn_code = "inner".brn_code) -> Seq Scan on stmst_sku s (cost=0.00..284677.69 rows=356150 width=106) Filter: (fpp_code = '200408'::text) -> Hash (cost=1550.41..1550.41 rows=59347 width=120) -> Merge Join (cost=57.89..1550.41 rows=59347 width=120) Merge Cond: ("outer".cluster_brn = "inner".cluster_code) -> Index Scan using old_sku_uidx1 on old_sku os (cost=0.00..702.79 rows=17822 width=24) -> Sort (cost=57.89..59.56 rows=666 width=96) Sort Key: br.cluster_code -> Seq Scan on master_branch_descr br (cost=0.00..26.66 rows=666 width=96) SubPlan -> Aggregate (cost=23.73..23.73 rows=1 width=8) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..23.70 rows=6 width=8) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=23.73..23.73 rows=1 width=8) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..23.70 rows=6 width=8) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=23.73..23.73 rows=1 width=8) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..23.70 rows=6 width=8) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=32.16..32.16 rows=1 width=50) -> Merge Join (cost=32.11..32.15 rows=1 width=50) Merge Cond: ("outer".brn_code = "inner".brn_code) -> Sort (cost=14.38..14.39 rows=3 width=32) Sort Key: b.brn_code -> Index Scan using master_branch_descr_idx6 on master_branch_descr b (cost=0.00..14.35 rows=3 width=32) Index Cond: (cluster_code = $0) Filter: (brn_code <> cluster_code) -> Sort (cost=17.73..17.74 rows=4 width=18) Sort Key: k.brn_code -> Index Scan using stmst_sku_idx3 on stmst_sku k (cost=0.00..17.69 rows=4 width=18) Index Cond: ((fpp_code = '200408'::text) AND (sku = $1) AND (stktype_code = $2)) (44 rows) --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: text/plain; name="explain_analyze_after_hashjoin_off.txt" Content-Disposition: attachment; filename="explain_analyze_after_hashjoin_off.txt" Content-Transfer-Encoding: 7bit Aggregate (cost=354420.02..354427.65 rows=11 width=322) (actual time=246825.06..316125.53 rows=12050 loops=1) Filter: ((((sum(qty_on_hand) + sum(qty_in_goods)) - sum(qty_dp)) - sum(qty_out_goods)) < 0::numeric) -> Group (cost=354420.02..354421.72 rows=113 width=322) (actual time=246701.96..247283.96 rows=42930 loops=1) -> Sort (cost=354420.02..354420.30 rows=113 width=322) (actual time=246701.94..246736.97 rows=42930 loops=1) Sort Key: s.sku, s.stktype_code, i.sku_descr, br.cluster_code, br.cluster_descr -> Merge Join (cost=354298.16..354416.17 rows=113 width=322) (actual time=245205.55..245634.53 rows=42930 loops=1) Merge Cond: (("outer".brn_code = "inner".brn_code) AND ("outer".cluster_brn = "inner".cluster_code)) -> Sort (cost=354240.27..354296.76 rows=22595 width=226) (actual time=245179.07..245205.75 rows=42930 loops=1) Sort Key: s.brn_code, os.cluster_brn -> Merge Join (cost=348924.92..352606.20 rows=22595 width=226) (actual time=241551.96..244357.21 rows=42930 loops=1) Merge Cond: ("outer".sku = "inner".sku) -> Merge Join (cost=348924.92..351824.65 rows=22595 width=202) (actual time=241500.21..243397.42 rows=132883 loops=1) Merge Cond: (("outer".sku = "inner".sku) AND ("outer".group_code = "inner".group_code)) -> Sort (cost=329001.17..329891.54 rows=356150 width=106) (actual time=238575.25..238742.16 rows=132883 loops=1) Sort Key: s.sku, s.group_code -> Seq Scan on stmst_sku s (cost=0.00..284677.69 rows=356150 width=106) (actual time=219190.28..235315.66 rows=132883 loops=1) Filter: (fpp_code = '200408'::text) -> Sort (cost=19923.75..20313.77 rows=156008 width=96) (actual time=2924.57..3048.34 rows=185259 loops=1) Sort Key: i.sku, i.group_code -> Seq Scan on master_sku_descr i (cost=0.00..6467.08 rows=156008 width=96) (actual time=1.62..976.63 rows=156008 loops=1) -> Index Scan using old_sku_idx1 on old_sku os (cost=0.00..398.04 rows=17822 width=24) (actual time=49.45..209.45 rows=46294 loops=1) -> Sort (cost=57.89..59.56 rows=666 width=96) (actual time=26.41..54.70 rows=43232 loops=1) Sort Key: br.brn_code, br.cluster_code -> Seq Scan on master_branch_descr br (cost=0.00..26.66 rows=666 width=96) (actual time=8.04..24.21 rows=666 loops=1) SubPlan -> Aggregate (cost=23.73..23.73 rows=1 width=8) (actual time=0.06..0.06 rows=1 loops=14481) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..23.70 rows=6 width=8) (actual time=0.04..0.05 rows=0 loops=14481) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=23.73..23.73 rows=1 width=8) (actual time=0.04..0.04 rows=1 loops=14481) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..23.70 rows=6 width=8) (actual time=0.03..0.03 rows=0 loops=14481) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=23.73..23.73 rows=1 width=8) (actual time=0.03..0.03 rows=1 loops=12042) -> Index Scan using gir_oustanding_idx1 on gir_outstanding (cost=0.00..23.70 rows=6 width=8) (actual time=0.03..0.03 rows=0 loops=12042) Index Cond: ((cluster_brn = $0) AND (sku = $1) AND (stktype_code = $2)) -> Aggregate (cost=32.16..32.16 rows=1 width=50) (actual time=4.53..4.53 rows=1 loops=14481) -> Merge Join (cost=32.11..32.15 rows=1 width=50) (actual time=4.45..4.52 rows=3 loops=14481) Merge Cond: ("outer".brn_code = "inner".brn_code) -> Sort (cost=14.38..14.39 rows=3 width=32) (actual time=3.84..4.01 rows=271 loops=14481) Sort Key: b.brn_code -> Index Scan using master_branch_descr_idx6 on master_branch_descr b (cost=0.00..14.35 rows=3 width=32) (actual time=0.02..2.14 rows=564 loops=14481) Index Cond: (cluster_code = $0) Filter: (brn_code <> cluster_code) -> Sort (cost=17.73..17.74 rows=4 width=18) (actual time=0.14..0.14 rows=3 loops=14481) Sort Key: k.brn_code -> Index Scan using stmst_sku_idx3 on stmst_sku k (cost=0.00..17.69 rows=4 width=18) (actual time=0.08..0.11 rows=3 loops=14481) Index Cond: ((fpp_code = '200408'::text) AND (sku = $1) AND (stktype_code = $2)) Total runtime: 316245.16 msec (47 rows) --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: text/plain; name="settings.txt" Content-Disposition: attachment; filename="settings.txt" Content-Transfer-Encoding: 7bit shared_buffers = 110592 wal_buffers = 400 sort_mem = 30720 vacuum_mem = 10240 checkpoint_segments = 30 commit_delay = 5000 commit_siblings = 100 effective_cache_size = 201413 --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: application/octet-stream; name="stmst_sku.sql" Content-Disposition: attachment; filename="stmst_sku.sql" Content-Transfer-Encoding: base64 ICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5zdG1zdF9za3UiCiAg ICAgICAgICBDb2x1bW4gICAgICAgICAgfCAgICAgICAgIFR5cGUgICAgICAg ICB8IE1vZGlmaWVycyAKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLQogZnBwX2NvZGUgICAg ICAgICAgICAgICAgIHwgdGV4dCAgICAgICAgICAgICAgICAgfCBub3QgbnVs bAogYnJuX2NvZGUgICAgICAgICAgICAgICAgIHwgdGV4dCAgICAgICAgICAg ICAgICAgfCBub3QgbnVsbAogc2t1ICAgICAgICAgICAgICAgICAgICAgIHwg dGV4dCAgICAgICAgICAgICAgICAgfCBub3QgbnVsbAogZ3JvdXBfY29kZSAg ICAgICAgICAgICAgIHwgdGV4dCAgICAgICAgICAgICAgICAgfCBub3QgbnVs bAogcXR5X29uX2hhbmQgICAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAg ICAgICAgfCAKIHF0eV9vbl9pbmQgICAgICAgICAgICAgICB8IG51bWVyaWMo MTYsMykgICAgICAgIHwgCiBxdHlfb25fcmVwYWlyICAgICAgICAgICAgfCBu dW1lcmljKDE2LDMpICAgICAgICB8IAogcXR5X29uX2xvYW4gICAgICAgICAg ICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAKIHF0eV9pbl9icm4gICAg ICAgICAgICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBxdHlfb3V0 X2JybiAgICAgICAgICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAog cXR5X2luX2N1cyAgICAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAgICAg ICAgfCAKIHF0eV9vdXRfY3VzICAgICAgICAgICAgICB8IG51bWVyaWMoMTYs MykgICAgICAgIHwgCiBxdHlfaW5fc3VwcCAgICAgICAgICAgICAgfCBudW1l cmljKDE2LDMpICAgICAgICB8IAogcXR5X291dF9zdXBwICAgICAgICAgICAg IHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAKIHF0eV9pbl9vdGggICAgICAg ICAgICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBxdHlfb3V0X290 aCAgICAgICAgICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAogcXR5 X2luX2dvb2RzICAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAg fCAKIHF0eV9vdXRfZ29vZHMgICAgICAgICAgICB8IG51bWVyaWMoMTYsMykg ICAgICAgIHwgCiBzdGt0eXBlX2NvZGUgICAgICAgICAgICAgfCBjaGFyYWN0 ZXIgdmFyeWluZygyKSB8IAogdGF4X2NvZGUgICAgICAgICAgICAgICAgIHwg dGV4dCAgICAgICAgICAgICAgICAgfCAKIGN1cnJfY3N0ICAgICAgICAgICAg ICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBjdXJyX2NzdF9sICAg ICAgICAgICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAogY3Vycl9y c3BfY2EgICAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAK IGN1cnJfcnNwX2NhX2wgICAgICAgICAgICB8IG51bWVyaWMoMTYsMykgICAg ICAgIHwgCiBjdXJyX3JzcF9jciAgICAgICAgICAgICAgfCBudW1lcmljKDE2 LDMpICAgICAgICB8IAogY3Vycl9yc3BfY3JfbCAgICAgICAgICAgIHwgbnVt ZXJpYygxNiwzKSAgICAgICAgfCAKIG10aF9zbHNfcXR5ICAgICAgICAgICAg ICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBtdGhfc2xzX2NzdCAgICAg ICAgICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAogbXRoX3Nsc19j c3RfbCAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAKIG10 aF9zbHNfZGlzYyAgICAgICAgICAgICB8IG51bWVyaWMoMTYsMykgICAgICAg IHwgCiBtdGhfc2xzX2Rpc2NfbCAgICAgICAgICAgfCBudW1lcmljKDE2LDMp ICAgICAgICB8IAogbXRoX3Nsc19uZXR0X2V4Y2wgICAgICAgIHwgbnVtZXJp YygxNiwzKSAgICAgICAgfCAKIG10aF9zbHNfbmV0dF9leGNsX2wgICAgICB8 IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBtYXhfaG9sZF9xdHkgICAgICAg ICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAogbWluX2hvbGRfcXR5 ICAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAKIHF0eV9v bl9ob2xkICAgICAgICAgICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwg CiBxdHlfZHAgICAgICAgICAgICAgICAgICAgfCBudW1lcmljKDE2LDMpICAg ICAgICB8IAogbXRoX3Nsc19xdHlfdW5kICAgICAgICAgIHwgbnVtZXJpYygx NiwzKSAgICAgICAgfCBkZWZhdWx0IDAKIG10aF9zbHNfY3N0X3VuZCAgICAg ICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgZGVmYXVsdCAwCiBtdGhf c2xzX2NzdF9sX3VuZCAgICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8 IGRlZmF1bHQgMAogbXRoX3Nsc19kaXNjX3VuZCAgICAgICAgIHwgbnVtZXJp YygxNiwzKSAgICAgICAgfCBkZWZhdWx0IDAKIG10aF9zbHNfZGlzY19sX3Vu ZCAgICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgZGVmYXVsdCAwCiBt dGhfc2xzX25ldHRfZXhjbF91bmQgICAgfCBudW1lcmljKDE2LDMpICAgICAg ICB8IGRlZmF1bHQgMAogbXRoX3Nsc19uZXR0X2V4Y2xfbF91bmQgIHwgbnVt ZXJpYygxNiwzKSAgICAgICAgfCBkZWZhdWx0IDAKIHF0eV9pbl9icl9kb21i ICAgICAgICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgZGVmYXVsdCAw CiBxdHlfb3V0X2N1c19icl9vd25fZGVsICAgfCBudW1lcmljKDE2LDMpICAg ICAgICB8IGRlZmF1bHQgMAogbWF0X3Nsc19xdHkgICAgICAgICAgICAgIHwg bnVtZXJpYygxNiwzKSAgICAgICAgfCAKIHl0ZF9zbHNfcXR5ICAgICAgICAg ICAgICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBtYXRfc2xzX2NzdCAg ICAgICAgICAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAogeXRkX3Ns c19jc3QgICAgICAgICAgICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAK IG1hdF9zbHNfZGlzYyAgICAgICAgICAgICB8IG51bWVyaWMoMTYsMykgICAg ICAgIHwgCiB5dGRfc2xzX2Rpc2MgICAgICAgICAgICAgfCBudW1lcmljKDE2 LDMpICAgICAgICB8IAogbWF0X3Nsc19uZXR0X2V4Y2wgICAgICAgIHwgbnVt ZXJpYygxNiwzKSAgICAgICAgfCAKIHl0ZF9zbHNfbmV0dF9leGNsICAgICAg ICB8IG51bWVyaWMoMTYsMykgICAgICAgIHwgCiBseV9tdGhfc2xzX25ldHRf ZXhjbCAgICAgfCBudW1lcmljKDE2LDMpICAgICAgICB8IAogbHlfeXRkX3Ns c19uZXR0X2V4Y2wgICAgIHwgbnVtZXJpYygxNiwzKSAgICAgICAgfCAKIHN0 a190dXJuX3F0eV9vbl9oYW5kX2NzdCB8IG51bWVyaWMoMTYsMykgICAgICAg IHwgCiBub19tdGhzX2hpc3RvcnkgICAgICAgICAgfCBpbnRlZ2VyICAgICAg ICAgICAgICB8IGRlZmF1bHQgMApJbmRleGVzOiBzdG1zdF9za3VfcGsgcHJp bWFyeSBrZXkgYnRyZWUgKGZwcF9jb2RlLCBicm5fY29kZSwgc2t1KSwKICAg ICAgICAgc3Rtc3Rfc2t1X2lkeDUgdW5pcXVlIGJ0cmVlIChmcHBfY29kZSwg YnJuX2NvZGUsIHNrdSwgZ3JvdXBfY29kZSwgc3RrdHlwZV9jb2RlKSwKICAg ICAgICAgc3Rtc3RfZmZwX2Jybl9za3VfaWR4IGJ0cmVlIChmcHBfY29kZSwg YnJuX2NvZGUsIHNrdSksCiAgICAgICAgIHN0bXN0X3NrdV9pZHgxIGJ0cmVl IChza3UsIGJybl9jb2RlKSwKICAgICAgICAgc3Rtc3Rfc2t1X2lkeDIgYnRy ZWUgKGZwcF9jb2RlLCBicm5fY29kZSksCiAgICAgICAgIHN0bXN0X3NrdV9p ZHgzIGJ0cmVlIChmcHBfY29kZSwgc2t1LCBzdGt0eXBlX2NvZGUpLAogICAg ICAgICBzdG1zdF9za3VfaWR4NCBidHJlZSAoZnBwX2NvZGUpLAogICAgICAg ICBzdG1zdF9za3VfaWR4NyBidHJlZSAoYnJuX2NvZGUpLAogICAgICAgICBz dG1zdF9za3VfaWR4OCBidHJlZSAoc3RrdHlwZV9jb2RlKSwKICAgICAgICAg c3Rtc3Rfc2t1X3VpZHgxIGJ0cmVlIChmcHBfY29kZSwgc2t1LCBicm5fY29k ZSwgc3RrdHlwZV9jb2RlKQpGb3JlaWduIEtleSBjb25zdHJhaW50czogc3Rt c3Rfc2t1X2ZrIEZPUkVJR04gS0VZIChncm91cF9jb2RlLCBza3UpIFJFRkVS RU5DRVMgaXRlbShncm91cF9jb2RlLCBza3UpIE9OIFVQREFURSBOTyBBQ1RJ T04gT04gREVMRVRFIE5PIEFDVElPTgoKICBjb3VudCAgCi0tLS0tLS0tLQog MzExNTAxNQooMSByb3cpCgo= --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: application/octet-stream; name="old_sku.sql" Content-Disposition: attachment; filename="old_sku.sql" Content-Transfer-Encoding: base64 ICAgICBUYWJsZSAicHVibGljLm9sZF9za3UiCiAgIENvbHVtbiAgICB8IFR5 cGUgfCBNb2RpZmllcnMgCi0tLS0tLS0tLS0tLS0rLS0tLS0tKy0tLS0tLS0t LS0tCiBjbHVzdGVyX2JybiB8IHRleHQgfCAKIHNrdSAgICAgICAgIHwgdGV4 dCB8IApJbmRleGVzOiBvbGRfc2t1X3VpZHgxIHVuaXF1ZSBidHJlZSAoY2x1 c3Rlcl9icm4sIHNrdSksCiAgICAgICAgIG9sZF9za3VfaWR4MSBidHJlZSAo c2t1KQoKIGNvdW50IAotLS0tLS0tCiAxNzgyMgooMSByb3cpCgo= --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: application/octet-stream; name="master_sku_descr.sql" Content-Disposition: attachment; filename="master_sku_descr.sql" Content-Transfer-Encoding: base64 ICBUYWJsZSAicHVibGljLm1hc3Rlcl9za3VfZGVzY3IiCiAgICAgQ29sdW1u ICAgICB8IFR5cGUgfCBNb2RpZmllcnMgCi0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tKy0tLS0tLS0tLS0tCiBncm91cF9jb2RlICAgICB8IHRleHQgfCAKIHNr dSAgICAgICAgICAgIHwgdGV4dCB8IAogc2t1X2Rlc2NyICAgICAgfCB0ZXh0 IHwgCiBkZXBfY29kZSAgICAgICB8IHRleHQgfCAKIGRlcF9kZXNjciAgICAg IHwgdGV4dCB8IAogY2F0X2NvZGUgICAgICAgfCB0ZXh0IHwgCiBjYXRfZGVz Y3IgICAgICB8IHRleHQgfCAKIHN1YmNhdF9jb2RlICAgIHwgdGV4dCB8IAog c3ViY2F0X2Rlc2NyICAgfCB0ZXh0IHwgCiBjb250cm9sX2NvZGUgICB8IHRl eHQgfCAKIGNvbnRyb2xfZGVzY3IgIHwgdGV4dCB8IAogc3VwcGxpZXJfY29k ZSAgfCB0ZXh0IHwgCiBzdXBwbGllcl9kZXNjciB8IHRleHQgfCAKSW5kZXhl czogbWFzdGVyX3NrdV9kZXNjcl91aWR4MSB1bmlxdWUgYnRyZWUgKHNrdSwg Z3JvdXBfY29kZSksCiAgICAgICAgIG1hc3Rlcl9za3VfZGVzY3JfaWR4MSBi dHJlZSAoZ3JvdXBfY29kZSwgc2t1LCBjb250cm9sX2NvZGUpLAogICAgICAg ICBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDEwIGJ0cmVlIChzdWJjYXRfY29kZSks CiAgICAgICAgIG1hc3Rlcl9za3VfZGVzY3JfaWR4MTEgYnRyZWUgKGNvbnRy b2xfY29kZSksCiAgICAgICAgIG1hc3Rlcl9za3VfZGVzY3JfaWR4MTIgYnRy ZWUgKGNvbnRyb2xfZGVzY3IpLAogICAgICAgICBtYXN0ZXJfc2t1X2Rlc2Ny X2lkeDEzIGJ0cmVlIChzdXBwbGllcl9jb2RlKSwKICAgICAgICAgbWFzdGVy X3NrdV9kZXNjcl9pZHgxNCBidHJlZSAoc3VwcGxpZXJfZGVzY3IpLAogICAg ICAgICBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDIgYnRyZWUgKGdyb3VwX2NvZGUs IHNrdSwgZGVwX2NvZGUsIGNhdF9jb2RlLCBzdWJjYXRfY29kZSwgY29udHJv bF9jb2RlKSwKICAgICAgICAgbWFzdGVyX3NrdV9kZXNjcl9pZHgzIGJ0cmVl IChncm91cF9jb2RlKSwKICAgICAgICAgbWFzdGVyX3NrdV9kZXNjcl9pZHg0 IGJ0cmVlIChza3VfZGVzY3IpLAogICAgICAgICBtYXN0ZXJfc2t1X2Rlc2Ny X2lkeDUgYnRyZWUgKGRlcF9jb2RlKSwKICAgICAgICAgbWFzdGVyX3NrdV9k ZXNjcl9pZHg2IGJ0cmVlIChncm91cF9jb2RlLCBza3UpLAogICAgICAgICBt YXN0ZXJfc2t1X2Rlc2NyX2lkeDcgYnRyZWUgKGRlcF9kZXNjciksCiAgICAg ICAgIG1hc3Rlcl9za3VfZGVzY3JfaWR4OCBidHJlZSAoY2F0X2NvZGUpLAog ICAgICAgICBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDkgYnRyZWUgKHN1YmNhdF9k ZXNjciksCiAgICAgICAgIG1hc3Rlcl9za3VfZGVzY3JfdWlkeDMgYnRyZWUg KHNrdSkKCiBjb3VudCAgCi0tLS0tLS0tCiAxNTYwMDgKKDEgcm93KQoK --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: application/octet-stream; name="master_branch_descr.sql" Content-Disposition: attachment; filename="master_branch_descr.sql" Content-Transfer-Encoding: base64 VGFibGUgInB1YmxpYy5tYXN0ZXJfYnJhbmNoX2Rlc2NyIgogICAgIENvbHVt biAgICAgfCBUeXBlIHwgTW9kaWZpZXJzIAotLS0tLS0tLS0tLS0tLS0tKy0t LS0tLSstLS0tLS0tLS0tLQogYnJuX2NvZGUgICAgICAgfCB0ZXh0IHwgbm90 IG51bGwKIGJybl9kZXNjciAgICAgIHwgdGV4dCB8IAogY291bnRyeV9jb2Rl ICAgfCB0ZXh0IHwgCiBjb3VudHJ5X2Rlc2NyICB8IHRleHQgfCAKIGNsdXN0 ZXJfY29kZSAgIHwgdGV4dCB8IAogY2x1c3Rlcl9kZXNjciAgfCB0ZXh0IHwg CiBicmFuZF9jb2RlICAgICB8IHRleHQgfCAKIGJyYW5kX2Rlc2NyICAgIHwg dGV4dCB8IAogY2hhaW5fY29kZSAgICAgfCB0ZXh0IHwgCiBjaGFpbl9kZXNj ciAgICB8IHRleHQgfCAKIHNidV9jb2RlICAgICAgIHwgdGV4dCB8IAogc2J1 X2Rlc2NyICAgICAgfCB0ZXh0IHwgCiBncm91cF9jb2RlICAgICB8IHRleHQg fCAKIGdyb3VwX2Rlc2NyICAgIHwgdGV4dCB8IAogcmVnaW9uX2NvZGUgICAg fCB0ZXh0IHwgCiByZWdpb25fZGVzY3IgICB8IHRleHQgfCAKIGRpdmlzaW9u X2NvZGUgIHwgdGV4dCB8IAogZGl2aXNpb25fZGVzY3IgfCB0ZXh0IHwgCklu ZGV4ZXM6IG1hc3Rlcl9icmFuY2hfZGVzY3JfcGtleSBwcmltYXJ5IGtleSBi dHJlZSAoYnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rlc2Ny X3VpZHgxIHVuaXF1ZSBidHJlZSAoYnJuX2NvZGUpLAogICAgICAgICBtYXN0 ZXJfYnJhbmNoX2Rlc2NyX3VpZHgyIHVuaXF1ZSBidHJlZSAoYnJuX2NvZGUs IGJybl9kZXNjciksCiAgICAgICAgIG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4 MSBidHJlZSAoYnJuX2NvZGUsIGJybl9kZXNjciwgY291bnRyeV9jb2RlLCBj b3VudHJ5X2Rlc2NyKSwKICAgICAgICAgbWFzdGVyX2JyYW5jaF9kZXNjcl9p ZHgxMCBidHJlZSAoY2hhaW5fY29kZSwgYnJuX2NvZGUpLAogICAgICAgICBt YXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDExIGJ0cmVlIChjaGFpbl9kZXNjciwg YnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDEy IGJ0cmVlIChzYnVfY29kZSwgYnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJf YnJhbmNoX2Rlc2NyX2lkeDEzIGJ0cmVlIChzYnVfZGVzY3IsIGJybl9jb2Rl KSwKICAgICAgICAgbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgxNCBidHJlZSAo Z3JvdXBfY29kZSwgYnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJfYnJhbmNo X2Rlc2NyX2lkeDE1IGJ0cmVlIChncm91cF9kZXNjciwgYnJuX2NvZGUpLAog ICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDE2IGJ0cmVlIChyZWdp b25fY29kZSwgYnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rl c2NyX2lkeDE3IGJ0cmVlIChyZWdpb25fZGVzY3IsIGJybl9jb2RlKSwKICAg ICAgICAgbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgxOCBidHJlZSAoZGl2aXNp b25fY29kZSwgYnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rl c2NyX2lkeDE5IGJ0cmVlIChkaXZpc2lvbl9kZXNjciwgYnJuX2NvZGUpLAog ICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDIgYnRyZWUgKGJybl9j b2RlLCBicm5fZGVzY3IsIGNsdXN0ZXJfY29kZSwgY2x1c3Rlcl9kZXNjciks CiAgICAgICAgIG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4MyBidHJlZSAoYnJu X2Rlc2NyLCBicm5fY29kZSksCiAgICAgICAgIG1hc3Rlcl9icmFuY2hfZGVz Y3JfaWR4NCBidHJlZSAoY291bnRyeV9jb2RlLCBicm5fY29kZSksCiAgICAg ICAgIG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4NSBidHJlZSAoY291bnRyeV9k ZXNjciwgYnJuX2NvZGUpLAogICAgICAgICBtYXN0ZXJfYnJhbmNoX2Rlc2Ny X2lkeDYgYnRyZWUgKGNsdXN0ZXJfY29kZSwgYnJuX2NvZGUpLAogICAgICAg ICBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDcgYnRyZWUgKGNsdXN0ZXJfZGVz Y3IsIGJybl9jb2RlKSwKICAgICAgICAgbWFzdGVyX2JyYW5jaF9kZXNjcl9p ZHg4IGJ0cmVlIChicmFuZF9jb2RlLCBicm5fY29kZSksCiAgICAgICAgIG1h c3Rlcl9icmFuY2hfZGVzY3JfaWR4OSBidHJlZSAoYnJhbmRfZGVzY3IsIGJy bl9jb2RlKQoKIGNvdW50IAotLS0tLS0tCiAgIDY2NgooMSByb3cpCgo= --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc Content-Type: application/octet-stream; name="gir_outstanding.sql" Content-Disposition: attachment; filename="gir_outstanding.sql" Content-Transfer-Encoding: base64 ICAgICAgICAgICAgICBUYWJsZSAicHVibGljLmdpcl9vdXRzdGFuZGluZyIK ICAgICBDb2x1bW4gICAgIHwgICAgICAgICAgICBUeXBlICAgICAgICAgICAg IHwgTW9kaWZpZXJzIAotLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tCiBzdXBwX2NvZGUgICAgICB8 IHRleHQgICAgICAgICAgICAgICAgICAgICAgICB8IAogc3VwcF9uYW1lICAg ICAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAgICAgfCAKIHN1cHBfYnJu ICAgICAgIHwgdGV4dCAgICAgICAgICAgICAgICAgICAgICAgIHwgCiBvcmRf bm8gICAgICAgICB8IHRleHQgICAgICAgICAgICAgICAgICAgICAgICB8IAog ZHVlX2RhdGUgICAgICAgfCB0aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpvbmUg fCAKIHRvX2RhdGUgICAgICAgIHwgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6 b25lIHwgCiBncm91cF9jb2RlICAgICB8IHRleHQgICAgICAgICAgICAgICAg ICAgICAgICB8IAogYnJuX2NvZGUgICAgICAgfCB0ZXh0ICAgICAgICAgICAg ICAgICAgICAgICAgfCAKIGRlc2Nfc2hvcnQgICAgIHwgdGV4dCAgICAgICAg ICAgICAgICAgICAgICAgIHwgCiBjbHVzdGVyX2JybiAgICB8IHRleHQgICAg ICAgICAgICAgICAgICAgICAgICB8IAogY291bnRyeV9jb2RlICAgfCB0ZXh0 ICAgICAgICAgICAgICAgICAgICAgICAgfCAKIHJlcV9kb2Nfbm8gICAgIHwg aW50ZWdlciAgICAgICAgICAgICAgICAgICAgIHwgCiBvcHNfY29kZSAgICAg ICB8IHRleHQgICAgICAgICAgICAgICAgICAgICAgICB8IAogc2t1ICAgICAg ICAgICAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAgICAgfCAKIHN0ZF9k ZXNjciAgICAgIHwgdGV4dCAgICAgICAgICAgICAgICAgICAgICAgIHwgCiBh Y2RlX2NvZGUgICAgICB8IHRleHQgICAgICAgICAgICAgICAgICAgICAgICB8 IAogcmVxX3F0eSAgICAgICAgfCBkb3VibGUgcHJlY2lzaW9uICAgICAgICAg ICAgfCAKIGdydl9xdHkgICAgICAgIHwgZG91YmxlIHByZWNpc2lvbiAgICAg ICAgICAgIHwgCiBza3VsX3F0eSAgICAgICB8IGRvdWJsZSBwcmVjaXNpb24g ICAgICAgICAgICB8IAogcHJlZl9kYXRlICAgICAgfCB0aW1lc3RhbXAgd2l0 aG91dCB0aW1lIHpvbmUgfCAKIHNrdWxfZ3J2X3F0eSAgIHwgZG91YmxlIHBy ZWNpc2lvbiAgICAgICAgICAgIHwgCiBvdXRfcXR5ICAgICAgICB8IGRvdWJs ZSBwcmVjaXNpb24gICAgICAgICAgICB8IAogc2t1bF9vcmRfY29zdCAgfCBu dW1lcmljKDE2LDIpICAgICAgICAgICAgICAgfCAKIG91dF9jb3N0ICAgICAg IHwgbnVtZXJpYyAgICAgICAgICAgICAgICAgICAgIHwgCiBzdGt0eXBlX2Nv ZGUgICB8IGNoYXJhY3RlciB2YXJ5aW5nKDIpICAgICAgICB8IAogZ2lyX3R5 cGVfY29kZSAgfCB0ZXh0ICAgICAgICAgICAgICAgICAgICAgICAgfCAKIGdp cl90eXBlX2Rlc2NyIHwgdGV4dCAgICAgICAgICAgICAgICAgICAgICAgIHwg CkluZGV4ZXM6IGdpcl9vdXN0YW5kaW5nX2lkeDEgYnRyZWUgKGNsdXN0ZXJf YnJuLCBza3UsIHN0a3R5cGVfY29kZSkKCiBjb3VudCAKLS0tLS0tLQogIDY5 NTAKKDEgcm93KQoK --Multipart=_Tue__24_Aug_2004_10_32_40_+0200_maLgIszoscYKY=nc--