Query#: 0
select l_orderkey, l_linenumber, l_quantity, p_name, p_retailprice, ps_availqty, s_name  from lineitem, partsupp, part, supplier where p_partkey = ps_partkey and s_suppkey = ps_suppkey and l_partkey = ps_partkey and l_suppkey = ps_suppkey

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:48:41.028532
NOTICE: 100 results: 2008-09-09 10:48:59.553803
NOTICE: 1000 results: 2008-09-09 10:48:59.564182
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:50:16.913208
NOTICE: RUNTIME: 00:01:35.884676
Query#: 0, Run#: -1, memory: 1024.0, runtime: 95985.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:50:17.049388
NOTICE: 100 results: 2008-09-09 10:50:28.805716
NOTICE: 1000 results: 2008-09-09 10:50:28.811528
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:51:31.715485
NOTICE: RUNTIME: 00:01:14.666097
Query#: 0, Run#: 0, memory: 1024.0, runtime: 74688.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:51:31.775599
NOTICE: 100 results: 2008-09-09 10:51:41.926907
NOTICE: 1000 results: 2008-09-09 10:51:41.932651
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:52:53.275225
NOTICE: RUNTIME: 00:01:21.499626
Query#: 0, Run#: 1, memory: 1024.0, runtime: 81531.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:52:53.334373
NOTICE: 100 results: 2008-09-09 10:52:57.824072
NOTICE: 1000 results: 2008-09-09 10:52:57.8305
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:54:03.380548
NOTICE: RUNTIME: 00:01:10.046175
Query#: 0, Run#: 2, memory: 1024.0, runtime: 70062.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:54:03.435345
NOTICE: 100 results: 2008-09-09 10:54:07.648492
NOTICE: 1000 results: 2008-09-09 10:54:07.654498
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:55:03.565887
NOTICE: RUNTIME: 00:01:00.130542
Query#: 0, Run#: 3, memory: 1024.0, runtime: 60157.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:55:03.624572
NOTICE: 100 results: 2008-09-09 10:55:07.832289
NOTICE: 1000 results: 2008-09-09 10:55:07.838042
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:56:17.138279
NOTICE: RUNTIME: 00:01:13.513707
Query#: 0, Run#: 4, memory: 1024.0, runtime: 73531.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:56:17.189592
NOTICE: 100 results: 2008-09-09 10:56:22.353149
NOTICE: 1000 results: 2008-09-09 10:56:22.358939
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:57:33.074545
NOTICE: RUNTIME: 00:01:15.884953
Query#: 0, Run#: 5, memory: 1024.0, runtime: 75907.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:57:33.125857
NOTICE: 100 results: 2008-09-09 10:57:37.43516
NOTICE: 1000 results: 2008-09-09 10:57:37.441044
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:58:37.927905
NOTICE: RUNTIME: 00:01:04.802048
Query#: 0, Run#: 6, memory: 1024.0, runtime: 64828.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:58:37.977909
NOTICE: 100 results: 2008-09-09 10:58:42.281536
NOTICE: 1000 results: 2008-09-09 10:58:42.287267
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 10:59:50.813056
NOTICE: RUNTIME: 00:01:12.835147
Query#: 0, Run#: 7, memory: 1024.0, runtime: 72859.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 10:59:50.864232
NOTICE: 100 results: 2008-09-09 10:59:56.028569
NOTICE: 1000 results: 2008-09-09 10:59:56.034337
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 11:01:00.216802
NOTICE: RUNTIME: 00:01:09.35257
Query#: 0, Run#: 8, memory: 1024.0, runtime: 69360.0ms

