github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/stats_quality/tpch/q18 (about) 1 import file=tpch_schema 2 ---- 3 4 import file=tpch_stats 5 ---- 6 7 # -------------------------------------------------- 8 # Q18 9 # Large Volume Customer 10 # Ranks customers based on their having placed a large quantity order. Large 11 # quantity orders are defined as those orders whose total quantity is above a 12 # certain level. 13 # 14 # Finds a list of the top 100 customers who have ever placed large quantity 15 # orders. The query lists the customer name, customer key, the order key, date 16 # and total price and the quantity for the order. 17 # -------------------------------------------------- 18 save-tables database=tpch save-tables-prefix=q18 19 SELECT 20 c_name, 21 c_custkey, 22 o_orderkey, 23 o_orderdate, 24 o_totalprice, 25 sum(l_quantity) 26 FROM 27 customer, 28 orders, 29 lineitem 30 WHERE 31 o_orderkey IN ( 32 SELECT 33 l_orderkey 34 FROM 35 lineitem 36 GROUP BY 37 l_orderkey HAVING 38 sum(l_quantity) > 300 39 ) 40 AND c_custkey = o_custkey 41 AND o_orderkey = l_orderkey 42 GROUP BY 43 c_name, 44 c_custkey, 45 o_orderkey, 46 o_orderdate, 47 o_totalprice 48 ORDER BY 49 o_totalprice DESC, 50 o_orderdate 51 LIMIT 100; 52 ---- 53 limit 54 ├── save-table-name: q18_limit_1 55 ├── columns: c_name:2(varchar!null) c_custkey:1(int!null) o_orderkey:9(int!null) o_orderdate:13(date!null) o_totalprice:12(float!null) sum:51(float!null) 56 ├── internal-ordering: -12,+13 57 ├── cardinality: [0 - 100] 58 ├── stats: [rows=100, distinct(1)=100, null(1)=0, distinct(2)=100, null(2)=0, distinct(9)=100, null(9)=0, distinct(12)=100, null(12)=0, distinct(13)=100, null(13)=0, distinct(51)=100, null(51)=0] 59 ├── key: (9) 60 ├── fd: (1)-->(2), (9)-->(1,2,12,13,51) 61 ├── ordering: -12,+13 62 ├── sort 63 │ ├── save-table-name: q18_sort_2 64 │ ├── columns: c_custkey:1(int!null) c_name:2(varchar!null) o_orderkey:9(int!null) o_totalprice:12(float!null) o_orderdate:13(date!null) sum:51(float!null) 65 │ ├── stats: [rows=499392.239, distinct(1)=499392.239, null(1)=0, distinct(2)=499392.239, null(2)=0, distinct(9)=499392.239, null(9)=0, distinct(12)=499392.239, null(12)=0, distinct(13)=499392.239, null(13)=0, distinct(51)=499392.239, null(51)=0] 66 │ ├── key: (9) 67 │ ├── fd: (1)-->(2), (9)-->(1,2,12,13,51) 68 │ ├── ordering: -12,+13 69 │ ├── limit hint: 100.00 70 │ └── group-by 71 │ ├── save-table-name: q18_group_by_3 72 │ ├── columns: c_custkey:1(int!null) c_name:2(varchar!null) o_orderkey:9(int!null) o_totalprice:12(float!null) o_orderdate:13(date!null) sum:51(float!null) 73 │ ├── grouping columns: o_orderkey:9(int!null) 74 │ ├── stats: [rows=499392.239, distinct(1)=499392.239, null(1)=0, distinct(2)=499392.239, null(2)=0, distinct(9)=499392.239, null(9)=0, distinct(12)=499392.239, null(12)=0, distinct(13)=499392.239, null(13)=0, distinct(51)=499392.239, null(51)=0] 75 │ ├── key: (9) 76 │ ├── fd: (1)-->(2), (9)-->(1,2,12,13,51) 77 │ ├── inner-join (hash) 78 │ │ ├── save-table-name: q18_inner_join_4 79 │ │ ├── columns: c_custkey:1(int!null) c_name:2(varchar!null) o_orderkey:9(int!null) o_custkey:10(int!null) o_totalprice:12(float!null) o_orderdate:13(date!null) l_orderkey:18(int!null) l_quantity:22(float!null) 80 │ │ ├── stats: [rows=2016361.14, distinct(1)=99649.071, null(1)=0, distinct(2)=149999.782, null(2)=0, distinct(9)=499392.239, null(9)=0, distinct(10)=99649.071, null(10)=0, distinct(12)=488043.529, null(12)=0, distinct(13)=2406, null(13)=0, distinct(18)=499392.239, null(18)=0, distinct(22)=50, null(22)=0] 81 │ │ ├── fd: (1)-->(2), (9)-->(10,12,13), (9)==(18), (18)==(9), (1)==(10), (10)==(1) 82 │ │ ├── scan lineitem 83 │ │ │ ├── save-table-name: q18_scan_5 84 │ │ │ ├── columns: l_orderkey:18(int!null) l_quantity:22(float!null) 85 │ │ │ └── stats: [rows=6001215, distinct(18)=1527270, null(18)=0, distinct(22)=50, null(22)=0] 86 │ │ │ histogram(18)= 0 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 87 │ │ │ <--- 326 ------- 28929 ------- 50503 ------- 89793 ------- 115938 ------- 146944 ------- 176768 ------- 211201 ------- 237860 ------- 266885 ------- 297604 ------- 330021 ------- 365889 ------- 398951 ------- 426117 ------- 451328 ------- 472134 ------- 499590 ------- 529284 ------- 557254 ------- 589154 ------- 619394 ------- 642951 ------- 670113 ------- 692931 ------- 721157 ------- 751687 ------- 777766 ------- 804582 ------- 836740 ------- 868868 ------- 898912 ------- 922500 ------- 946403 ------- 984870 ------- 1007936 ------- 1030117 ------- 1062275 ------- 1093572 ------- 1120709 ------- 1150981 ------- 1182786 ------- 1206406 ------- 1234116 ------- 1260961 ------- 1290502 ------- 1329510 ------- 1355426 ------- 1381313 ------- 1409796 ------- 1445254 ------- 1479233 ------- 1504935 ------- 1531079 ------- 1559650 ------- 1583616 ------- 1617504 ------- 1655749 ------- 1685185 ------- 1718183 ------- 1747716 ------- 1772131 ------- 1802372 ------- 1833315 ------- 1862403 ------- 1897894 ------- 1922819 ------- 1954405 ------- 1979329 ------- 2009859 ------- 2041670 ------- 2070851 ------- 2093828 ------- 2127973 ------- 2167777 ------- 2194883 ------- 2227814 ------- 2262437 ------- 2296353 ------- 2321024 ------- 2346051 ------- 2376257 ------- 2404932 ------- 2446273 ------- 2474081 ------- 2504515 ------- 2535302 ------- 2561413 ------- 2592737 ------- 2616801 ------- 2646112 ------- 2676546 ------- 2702116 ------- 2732454 ------- 2765382 ------- 2799495 ------- 2828866 ------- 2868737 ------- 2910625 ------- 2938464 ------- 2963140 ------- 3003302 ------- 3043264 ------- 3069123 ------- 3095909 ------- 3126693 ------- 3160485 ------- 3196039 ------- 3229504 ------- 3259712 ------- 3286439 ------- 3318852 ------- 3346821 ------- 3370119 ------- 3395204 ------- 3425888 ------- 3448611 ------- 3476130 ------- 3502372 ------- 3529474 ------- 3556390 ------- 3583553 ------- 3612550 ------- 3647875 ------- 3679140 ------- 3702661 ------- 3738017 ------- 3778050 ------- 3806114 ------- 3839074 ------- 3872805 ------- 3905697 ------- 3926212 ------- 3959841 ------- 3997281 ------- 4033861 ------- 4063591 ------- 4097831 ------- 4124807 ------- 4158656 ------- 4195748 ------- 4234274 ------- 4269952 ------- 4298949 ------- 4332806 ------- 4364705 ------- 4398246 ------- 4430695 ------- 4466403 ------- 4494662 ------- 4524420 ------- 4558561 ------- 4601092 ------- 4632871 ------- 4658694 ------- 4690501 ------- 4728066 ------- 4758657 ------- 4788294 ------- 4818597 ------- 4855874 ------- 4890913 ------- 4915366 ------- 4940709 ------- 4972357 ------- 4995298 ------- 5019523 ------- 5043329 ------- 5077376 ------- 5109920 ------- 5136582 ------- 5161152 ------- 5191846 ------- 5219973 ------- 5251015 ------- 5282021 ------- 5312355 ------- 5343207 ------- 5381318 ------- 5416163 ------- 5445382 ------- 5476933 ------- 5509185 ------- 5539237 ------- 5566818 ------- 5588739 ------- 5620481 ------- 5644001 ------- 5667010 ------- 5689476 ------- 5724709 ------- 5755398 ------- 5790598 ------- 5819425 ------- 5846341 ------- 5874656 ------- 5908067 ------- 5933572 ------- 5962659 ------- 5999971 88 │ │ ├── inner-join (hash) 89 │ │ │ ├── save-table-name: q18_inner_join_6 90 │ │ │ ├── columns: c_custkey:1(int!null) c_name:2(varchar!null) o_orderkey:9(int!null) o_custkey:10(int!null) o_totalprice:12(float!null) o_orderdate:13(date!null) 91 │ │ │ ├── stats: [rows=513150.733, distinct(1)=99649.0712, null(1)=0, distinct(2)=145098.119, null(2)=0, distinct(9)=323294.803, null(9)=0, distinct(10)=99649.0712, null(10)=0, distinct(12)=322560.125, null(12)=0, distinct(13)=2406, null(13)=0] 92 │ │ │ ├── key: (9) 93 │ │ │ ├── fd: (9)-->(10,12,13), (1)-->(2), (1)==(10), (10)==(1) 94 │ │ │ ├── semi-join (merge) 95 │ │ │ │ ├── save-table-name: q18_merge_join_7 96 │ │ │ │ ├── columns: o_orderkey:9(int!null) o_custkey:10(int!null) o_totalprice:12(float!null) o_orderdate:13(date!null) 97 │ │ │ │ ├── left ordering: +9 98 │ │ │ │ ├── right ordering: +34 99 │ │ │ │ ├── stats: [rows=509090, distinct(9)=509090, null(9)=0, distinct(10)=99649.0712, null(10)=0, distinct(12)=506350.486, null(12)=0, distinct(13)=2406, null(13)=0] 100 │ │ │ │ ├── key: (9) 101 │ │ │ │ ├── fd: (9)-->(10,12,13) 102 │ │ │ │ ├── scan orders 103 │ │ │ │ │ ├── save-table-name: q18_scan_8 104 │ │ │ │ │ ├── columns: o_orderkey:9(int!null) o_custkey:10(int!null) o_totalprice:12(float!null) o_orderdate:13(date!null) 105 │ │ │ │ │ ├── stats: [rows=1500000, distinct(9)=1500000, null(9)=0, distinct(10)=99846, null(10)=0, distinct(12)=1459167, null(12)=0, distinct(13)=2406, null(13)=0] 106 │ │ │ │ │ │ histogram(9)= 0 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 107 │ │ │ │ │ │ <--- 998 ------ 26593 ------ 56613 ------ 85827 ------ 115587 ------ 140512 ------ 167076 ------ 198882 ------ 228580 ------ 262243 ------ 292064 ------ 316161 ------ 344194 ------ 368550 ------ 402722 ------ 434529 ------ 468807 ------ 495107 ------ 526338 ------ 563239 ------ 597733 ------ 641894 ------ 665730 ------ 688742 ------ 721767 ------ 750050 ------ 787879 ------ 814565 ------ 837381 ------ 866657 ------ 902855 ------ 927172 ------ 952772 ------ 975840 ------ 1008646 ------ 1032066 ------ 1074656 ------ 1104896 ------ 1138369 ------ 1166689 ------ 1194912 ------ 1225222 ------ 1253284 ------ 1284803 ------ 1318499 ------ 1348609 ------ 1376609 ------ 1404933 ------ 1435745 ------ 1460325 ------ 1491648 ------ 1518852 ------ 1542567 ------ 1574277 ------ 1597958 ------ 1624964 ------ 1647555 ------ 1683651 ------ 1717189 ------ 1750563 ------ 1784775 ------ 1812449 ------ 1838850 ------ 1867751 ------ 1891783 ------ 1918790 ------ 1949827 ------ 1986021 ------ 2020134 ------ 2045829 ------ 2077894 ------ 2118912 ------ 2143264 ------ 2176486 ------ 2204838 ------ 2234146 ------ 2260484 ------ 2288512 ------ 2317121 ------ 2344321 ------ 2362567 ------ 2396133 ------ 2423623 ------ 2454884 ------ 2483879 ------ 2520162 ------ 2545574 ------ 2571874 ------ 2608417 ------ 2637477 ------ 2665607 ------ 2692231 ------ 2724261 ------ 2764451 ------ 2798656 ------ 2824775 ------ 2858690 ------ 2881990 ------ 2911814 ------ 2945056 ------ 2981315 ------ 3010306 ------ 3032320 ------ 3064389 ------ 3084166 ------ 3108832 ------ 3136032 ------ 3168484 ------ 3204039 ------ 3229922 ------ 3256549 ------ 3283169 ------ 3315236 ------ 3346756 ------ 3375879 ------ 3408007 ------ 3441827 ------ 3471204 ------ 3505414 ------ 3527938 ------ 3562561 ------ 3598630 ------ 3627270 ------ 3659266 ------ 3686468 ------ 3713505 ------ 3750817 ------ 3777696 ------ 3808129 ------ 3834533 ------ 3871968 ------ 3904931 ------ 3934215 ------ 3960643 ------ 3990336 ------ 4023203 ------ 4057826 ------ 4090691 ------ 4121216 ------ 4159681 ------ 4190726 ------ 4222624 ------ 4246567 ------ 4283653 ------ 4314339 ------ 4342592 ------ 4373829 ------ 4402372 ------ 4431332 ------ 4464452 ------ 4496327 ------ 4526789 ------ 4551109 ------ 4582401 ------ 4615974 ------ 4648482 ------ 4669601 ------ 4705891 ------ 4732869 ------ 4766145 ------ 4805862 ------ 4840677 ------ 4866787 ------ 4895332 ------ 4928100 ------ 4956323 ------ 4992161 ------ 5027008 ------ 5065797 ------ 5099011 ------ 5130592 ------ 5163463 ------ 5197314 ------ 5224994 ------ 5253892 ------ 5277638 ------ 5307105 ------ 5335750 ------ 5369828 ------ 5402528 ------ 5434183 ------ 5464227 ------ 5491072 ------ 5520679 ------ 5543047 ------ 5576708 ------ 5614951 ------ 5646055 ------ 5674721 ------ 5700295 ------ 5732066 ------ 5761255 ------ 5791233 ------ 5819651 ------ 5852291 ------ 5880258 ------ 5909062 ------ 5943111 ------ 5973926 ------ 5998752 108 │ │ │ │ │ │ histogram(10)= 0 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7200 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7200 300 7350 150 7350 150 7350 150 7350 150 7200 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7200 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 300 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7350 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 300 7350 150 7500 150 7500 150 7500 150 7500 150 7350 300 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7500 150 7350 300 7500 150 7500 150 7500 150 7500 150 7500 150 7350 300 7500 150 109 │ │ │ │ │ │ <--- 8 ------ 763 ------ 1477 ------ 2353 ------ 3229 ------ 4261 ------ 5191 ------ 5924 ------ 6406 ------ 7126 ------ 7870 ------ 8545 ------ 9301 ------ 9911 ------ 10591 ------ 11236 ------ 11854 ------ 12622 ------ 13426 ------ 14036 ------ 14708 ------ 15391 ------ 16138 ------ 16925 ------ 17681 ------ 18388 ------ 19156 ------ 20015 ------ 20660 ------ 21632 ------ 22472 ------ 23260 ------ 24055 ------ 24649 ------ 25352 ------ 25952 ------ 26774 ------ 27358 ------ 28070 ------ 28586 ------ 29296 ------ 30028 ------ 30629 ------ 31400 ------ 32102 ------ 32884 ------ 33796 ------ 34646 ------ 35479 ------ 36161 ------ 36811 ------ 37612 ------ 38314 ------ 39145 ------ 39844 ------ 40591 ------ 41254 ------ 41902 ------ 42496 ------ 43237 ------ 43948 ------ 44690 ------ 45481 ------ 46448 ------ 47242 ------ 47884 ------ 48676 ------ 49441 ------ 50155 ------ 50857 ------ 51463 ------ 52321 ------ 53014 ------ 53587 ------ 54413 ------ 55019 ------ 55771 ------ 56482 ------ 57314 ------ 58163 ------ 58894 ------ 59638 ------ 60478 ------ 61450 ------ 62417 ------ 63176 ------ 63944 ------ 64577 ------ 65344 ------ 66218 ------ 67021 ------ 67703 ------ 68477 ------ 69271 ------ 70073 ------ 70696 ------ 71512 ------ 72430 ------ 73345 ------ 74149 ------ 74780 ------ 75508 ------ 76273 ------ 76865 ------ 77666 ------ 78427 ------ 79042 ------ 79801 ------ 80557 ------ 81163 ------ 81833 ------ 82534 ------ 83368 ------ 84157 ------ 84938 ------ 85495 ------ 86257 ------ 87143 ------ 87998 ------ 88777 ------ 89566 ------ 90292 ------ 91099 ------ 91757 ------ 92401 ------ 93362 ------ 94252 ------ 94771 ------ 95527 ------ 96233 ------ 96952 ------ 97844 ------ 98411 ------ 99067 ------ 99691 ------ 100357 ------ 101009 ------ 101734 ------ 102569 ------ 103381 ------ 104114 ------ 105070 ------ 105884 ------ 106651 ------ 107393 ------ 107995 ------ 108772 ------ 109628 ------ 110383 ------ 111040 ------ 111658 ------ 112556 ------ 113338 ------ 114062 ------ 114895 ------ 115744 ------ 116554 ------ 117250 ------ 117967 ------ 118741 ------ 119540 ------ 120514 ------ 121333 ------ 122111 ------ 122989 ------ 123763 ------ 124735 ------ 125401 ------ 126022 ------ 126779 ------ 127618 ------ 128332 ------ 129167 ------ 129917 ------ 130669 ------ 131330 ------ 131911 ------ 132704 ------ 133553 ------ 134317 ------ 134960 ------ 135688 ------ 136519 ------ 137353 ------ 138061 ------ 138697 ------ 139468 ------ 140218 ------ 140942 ------ 141644 ------ 142415 ------ 143263 ------ 144352 ------ 145099 ------ 145811 ------ 146761 ------ 147643 ------ 148591 ------ 149164 ------ 149995 110 │ │ │ │ │ │ histogram(13)= 0 450 6600 900 6300 1350 7200 300 6750 1050 7350 300 7350 150 7200 300 7350 1200 6900 750 6600 900 6750 900 6300 1350 7350 750 7050 450 6900 900 7350 150 7200 450 7050 750 6750 750 6900 750 7350 600 6750 900 6750 750 7050 450 7050 900 6900 1050 6600 900 7350 750 6900 1050 6750 750 6750 900 7050 450 7050 750 7200 450 7050 750 6300 1800 6600 750 7200 1200 7050 600 7050 450 6600 1050 7050 450 6900 450 7200 450 6750 600 6600 900 7050 1200 6600 1200 7050 750 6600 900 6750 600 7200 450 6900 600 6600 1350 6900 1050 6300 1050 6750 1050 6900 450 7050 600 6900 450 7200 1500 7200 300 6450 900 7200 1050 6600 900 7050 600 6900 900 6600 900 6600 750 6900 1050 6450 900 7050 1350 6750 1050 6150 1500 7200 600 6900 600 6900 450 7050 300 6600 750 7200 600 6750 600 7200 300 7200 1350 7050 1200 6600 1050 7050 900 7050 450 6450 1050 6900 450 7050 1050 6750 900 6750 1200 6750 600 7200 1050 6150 1500 7200 300 7050 300 6750 900 6900 450 7200 1050 7200 450 7050 600 6750 750 6150 1200 7200 1200 6750 750 7050 450 7200 600 6450 1050 6600 600 7050 750 7050 150 6600 1200 6150 1050 6450 1050 6150 1050 6750 450 7050 300 5700 1500 7050 600 6300 1050 6900 750 6600 750 7050 1050 6600 750 6750 1050 7050 450 6900 900 7050 600 6600 750 6750 900 6900 750 6750 600 6300 1050 6750 600 6900 750 7050 900 6750 600 7050 450 6900 750 6600 600 7050 1050 6900 900 6900 750 6450 900 6750 600 6750 450 7050 450 7050 150 6600 1050 6900 600 6750 600 6300 900 6450 750 6600 600 6900 450 7050 750 6450 750 6300 900 6600 750 6450 1650 6450 750 6450 750 6900 450 5850 1350 6450 600 6300 1350 6750 750 6900 600 6900 1350 6000 1650 6600 750 6600 900 6300 1050 6300 750 6600 900 6000 900 6000 900 6600 450 6750 450 6450 750 6750 300 6450 450 6300 900 6450 450 6300 600 6300 750 6300 900 6750 1050 5850 1200 6150 1050 6300 750 6300 600 6600 750 6000 900 5550 1200 6300 450 5700 600 6000 450 111 │ │ │ │ │ │ <--- '1992-01-01' ------ '1992-01-11' ------ '1992-01-23' ------ '1992-02-04' ------ '1992-02-19' ------ '1992-03-03' ------ '1992-03-18' ------ '1992-03-29' ------ '1992-04-11' ------ '1992-04-23' ------ '1992-05-08' ------ '1992-05-20' ------ '1992-05-30' ------ '1992-06-11' ------ '1992-06-24' ------ '1992-07-05' ------ '1992-07-18' ------ '1992-07-30' ------ '1992-08-11' ------ '1992-08-23' ------ '1992-09-07' ------ '1992-09-21' ------ '1992-10-04' ------ '1992-10-18' ------ '1992-10-28' ------ '1992-11-07' ------ '1992-11-18' ------ '1992-11-30' ------ '1992-12-10' ------ '1992-12-25' ------ '1993-01-06' ------ '1993-01-19' ------ '1993-02-01' ------ '1993-02-14' ------ '1993-02-24' ------ '1993-03-08' ------ '1993-03-19' ------ '1993-04-03' ------ '1993-04-14' ------ '1993-04-25' ------ '1993-05-12' ------ '1993-05-25' ------ '1993-06-10' ------ '1993-06-18' ------ '1993-07-01' ------ '1993-07-12' ------ '1993-07-24' ------ '1993-08-05' ------ '1993-08-16' ------ '1993-08-29' ------ '1993-09-08' ------ '1993-09-19' ------ '1993-10-01' ------ '1993-10-13' ------ '1993-10-22' ------ '1993-11-04' ------ '1993-11-16' ------ '1993-11-30' ------ '1993-12-16' ------ '1993-12-29' ------ '1994-01-12' ------ '1994-01-23' ------ '1994-02-04' ------ '1994-02-16' ------ '1994-03-01' ------ '1994-03-14' ------ '1994-03-24' ------ '1994-04-06' ------ '1994-04-20' ------ '1994-05-01' ------ '1994-05-12' ------ '1994-05-23' ------ '1994-06-03' ------ '1994-06-16' ------ '1994-06-25' ------ '1994-07-08' ------ '1994-07-19' ------ '1994-08-01' ------ '1994-08-14' ------ '1994-08-25' ------ '1994-09-06' ------ '1994-09-18' ------ '1994-10-01' ------ '1994-10-17' ------ '1994-10-30' ------ '1994-11-10' ------ '1994-11-22' ------ '1994-12-02' ------ '1994-12-16' ------ '1994-12-30' ------ '1995-01-13' ------ '1995-01-25' ------ '1995-02-04' ------ '1995-02-16' ------ '1995-02-26' ------ '1995-03-10' ------ '1995-03-20' ------ '1995-04-02' ------ '1995-04-15' ------ '1995-04-28' ------ '1995-05-10' ------ '1995-05-25' ------ '1995-06-09' ------ '1995-06-20' ------ '1995-07-01' ------ '1995-07-13' ------ '1995-07-21' ------ '1995-08-01' ------ '1995-08-13' ------ '1995-08-25' ------ '1995-09-06' ------ '1995-09-18' ------ '1995-10-01' ------ '1995-10-11' ------ '1995-10-23' ------ '1995-11-01' ------ '1995-11-13' ------ '1995-11-26' ------ '1995-12-08' ------ '1995-12-22' ------ '1996-01-06' ------ '1996-01-18' ------ '1996-01-30' ------ '1996-02-13' ------ '1996-02-25' ------ '1996-03-09' ------ '1996-03-21' ------ '1996-04-04' ------ '1996-04-14' ------ '1996-04-27' ------ '1996-05-10' ------ '1996-05-22' ------ '1996-06-02' ------ '1996-06-12' ------ '1996-06-23' ------ '1996-07-07' ------ '1996-07-19' ------ '1996-08-01' ------ '1996-08-14' ------ '1996-08-25' ------ '1996-09-06' ------ '1996-09-20' ------ '1996-10-04' ------ '1996-10-15' ------ '1996-10-28' ------ '1996-11-11' ------ '1996-11-22' ------ '1996-12-04' ------ '1996-12-18' ------ '1996-12-29' ------ '1997-01-10' ------ '1997-01-22' ------ '1997-02-01' ------ '1997-02-13' ------ '1997-02-24' ------ '1997-03-09' ------ '1997-03-24' ------ '1997-04-04' ------ '1997-04-16' ------ '1997-04-26' ------ '1997-05-07' ------ '1997-05-19' ------ '1997-05-29' ------ '1997-06-08' ------ '1997-06-22' ------ '1997-07-05' ------ '1997-07-16' ------ '1997-07-28' ------ '1997-08-12' ------ '1997-08-23' ------ '1997-09-04' ------ '1997-09-17' ------ '1997-09-30' ------ '1997-10-09' ------ '1997-10-19' ------ '1997-10-31' ------ '1997-11-14' ------ '1997-11-24' ------ '1997-12-09' ------ '1997-12-24' ------ '1998-01-04' ------ '1998-01-16' ------ '1998-01-28' ------ '1998-02-07' ------ '1998-02-17' ------ '1998-03-01' ------ '1998-03-12' ------ '1998-03-24' ------ '1998-04-03' ------ '1998-04-14' ------ '1998-04-24' ------ '1998-05-03' ------ '1998-05-14' ------ '1998-05-26' ------ '1998-06-08' ------ '1998-06-20' ------ '1998-06-30' ------ '1998-07-11' ------ '1998-07-22' ------ '1998-08-02' 112 │ │ │ │ │ ├── key: (9) 113 │ │ │ │ │ ├── fd: (9)-->(10,12,13) 114 │ │ │ │ │ └── ordering: +9 115 │ │ │ │ ├── select 116 │ │ │ │ │ ├── save-table-name: q18_select_9 117 │ │ │ │ │ ├── columns: l_orderkey:34(int!null) sum:50(float!null) 118 │ │ │ │ │ ├── stats: [rows=509090, distinct(34)=509090, null(34)=0, distinct(50)=509090, null(50)=0] 119 │ │ │ │ │ ├── key: (34) 120 │ │ │ │ │ ├── fd: (34)-->(50) 121 │ │ │ │ │ ├── ordering: +34 122 │ │ │ │ │ ├── group-by 123 │ │ │ │ │ │ ├── save-table-name: q18_group_by_10 124 │ │ │ │ │ │ ├── columns: l_orderkey:34(int!null) sum:50(float!null) 125 │ │ │ │ │ │ ├── grouping columns: l_orderkey:34(int!null) 126 │ │ │ │ │ │ ├── stats: [rows=1527270, distinct(34)=1527270, null(34)=0, distinct(50)=1527270, null(50)=0] 127 │ │ │ │ │ │ ├── key: (34) 128 │ │ │ │ │ │ ├── fd: (34)-->(50) 129 │ │ │ │ │ │ ├── ordering: +34 130 │ │ │ │ │ │ ├── scan lineitem 131 │ │ │ │ │ │ │ ├── save-table-name: q18_scan_11 132 │ │ │ │ │ │ │ ├── columns: l_orderkey:34(int!null) l_quantity:38(float!null) 133 │ │ │ │ │ │ │ ├── stats: [rows=6001215, distinct(34)=1527270, null(34)=0, distinct(38)=50, null(38)=0] 134 │ │ │ │ │ │ │ │ histogram(34)= 0 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 29405 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 30006 600 135 │ │ │ │ │ │ │ │ <--- 326 ------- 28929 ------- 50503 ------- 89793 ------- 115938 ------- 146944 ------- 176768 ------- 211201 ------- 237860 ------- 266885 ------- 297604 ------- 330021 ------- 365889 ------- 398951 ------- 426117 ------- 451328 ------- 472134 ------- 499590 ------- 529284 ------- 557254 ------- 589154 ------- 619394 ------- 642951 ------- 670113 ------- 692931 ------- 721157 ------- 751687 ------- 777766 ------- 804582 ------- 836740 ------- 868868 ------- 898912 ------- 922500 ------- 946403 ------- 984870 ------- 1007936 ------- 1030117 ------- 1062275 ------- 1093572 ------- 1120709 ------- 1150981 ------- 1182786 ------- 1206406 ------- 1234116 ------- 1260961 ------- 1290502 ------- 1329510 ------- 1355426 ------- 1381313 ------- 1409796 ------- 1445254 ------- 1479233 ------- 1504935 ------- 1531079 ------- 1559650 ------- 1583616 ------- 1617504 ------- 1655749 ------- 1685185 ------- 1718183 ------- 1747716 ------- 1772131 ------- 1802372 ------- 1833315 ------- 1862403 ------- 1897894 ------- 1922819 ------- 1954405 ------- 1979329 ------- 2009859 ------- 2041670 ------- 2070851 ------- 2093828 ------- 2127973 ------- 2167777 ------- 2194883 ------- 2227814 ------- 2262437 ------- 2296353 ------- 2321024 ------- 2346051 ------- 2376257 ------- 2404932 ------- 2446273 ------- 2474081 ------- 2504515 ------- 2535302 ------- 2561413 ------- 2592737 ------- 2616801 ------- 2646112 ------- 2676546 ------- 2702116 ------- 2732454 ------- 2765382 ------- 2799495 ------- 2828866 ------- 2868737 ------- 2910625 ------- 2938464 ------- 2963140 ------- 3003302 ------- 3043264 ------- 3069123 ------- 3095909 ------- 3126693 ------- 3160485 ------- 3196039 ------- 3229504 ------- 3259712 ------- 3286439 ------- 3318852 ------- 3346821 ------- 3370119 ------- 3395204 ------- 3425888 ------- 3448611 ------- 3476130 ------- 3502372 ------- 3529474 ------- 3556390 ------- 3583553 ------- 3612550 ------- 3647875 ------- 3679140 ------- 3702661 ------- 3738017 ------- 3778050 ------- 3806114 ------- 3839074 ------- 3872805 ------- 3905697 ------- 3926212 ------- 3959841 ------- 3997281 ------- 4033861 ------- 4063591 ------- 4097831 ------- 4124807 ------- 4158656 ------- 4195748 ------- 4234274 ------- 4269952 ------- 4298949 ------- 4332806 ------- 4364705 ------- 4398246 ------- 4430695 ------- 4466403 ------- 4494662 ------- 4524420 ------- 4558561 ------- 4601092 ------- 4632871 ------- 4658694 ------- 4690501 ------- 4728066 ------- 4758657 ------- 4788294 ------- 4818597 ------- 4855874 ------- 4890913 ------- 4915366 ------- 4940709 ------- 4972357 ------- 4995298 ------- 5019523 ------- 5043329 ------- 5077376 ------- 5109920 ------- 5136582 ------- 5161152 ------- 5191846 ------- 5219973 ------- 5251015 ------- 5282021 ------- 5312355 ------- 5343207 ------- 5381318 ------- 5416163 ------- 5445382 ------- 5476933 ------- 5509185 ------- 5539237 ------- 5566818 ------- 5588739 ------- 5620481 ------- 5644001 ------- 5667010 ------- 5689476 ------- 5724709 ------- 5755398 ------- 5790598 ------- 5819425 ------- 5846341 ------- 5874656 ------- 5908067 ------- 5933572 ------- 5962659 ------- 5999971 136 │ │ │ │ │ │ │ └── ordering: +34 137 │ │ │ │ │ │ └── aggregations 138 │ │ │ │ │ │ └── sum [as=sum:50, type=float, outer=(38)] 139 │ │ │ │ │ │ └── l_quantity:38 [type=float] 140 │ │ │ │ │ └── filters 141 │ │ │ │ │ └── sum:50 > 300.0 [type=bool, outer=(50), constraints=(/50: [/300.00000000000006 - ]; tight)] 142 │ │ │ │ └── filters (true) 143 │ │ │ ├── scan customer 144 │ │ │ │ ├── save-table-name: q18_scan_12 145 │ │ │ │ ├── columns: c_custkey:1(int!null) c_name:2(varchar!null) 146 │ │ │ │ ├── stats: [rows=150000, distinct(1)=148813, null(1)=0, distinct(2)=150000, null(2)=0] 147 │ │ │ │ │ histogram(1)= 0 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 735 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 750 15 148 │ │ │ │ │ <--- 2 ----- 776 ----- 1422 ----- 2189 ----- 2973 ----- 3583 ----- 4390 ----- 5154 ----- 5962 ----- 6965 ----- 7596 ----- 8303 ----- 9167 ----- 9833 ----- 10695 ----- 11397 ----- 11979 ----- 12651 ----- 13397 ----- 14144 ----- 14951 ----- 15698 ----- 16460 ----- 17203 ----- 17846 ----- 18462 ----- 19390 ----- 20189 ----- 20852 ----- 21642 ----- 22379 ----- 23009 ----- 23856 ----- 24734 ----- 25473 ----- 26231 ----- 26978 ----- 27654 ----- 28276 ----- 29054 ----- 29727 ----- 30527 ----- 31177 ----- 32126 ----- 32984 ----- 33684 ----- 34316 ----- 35070 ----- 35703 ----- 36397 ----- 37156 ----- 37709 ----- 38488 ----- 39131 ----- 39740 ----- 40736 ----- 41459 ----- 42388 ----- 42999 ----- 43844 ----- 44571 ----- 45428 ----- 46283 ----- 46979 ----- 47712 ----- 48708 ----- 49487 ----- 50275 ----- 51131 ----- 51836 ----- 52652 ----- 53389 ----- 54179 ----- 54861 ----- 55609 ----- 56492 ----- 57284 ----- 57917 ----- 58793 ----- 59665 ----- 60285 ----- 60840 ----- 61523 ----- 62354 ----- 63178 ----- 63933 ----- 64642 ----- 65282 ----- 65864 ----- 66755 ----- 67407 ----- 68099 ----- 68875 ----- 69638 ----- 70304 ----- 71016 ----- 71830 ----- 72742 ----- 73590 ----- 74434 ----- 75274 ----- 75861 ----- 76547 ----- 77252 ----- 77978 ----- 78650 ----- 79313 ----- 79925 ----- 80677 ----- 81497 ----- 82205 ----- 82962 ----- 83879 ----- 84815 ----- 85521 ----- 86272 ----- 87140 ----- 87759 ----- 88634 ----- 89452 ----- 90192 ----- 90920 ----- 91756 ----- 92690 ----- 93299 ----- 93950 ----- 94812 ----- 95569 ----- 96295 ----- 96904 ----- 97499 ----- 98144 ----- 98764 ----- 99582 ----- 100453 ----- 101098 ----- 101892 ----- 102700 ----- 103419 ----- 104297 ----- 105040 ----- 105864 ----- 106498 ----- 107196 ----- 108022 ----- 108731 ----- 109398 ----- 110145 ----- 110849 ----- 111758 ----- 112501 ----- 113222 ----- 114019 ----- 114904 ----- 115693 ----- 116350 ----- 116955 ----- 117581 ----- 118366 ----- 119159 ----- 119902 ----- 120535 ----- 121321 ----- 121993 ----- 122769 ----- 123504 ----- 124225 ----- 124992 ----- 125632 ----- 126685 ----- 127641 ----- 128303 ----- 129042 ----- 129589 ----- 130548 ----- 131374 ----- 132325 ----- 133042 ----- 133883 ----- 134716 ----- 135520 ----- 136173 ----- 136858 ----- 137584 ----- 138381 ----- 139162 ----- 139923 ----- 140738 ----- 141557 ----- 142287 ----- 143002 ----- 143794 ----- 144420 ----- 145276 ----- 146100 ----- 146977 ----- 147821 ----- 148440 ----- 149247 ----- 149978 149 │ │ │ │ ├── key: (1) 150 │ │ │ │ └── fd: (1)-->(2) 151 │ │ │ └── filters 152 │ │ │ └── c_custkey:1 = o_custkey:10 [type=bool, outer=(1,10), constraints=(/1: (/NULL - ]; /10: (/NULL - ]), fd=(1)==(10), (10)==(1)] 153 │ │ └── filters 154 │ │ └── o_orderkey:9 = l_orderkey:18 [type=bool, outer=(9,18), constraints=(/9: (/NULL - ]; /18: (/NULL - ]), fd=(9)==(18), (18)==(9)] 155 │ └── aggregations 156 │ ├── sum [as=sum:51, type=float, outer=(22)] 157 │ │ └── l_quantity:22 [type=float] 158 │ ├── const-agg [as=c_custkey:1, type=int, outer=(1)] 159 │ │ └── c_custkey:1 [type=int] 160 │ ├── const-agg [as=c_name:2, type=varchar, outer=(2)] 161 │ │ └── c_name:2 [type=varchar] 162 │ ├── const-agg [as=o_totalprice:12, type=float, outer=(12)] 163 │ │ └── o_totalprice:12 [type=float] 164 │ └── const-agg [as=o_orderdate:13, type=date, outer=(13)] 165 │ └── o_orderdate:13 [type=date] 166 └── 100 [type=int] 167 168 stats table=q18_limit_1 169 ---- 170 column_names row_count distinct_count null_count 171 {c_custkey} 57 57 0 172 {c_name} 57 57 0 173 {o_orderdate} 57 57 0 174 {o_orderkey} 57 57 0 175 {o_totalprice} 57 57 0 176 {sum} 57 18 0 177 ~~~~ 178 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 179 {c_custkey} 100.00 1.75 100.00 1.75 0.00 1.00 180 {c_name} 100.00 1.75 100.00 1.75 0.00 1.00 181 {o_orderdate} 100.00 1.75 100.00 1.75 0.00 1.00 182 {o_orderkey} 100.00 1.75 100.00 1.75 0.00 1.00 183 {o_totalprice} 100.00 1.75 100.00 1.75 0.00 1.00 184 {sum} 100.00 1.75 100.00 5.56 <== 0.00 1.00 185 186 stats table=q18_sort_2 187 ---- 188 column_names row_count distinct_count null_count 189 {c_custkey} 57 57 0 190 {c_name} 57 57 0 191 {o_orderdate} 57 57 0 192 {o_orderkey} 57 57 0 193 {o_totalprice} 57 57 0 194 {sum} 57 18 0 195 ~~~~ 196 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 197 {c_custkey} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 198 {c_name} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 199 {o_orderdate} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 200 {o_orderkey} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 201 {o_totalprice} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 202 {sum} 499392.00 8761.26 <== 499392.00 27744.00 <== 0.00 1.00 203 204 stats table=q18_group_by_3 205 ---- 206 column_names row_count distinct_count null_count 207 {c_custkey} 57 57 0 208 {c_name} 57 57 0 209 {o_orderdate} 57 57 0 210 {o_orderkey} 57 57 0 211 {o_totalprice} 57 57 0 212 {sum} 57 18 0 213 ~~~~ 214 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 215 {c_custkey} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 216 {c_name} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 217 {o_orderdate} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 218 {o_orderkey} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 219 {o_totalprice} 499392.00 8761.26 <== 499392.00 8761.26 <== 0.00 1.00 220 {sum} 499392.00 8761.26 <== 499392.00 27744.00 <== 0.00 1.00 221 222 stats table=q18_inner_join_4 223 ---- 224 column_names row_count distinct_count null_count 225 {c_custkey} 399 57 0 226 {c_name} 399 57 0 227 {l_orderkey} 399 57 0 228 {l_quantity} 399 27 0 229 {o_custkey} 399 57 0 230 {o_orderdate} 399 57 0 231 {o_orderkey} 399 57 0 232 {o_totalprice} 399 57 0 233 ~~~~ 234 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 235 {c_custkey} 2016361.00 5053.54 <== 99649.00 1748.23 <== 0.00 1.00 236 {c_name} 2016361.00 5053.54 <== 150000.00 2631.58 <== 0.00 1.00 237 {l_orderkey} 2016361.00 5053.54 <== 499392.00 8761.26 <== 0.00 1.00 238 {l_quantity} 2016361.00 5053.54 <== 50.00 1.85 0.00 1.00 239 {o_custkey} 2016361.00 5053.54 <== 99649.00 1748.23 <== 0.00 1.00 240 {o_orderdate} 2016361.00 5053.54 <== 2406.00 42.21 <== 0.00 1.00 241 {o_orderkey} 2016361.00 5053.54 <== 499392.00 8761.26 <== 0.00 1.00 242 {o_totalprice} 2016361.00 5053.54 <== 488044.00 8562.18 <== 0.00 1.00 243 244 stats table=q18_scan_5 245 ---- 246 column_names row_count distinct_count null_count 247 {l_orderkey} 6001215 1527270 0 248 {l_quantity} 6001215 50 0 249 ~~~~ 250 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 251 {l_orderkey} 6001215.00 1.00 1527270.00 1.00 0.00 1.00 252 {l_quantity} 6001215.00 1.00 50.00 1.00 0.00 1.00 253 254 stats table=q18_inner_join_6 255 ---- 256 column_names row_count distinct_count null_count 257 {c_custkey} 57 57 0 258 {c_name} 57 57 0 259 {o_custkey} 57 57 0 260 {o_orderdate} 57 57 0 261 {o_orderkey} 57 57 0 262 {o_totalprice} 57 57 0 263 ~~~~ 264 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 265 {c_custkey} 513151.00 9002.65 <== 99649.00 1748.23 <== 0.00 1.00 266 {c_name} 513151.00 9002.65 <== 145098.00 2545.58 <== 0.00 1.00 267 {o_custkey} 513151.00 9002.65 <== 99649.00 1748.23 <== 0.00 1.00 268 {o_orderdate} 513151.00 9002.65 <== 2406.00 42.21 <== 0.00 1.00 269 {o_orderkey} 513151.00 9002.65 <== 323295.00 5671.84 <== 0.00 1.00 270 {o_totalprice} 513151.00 9002.65 <== 322560.00 5658.95 <== 0.00 1.00 271 272 stats table=q18_merge_join_7 273 ---- 274 column_names row_count distinct_count null_count 275 {o_custkey} 57 57 0 276 {o_orderdate} 57 57 0 277 {o_orderkey} 57 57 0 278 {o_totalprice} 57 57 0 279 ~~~~ 280 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 281 {o_custkey} 509090.00 8931.40 <== 99649.00 1748.23 <== 0.00 1.00 282 {o_orderdate} 509090.00 8931.40 <== 2406.00 42.21 <== 0.00 1.00 283 {o_orderkey} 509090.00 8931.40 <== 509090.00 8931.40 <== 0.00 1.00 284 {o_totalprice} 509090.00 8931.40 <== 506350.00 8883.33 <== 0.00 1.00 285 286 stats table=q18_scan_8 287 ---- 288 column_names row_count distinct_count null_count 289 {o_custkey} 1500000 99846 0 290 {o_orderdate} 1500000 2406 0 291 {o_orderkey} 1500000 1527270 0 292 {o_totalprice} 1500000 1459167 0 293 ~~~~ 294 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 295 {o_custkey} 1500000.00 1.00 99846.00 1.00 0.00 1.00 296 {o_orderdate} 1500000.00 1.00 2406.00 1.00 0.00 1.00 297 {o_orderkey} 1500000.00 1.00 1500000.00 1.02 0.00 1.00 298 {o_totalprice} 1500000.00 1.00 1459167.00 1.00 0.00 1.00 299 300 stats table=q18_select_9 301 ---- 302 column_names row_count distinct_count null_count 303 {l_orderkey} 57 57 0 304 {sum} 57 18 0 305 ~~~~ 306 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 307 {l_orderkey} 509090.00 8931.40 <== 509090.00 8931.40 <== 0.00 1.00 308 {sum} 509090.00 8931.40 <== 509090.00 28282.78 <== 0.00 1.00 309 310 stats table=q18_group_by_10 311 ---- 312 column_names row_count distinct_count null_count 313 {l_orderkey} 1500000 1527270 0 314 {sum} 1500000 318 0 315 ~~~~ 316 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 317 {l_orderkey} 1527270.00 1.02 1527270.00 1.00 0.00 1.00 318 {sum} 1527270.00 1.02 1527270.00 4802.74 <== 0.00 1.00 319 320 stats table=q18_scan_11 321 ---- 322 column_names row_count distinct_count null_count 323 {l_orderkey} 6001215 1527270 0 324 {l_quantity} 6001215 50 0 325 ~~~~ 326 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 327 {l_orderkey} 6001215.00 1.00 1527270.00 1.00 0.00 1.00 328 {l_quantity} 6001215.00 1.00 50.00 1.00 0.00 1.00 329 330 stats table=q18_scan_12 331 ---- 332 column_names row_count distinct_count null_count 333 {c_custkey} 150000 148813 0 334 {c_name} 150000 151126 0 335 ~~~~ 336 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 337 {c_custkey} 150000.00 1.00 148813.00 1.00 0.00 1.00 338 {c_name} 150000.00 1.00 150000.00 1.01 0.00 1.00