Algorithm#: 0 = HYBRID_HASH_JOIN
MemoryAmount#: 0, memory: 1024.0
NOTICE: START: 2008-09-09 11:01:00.239693
NOTICE: 100 results: 2008-09-09 11:01:07.198799
NOTICE: 1000 results: 2008-09-09 11:01:07.204759
NOTICE: HJ HashTable Stats
intup = 10000	intupIOs = 0	in bytes written = 0	 in bytes total = 640000
outtup = 6000003	outtupIOs = 0	out bytes written = 0	out bytes total = 522126108
nbatch = 1	nfrozen = 0
NOTICE: # probes: 65615975	# buckets: 1024
NOTICE: Batch 0: 10000 inner tuples (100.0%) 640000 bytes (100.0%), 6000003 outer tuples (100.0%) 522126108 (100.0%) bytes, in memory
NOTICE: HJ HashTable Stats
intup = 800000	intupIOs = 1587624	in bytes written = 63070980	 in bytes total = 73162864
outtup = 6000003	outtupIOs = 11928052	out bytes written = 884821662	out bytes total = 866159688
nbatch = 128	nfrozen = 127
NOTICE: # probes: 24502969	# buckets: 2048
NOTICE: Batch 0: 6188 inner tuples (0.8%) 566140 bytes (0.8%), 35977 outer tuples (0.6%) 5194130 (0.6%) bytes, in memory
NOTICE: Batch 1: 6103 inner tuples (0.8%) 484856 bytes (0.7%), 53130 outer tuples (0.9%) 7882541 (0.9%) bytes, on disk
NOTICE: Batch 2: 6291 inner tuples (0.8%) 500016 bytes (0.7%), 40616 outer tuples (0.7%) 6027107 (0.7%) bytes, on disk
NOTICE: Batch 3: 6236 inner tuples (0.8%) 495524 bytes (0.7%), 43756 outer tuples (0.7%) 6491920 (0.7%) bytes, on disk
NOTICE: Batch 4: 6195 inner tuples (0.8%) 492304 bytes (0.7%), 48122 outer tuples (0.8%) 7139974 (0.8%) bytes, on disk
NOTICE: Batch 5: 6312 inner tuples (0.8%) 501668 bytes (0.7%), 33636 outer tuples (0.6%) 4993917 (0.6%) bytes, on disk
NOTICE: Batch 6: 6255 inner tuples (0.8%) 497436 bytes (0.7%), 36158 outer tuples (0.6%) 5366015 (0.6%) bytes, on disk
NOTICE: Batch 7: 6322 inner tuples (0.8%) 502752 bytes (0.7%), 33075 outer tuples (0.6%) 4903842 (0.6%) bytes, on disk
NOTICE: Batch 8: 6259 inner tuples (0.8%) 496880 bytes (0.7%), 33324 outer tuples (0.6%) 4943944 (0.6%) bytes, on disk
NOTICE: Batch 9: 6263 inner tuples (0.8%) 497776 bytes (0.7%), 46656 outer tuples (0.8%) 6926467 (0.8%) bytes, on disk
NOTICE: Batch 10: 6217 inner tuples (0.8%) 493992 bytes (0.7%), 37682 outer tuples (0.6%) 5590021 (0.6%) bytes, on disk
NOTICE: Batch 11: 6291 inner tuples (0.8%) 499948 bytes (0.7%), 33393 outer tuples (0.6%) 4951350 (0.6%) bytes, on disk
NOTICE: Batch 12: 6200 inner tuples (0.8%) 492340 bytes (0.7%), 35703 outer tuples (0.6%) 5292019 (0.6%) bytes, on disk
NOTICE: Batch 13: 6323 inner tuples (0.8%) 503024 bytes (0.7%), 67417 outer tuples (1.1%) 10007996 (1.2%) bytes, on disk
NOTICE: Batch 14: 6232 inner tuples (0.8%) 494856 bytes (0.7%), 60570 outer tuples (1.0%) 8985820 (1.0%) bytes, on disk
NOTICE: Batch 15: 6335 inner tuples (0.8%) 503356 bytes (0.7%), 37829 outer tuples (0.6%) 5612738 (0.6%) bytes, on disk
NOTICE: Batch 16: 6282 inner tuples (0.8%) 499596 bytes (0.7%), 37173 outer tuples (0.6%) 5516424 (0.6%) bytes, on disk
NOTICE: Batch 17: 6178 inner tuples (0.8%) 491132 bytes (0.7%), 31259 outer tuples (0.5%) 4638133 (0.5%) bytes, on disk
NOTICE: Batch 18: 6173 inner tuples (0.8%) 490868 bytes (0.7%), 34796 outer tuples (0.6%) 5162610 (0.6%) bytes, on disk
NOTICE: Batch 19: 6257 inner tuples (0.8%) 496624 bytes (0.7%), 53201 outer tuples (0.9%) 7894289 (0.9%) bytes, on disk
NOTICE: Batch 20: 6138 inner tuples (0.8%) 487948 bytes (0.7%), 33052 outer tuples (0.6%) 4901733 (0.6%) bytes, on disk
NOTICE: Batch 21: 6108 inner tuples (0.8%) 485244 bytes (0.7%), 33153 outer tuples (0.6%) 4917572 (0.6%) bytes, on disk
NOTICE: Batch 22: 6357 inner tuples (0.8%) 505008 bytes (0.7%), 35383 outer tuples (0.6%) 5251144 (0.6%) bytes, on disk
NOTICE: Batch 23: 6322 inner tuples (0.8%) 502076 bytes (0.7%), 34713 outer tuples (0.6%) 5153227 (0.6%) bytes, on disk
NOTICE: Batch 24: 6129 inner tuples (0.8%) 487196 bytes (0.7%), 30161 outer tuples (0.5%) 4473966 (0.5%) bytes, on disk
NOTICE: Batch 25: 6221 inner tuples (0.8%) 494024 bytes (0.7%), 41634 outer tuples (0.7%) 6174443 (0.7%) bytes, on disk
NOTICE: Batch 26: 6281 inner tuples (0.8%) 498996 bytes (0.7%), 42205 outer tuples (0.7%) 6263450 (0.7%) bytes, on disk
NOTICE: Batch 27: 6311 inner tuples (0.8%) 501728 bytes (0.7%), 142422 outer tuples (2.4%) 21140054 (2.4%) bytes, on disk
NOTICE: Batch 28: 6278 inner tuples (0.8%) 498756 bytes (0.7%), 35915 outer tuples (0.6%) 5329354 (0.6%) bytes, on disk
NOTICE: Batch 29: 6348 inner tuples (0.8%) 504648 bytes (0.7%), 59076 outer tuples (1.0%) 8763367 (1.0%) bytes, on disk
NOTICE: Batch 30: 6246 inner tuples (0.8%) 496048 bytes (0.7%), 32327 outer tuples (0.5%) 4795668 (0.6%) bytes, on disk
NOTICE: Batch 31: 6084 inner tuples (0.8%) 482744 bytes (0.7%), 41079 outer tuples (0.7%) 6095046 (0.7%) bytes, on disk
NOTICE: Batch 32: 6344 inner tuples (0.8%) 503208 bytes (0.7%), 43110 outer tuples (0.7%) 6397627 (0.7%) bytes, on disk
NOTICE: Batch 33: 6264 inner tuples (0.8%) 497632 bytes (0.7%), 31106 outer tuples (0.5%) 4612608 (0.5%) bytes, on disk
NOTICE: Batch 34: 6357 inner tuples (0.8%) 505256 bytes (0.7%), 134174 outer tuples (2.2%) 19915951 (2.3%) bytes, on disk
NOTICE: Batch 35: 6173 inner tuples (0.8%) 490728 bytes (0.7%), 33555 outer tuples (0.6%) 4977564 (0.6%) bytes, on disk
NOTICE: Batch 36: 6355 inner tuples (0.8%) 505268 bytes (0.7%), 44098 outer tuples (0.7%) 6542333 (0.8%) bytes, on disk
NOTICE: Batch 37: 6301 inner tuples (0.8%) 500936 bytes (0.7%), 68283 outer tuples (1.1%) 10133030 (1.2%) bytes, on disk
NOTICE: Batch 38: 6280 inner tuples (0.8%) 499628 bytes (0.7%), 67602 outer tuples (1.1%) 10037951 (1.2%) bytes, on disk
NOTICE: Batch 39: 6289 inner tuples (0.8%) 499432 bytes (0.7%), 63808 outer tuples (1.1%) 9473674 (1.1%) bytes, on disk
NOTICE: Batch 40: 6453 inner tuples (0.8%) 512536 bytes (0.7%), 39387 outer tuples (0.7%) 5837358 (0.7%) bytes, on disk
NOTICE: Batch 41: 6105 inner tuples (0.8%) 484256 bytes (0.7%), 36370 outer tuples (0.6%) 5398005 (0.6%) bytes, on disk
NOTICE: Batch 42: 6332 inner tuples (0.8%) 503280 bytes (0.7%), 36039 outer tuples (0.6%) 5349068 (0.6%) bytes, on disk
NOTICE: Batch 43: 6263 inner tuples (0.8%) 497472 bytes (0.7%), 40480 outer tuples (0.7%) 5984021 (0.7%) bytes, on disk
NOTICE: Batch 44: 6241 inner tuples (0.8%) 495916 bytes (0.7%), 41162 outer tuples (0.7%) 6108249 (0.7%) bytes, on disk
NOTICE: Batch 45: 6328 inner tuples (0.8%) 503080 bytes (0.7%), 36645 outer tuples (0.6%) 5434480 (0.6%) bytes, on disk
NOTICE: Batch 46: 6193 inner tuples (0.8%) 492200 bytes (0.7%), 56650 outer tuples (0.9%) 8409016 (1.0%) bytes, on disk
NOTICE: Batch 47: 6156 inner tuples (0.8%) 489416 bytes (0.7%), 47667 outer tuples (0.8%) 7069951 (0.8%) bytes, on disk
NOTICE: Batch 48: 6272 inner tuples (0.8%) 498096 bytes (0.7%), 80554 outer tuples (1.3%) 11951607 (1.4%) bytes, on disk
NOTICE: Batch 49: 6171 inner tuples (0.8%) 490168 bytes (0.7%), 34876 outer tuples (0.6%) 5170530 (0.6%) bytes, on disk
NOTICE: Batch 50: 6328 inner tuples (0.8%) 502448 bytes (0.7%), 44291 outer tuples (0.7%) 6569562 (0.8%) bytes, on disk
NOTICE: Batch 51: 6368 inner tuples (0.8%) 506308 bytes (0.7%), 32931 outer tuples (0.5%) 4883148 (0.6%) bytes, on disk
NOTICE: Batch 52: 6156 inner tuples (0.8%) 488904 bytes (0.7%), 49271 outer tuples (0.8%) 7316042 (0.8%) bytes, on disk
NOTICE: Batch 53: 6128 inner tuples (0.8%) 486604 bytes (0.7%), 64301 outer tuples (1.1%) 9544627 (1.1%) bytes, on disk
NOTICE: Batch 54: 6206 inner tuples (0.8%) 493344 bytes (0.7%), 64857 outer tuples (1.1%) 9626885 (1.1%) bytes, on disk
NOTICE: Batch 55: 6223 inner tuples (0.8%) 494428 bytes (0.7%), 62397 outer tuples (1.0%) 9261797 (1.1%) bytes, on disk
NOTICE: Batch 56: 6251 inner tuples (0.8%) 497548 bytes (0.7%), 47141 outer tuples (0.8%) 6996470 (0.8%) bytes, on disk
NOTICE: Batch 57: 6214 inner tuples (0.8%) 493204 bytes (0.7%), 35505 outer tuples (0.6%) 5263852 (0.6%) bytes, on disk
NOTICE: Batch 58: 6131 inner tuples (0.8%) 486940 bytes (0.7%), 30452 outer tuples (0.5%) 4517742 (0.5%) bytes, on disk
NOTICE: Batch 59: 6407 inner tuples (0.8%) 508640 bytes (0.7%), 86378 outer tuples (1.4%) 12820177 (1.5%) bytes, on disk
NOTICE: Batch 60: 6234 inner tuples (0.8%) 495916 bytes (0.7%), 51792 outer tuples (0.9%) 7682655 (0.9%) bytes, on disk
NOTICE: Batch 61: 6464 inner tuples (0.8%) 513784 bytes (0.7%), 35001 outer tuples (0.6%) 5192167 (0.6%) bytes, on disk
NOTICE: Batch 62: 6392 inner tuples (0.8%) 507332 bytes (0.7%), 33530 outer tuples (0.6%) 4969307 (0.6%) bytes, on disk
NOTICE: Batch 63: 6150 inner tuples (0.8%) 488432 bytes (0.7%), 33771 outer tuples (0.6%) 5007331 (0.6%) bytes, on disk
NOTICE: Batch 64: 6246 inner tuples (0.8%) 496636 bytes (0.7%), 34986 outer tuples (0.6%) 5189969 (0.6%) bytes, on disk
NOTICE: Batch 65: 6269 inner tuples (0.8%) 498648 bytes (0.7%), 33853 outer tuples (0.6%) 5021838 (0.6%) bytes, on disk
NOTICE: Batch 66: 6314 inner tuples (0.8%) 501956 bytes (0.7%), 41697 outer tuples (0.7%) 6188924 (0.7%) bytes, on disk
NOTICE: Batch 67: 6264 inner tuples (0.8%) 497548 bytes (0.7%), 42175 outer tuples (0.7%) 6258930 (0.7%) bytes, on disk
NOTICE: Batch 68: 6102 inner tuples (0.8%) 484668 bytes (0.7%), 34723 outer tuples (0.6%) 5152088 (0.6%) bytes, on disk
NOTICE: Batch 69: 6130 inner tuples (0.8%) 486912 bytes (0.7%), 40209 outer tuples (0.7%) 5963155 (0.7%) bytes, on disk
NOTICE: Batch 70: 6263 inner tuples (0.8%) 497372 bytes (0.7%), 75375 outer tuples (1.3%) 11183761 (1.3%) bytes, on disk
NOTICE: Batch 71: 6195 inner tuples (0.8%) 491604 bytes (0.7%), 47227 outer tuples (0.8%) 7007658 (0.8%) bytes, on disk
NOTICE: Batch 72: 6333 inner tuples (0.8%) 502736 bytes (0.7%), 39297 outer tuples (0.7%) 5805299 (0.7%) bytes, on disk
NOTICE: Batch 73: 6220 inner tuples (0.8%) 494116 bytes (0.7%), 34029 outer tuples (0.6%) 5051589 (0.6%) bytes, on disk
NOTICE: Batch 74: 6245 inner tuples (0.8%) 495912 bytes (0.7%), 133494 outer tuples (2.2%) 19822936 (2.3%) bytes, on disk
NOTICE: Batch 75: 6249 inner tuples (0.8%) 496808 bytes (0.7%), 40190 outer tuples (0.7%) 5963926 (0.7%) bytes, on disk
NOTICE: Batch 76: 6374 inner tuples (0.8%) 506236 bytes (0.7%), 38452 outer tuples (0.6%) 5700050 (0.7%) bytes, on disk
NOTICE: Batch 77: 6326 inner tuples (0.8%) 503512 bytes (0.7%), 36883 outer tuples (0.6%) 5468731 (0.6%) bytes, on disk
NOTICE: Batch 78: 6068 inner tuples (0.8%) 481852 bytes (0.7%), 36801 outer tuples (0.6%) 5459999 (0.6%) bytes, on disk
NOTICE: Batch 79: 6258 inner tuples (0.8%) 497592 bytes (0.7%), 38876 outer tuples (0.6%) 5761760 (0.7%) bytes, on disk
NOTICE: Batch 80: 6223 inner tuples (0.8%) 494864 bytes (0.7%), 40970 outer tuples (0.7%) 6077368 (0.7%) bytes, on disk
NOTICE: Batch 81: 6266 inner tuples (0.8%) 498184 bytes (0.7%), 38290 outer tuples (0.6%) 5682692 (0.7%) bytes, on disk
NOTICE: Batch 82: 6504 inner tuples (0.8%) 517284 bytes (0.7%), 44895 outer tuples (0.7%) 6660725 (0.8%) bytes, on disk
NOTICE: Batch 83: 6216 inner tuples (0.8%) 493992 bytes (0.7%), 70001 outer tuples (1.2%) 10388803 (1.2%) bytes, on disk
NOTICE: Batch 84: 5982 inner tuples (0.7%) 475228 bytes (0.6%), 31527 outer tuples (0.5%) 4674757 (0.5%) bytes, on disk
NOTICE: Batch 85: 6275 inner tuples (0.8%) 498992 bytes (0.7%), 58495 outer tuples (1.0%) 8681594 (1.0%) bytes, on disk
NOTICE: Batch 86: 6282 inner tuples (0.8%) 498652 bytes (0.7%), 34476 outer tuples (0.6%) 5114611 (0.6%) bytes, on disk
NOTICE: Batch 87: 6284 inner tuples (0.8%) 499288 bytes (0.7%), 42091 outer tuples (0.7%) 6246139 (0.7%) bytes, on disk
NOTICE: Batch 88: 6241 inner tuples (0.8%) 495572 bytes (0.7%), 58743 outer tuples (1.0%) 8714707 (1.0%) bytes, on disk
NOTICE: Batch 89: 6218 inner tuples (0.8%) 494032 bytes (0.7%), 45608 outer tuples (0.8%) 6766849 (0.8%) bytes, on disk
NOTICE: Batch 90: 6306 inner tuples (0.8%) 501312 bytes (0.7%), 36990 outer tuples (0.6%) 5484509 (0.6%) bytes, on disk
NOTICE: Batch 91: 6242 inner tuples (0.8%) 495880 bytes (0.7%), 38207 outer tuples (0.6%) 5670451 (0.7%) bytes, on disk
NOTICE: Batch 92: 6250 inner tuples (0.8%) 496544 bytes (0.7%), 28925 outer tuples (0.5%) 4289399 (0.5%) bytes, on disk
NOTICE: Batch 93: 6285 inner tuples (0.8%) 499308 bytes (0.7%), 45179 outer tuples (0.8%) 6706554 (0.8%) bytes, on disk
NOTICE: Batch 94: 6220 inner tuples (0.8%) 493988 bytes (0.7%), 35592 outer tuples (0.6%) 5278595 (0.6%) bytes, on disk
NOTICE: Batch 95: 6199 inner tuples (0.8%) 491748 bytes (0.7%), 101562 outer tuples (1.7%) 15074141 (1.7%) bytes, on disk
NOTICE: Batch 96: 6204 inner tuples (0.8%) 493016 bytes (0.7%), 32762 outer tuples (0.5%) 4860396 (0.6%) bytes, on disk
NOTICE: Batch 97: 6172 inner tuples (0.8%) 490108 bytes (0.7%), 41524 outer tuples (0.7%) 6161028 (0.7%) bytes, on disk
NOTICE: Batch 98: 6318 inner tuples (0.8%) 501764 bytes (0.7%), 49772 outer tuples (0.8%) 7385887 (0.9%) bytes, on disk
NOTICE: Batch 99: 6356 inner tuples (0.8%) 505168 bytes (0.7%), 49210 outer tuples (0.8%) 7300003 (0.8%) bytes, on disk
NOTICE: Batch 100: 6270 inner tuples (0.8%) 498232 bytes (0.7%), 35714 outer tuples (0.6%) 5297324 (0.6%) bytes, on disk
NOTICE: Batch 101: 6322 inner tuples (0.8%) 502056 bytes (0.7%), 56917 outer tuples (0.9%) 8443964 (1.0%) bytes, on disk
NOTICE: Batch 102: 6189 inner tuples (0.8%) 492260 bytes (0.7%), 55169 outer tuples (0.9%) 8163536 (0.9%) bytes, on disk
NOTICE: Batch 103: 6305 inner tuples (0.8%) 501084 bytes (0.7%), 35597 outer tuples (0.6%) 5281128 (0.6%) bytes, on disk
NOTICE: Batch 104: 6223 inner tuples (0.8%) 494456 bytes (0.7%), 42337 outer tuples (0.7%) 6252147 (0.7%) bytes, on disk
NOTICE: Batch 105: 6320 inner tuples (0.8%) 502000 bytes (0.7%), 44501 outer tuples (0.7%) 6604382 (0.8%) bytes, on disk
NOTICE: Batch 106: 6170 inner tuples (0.8%) 490072 bytes (0.7%), 129905 outer tuples (2.2%) 19288075 (2.2%) bytes, on disk
NOTICE: Batch 107: 6232 inner tuples (0.8%) 494924 bytes (0.7%), 83139 outer tuples (1.4%) 12337500 (1.4%) bytes, on disk
NOTICE: Batch 108: 6109 inner tuples (0.8%) 485380 bytes (0.7%), 40778 outer tuples (0.7%) 6053617 (0.7%) bytes, on disk
NOTICE: Batch 109: 6269 inner tuples (0.8%) 498328 bytes (0.7%), 61204 outer tuples (1.0%) 9082181 (1.0%) bytes, on disk
NOTICE: Batch 110: 6158 inner tuples (0.8%) 489140 bytes (0.7%), 51430 outer tuples (0.9%) 7632020 (0.9%) bytes, on disk
NOTICE: Batch 111: 6263 inner tuples (0.8%) 497596 bytes (0.7%), 39924 outer tuples (0.7%) 5924732 (0.7%) bytes, on disk
NOTICE: Batch 112: 6299 inner tuples (0.8%) 499932 bytes (0.7%), 41050 outer tuples (0.7%) 6091472 (0.7%) bytes, on disk
NOTICE: Batch 113: 6312 inner tuples (0.8%) 500816 bytes (0.7%), 42419 outer tuples (0.7%) 6284584 (0.7%) bytes, on disk
NOTICE: Batch 114: 6292 inner tuples (0.8%) 500144 bytes (0.7%), 33502 outer tuples (0.6%) 4970626 (0.6%) bytes, on disk
NOTICE: Batch 115: 6297 inner tuples (0.8%) 500252 bytes (0.7%), 35879 outer tuples (0.6%) 5325492 (0.6%) bytes, on disk
NOTICE: Batch 116: 6089 inner tuples (0.8%) 483872 bytes (0.7%), 43167 outer tuples (0.7%) 6401095 (0.7%) bytes, on disk
NOTICE: Batch 117: 6244 inner tuples (0.8%) 496184 bytes (0.7%), 57401 outer tuples (1.0%) 8510859 (1.0%) bytes, on disk
NOTICE: Batch 118: 6378 inner tuples (0.8%) 506944 bytes (0.7%), 33761 outer tuples (0.6%) 5006128 (0.6%) bytes, on disk
NOTICE: Batch 119: 6042 inner tuples (0.8%) 480120 bytes (0.7%), 38555 outer tuples (0.6%) 5721580 (0.7%) bytes, on disk
NOTICE: Batch 120: 6240 inner tuples (0.8%) 495572 bytes (0.7%), 48492 outer tuples (0.8%) 7196474 (0.8%) bytes, on disk
NOTICE: Batch 121: 6175 inner tuples (0.8%) 490880 bytes (0.7%), 33426 outer tuples (0.6%) 4961213 (0.6%) bytes, on disk
NOTICE: Batch 122: 6299 inner tuples (0.8%) 500692 bytes (0.7%), 42735 outer tuples (0.7%) 6341869 (0.7%) bytes, on disk
NOTICE: Batch 123: 6104 inner tuples (0.8%) 484300 bytes (0.7%), 30885 outer tuples (0.5%) 4580915 (0.5%) bytes, on disk
NOTICE: Batch 124: 6263 inner tuples (0.8%) 497444 bytes (0.7%), 41954 outer tuples (0.7%) 6219410 (0.7%) bytes, on disk
NOTICE: Batch 125: 6367 inner tuples (0.8%) 506068 bytes (0.7%), 56850 outer tuples (0.9%) 8438006 (1.0%) bytes, on disk
NOTICE: Batch 126: 6260 inner tuples (0.8%) 496996 bytes (0.7%), 33794 outer tuples (0.6%) 5007742 (0.6%) bytes, on disk
NOTICE: Batch 127: 6346 inner tuples (0.8%) 504500 bytes (0.7%), 34655 outer tuples (0.6%) 5142834 (0.6%) bytes, on disk
NOTICE: HJ HashTable Stats
intup = 200000	intupIOs = 375110	in bytes written = 12651492	 in bytes total = 15890716
outtup = 800000	outtupIOs = 1500440	out bytes written = 126292637	out bytes total = 131484729
nbatch = 16	nfrozen = 15
NOTICE: # probes: 5692016	# buckets: 2048
NOTICE: Batch 0: 12445 inner tuples (6.2%) 988564 bytes (6.2%), 49780 outer tuples (6.2%) 8192972 (6.2%) bytes, in memory
NOTICE: Batch 1: 12597 inner tuples (6.3%) 850040 bytes (5.3%), 50388 outer tuples (6.3%) 8480362 (6.4%) bytes, on disk
NOTICE: Batch 2: 12480 inner tuples (6.2%) 841440 bytes (5.3%), 49920 outer tuples (6.2%) 8411720 (6.4%) bytes, on disk
NOTICE: Batch 3: 12645 inner tuples (6.3%) 853216 bytes (5.4%), 50580 outer tuples (6.3%) 8515317 (6.5%) bytes, on disk
NOTICE: Batch 4: 12286 inner tuples (6.1%) 828572 bytes (5.2%), 49144 outer tuples (6.1%) 8281264 (6.3%) bytes, on disk
NOTICE: Batch 5: 12449 inner tuples (6.2%) 839060 bytes (5.3%), 49796 outer tuples (6.2%) 8378713 (6.4%) bytes, on disk
NOTICE: Batch 6: 12458 inner tuples (6.2%) 840968 bytes (5.3%), 49832 outer tuples (6.2%) 8379893 (6.4%) bytes, on disk
NOTICE: Batch 7: 12663 inner tuples (6.3%) 854724 bytes (5.4%), 50652 outer tuples (6.3%) 8529790 (6.5%) bytes, on disk
NOTICE: Batch 8: 12385 inner tuples (6.2%) 835476 bytes (5.3%), 49540 outer tuples (6.2%) 8346362 (6.3%) bytes, on disk
NOTICE: Batch 9: 12511 inner tuples (6.3%) 844728 bytes (5.3%), 50044 outer tuples (6.3%) 8432268 (6.4%) bytes, on disk
NOTICE: Batch 10: 12396 inner tuples (6.2%) 835732 bytes (5.3%), 49584 outer tuples (6.2%) 8343585 (6.3%) bytes, on disk
NOTICE: Batch 11: 12465 inner tuples (6.2%) 839520 bytes (5.3%), 49860 outer tuples (6.2%) 8391182 (6.4%) bytes, on disk
NOTICE: Batch 12: 12543 inner tuples (6.3%) 846444 bytes (5.3%), 50172 outer tuples (6.3%) 8438899 (6.4%) bytes, on disk
NOTICE: Batch 13: 12405 inner tuples (6.2%) 837136 bytes (5.3%), 49620 outer tuples (6.2%) 8341030 (6.3%) bytes, on disk
NOTICE: Batch 14: 12688 inner tuples (6.3%) 855692 bytes (5.4%), 50752 outer tuples (6.3%) 8552161 (6.5%) bytes, on disk
NOTICE: Batch 15: 12584 inner tuples (6.3%) 848744 bytes (5.3%), 50336 outer tuples (6.3%) 8470091 (6.4%) bytes, on disk
NOTICE: DONE: 2008-09-09 11:02:03.010517
NOTICE: RUNTIME: 00:01:02.770824
Query#: 0, Run#: 9, memory: 1024.0, runtime: 62797.0ms

=======
select l_orderkey, l_linenumber, l_quantity, p_name, p_retailprice, ps_availqty, s_name  from lineitem, partsupp, part, supplier where p_partkey = ps_partkey and s_suppkey = ps_suppkey and l_partkey = ps_partkey and l_suppkey = ps_suppkey

IOs

Mem           HYBRID_HASH_JOIN
 1024                 15391226

Runtimes

Mem           HYBRID_HASH_JOIN
 1024                  70572.0

