github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/stats_quality/tpch/q21 (about) 1 import file=tpch_schema 2 ---- 3 4 import file=tpch_stats 5 ---- 6 7 # -------------------------------------------------- 8 # Q21 9 # Suppliers Who Kept Orders Waiting Query 10 # Identifies certain suppliers who were not able to ship required parts in a 11 # timely manner. 12 # 13 # Identifies suppliers, for a given nation, whose product was part of a multi- 14 # supplier order (with current status of 'F') where they were the only supplier 15 # who failed to meet the committed delivery date. 16 # -------------------------------------------------- 17 save-tables database=tpch save-tables-prefix=q21 18 SELECT 19 s_name, 20 count(*) AS numwait 21 FROM 22 supplier, 23 lineitem l1, 24 orders, 25 nation 26 WHERE 27 s_suppkey = l1.l_suppkey 28 AND o_orderkey = l1.l_orderkey 29 AND o_orderstatus = 'F' 30 AND l1.l_receiptDATE > l1.l_commitdate 31 AND EXISTS ( 32 SELECT 33 * 34 FROM 35 lineitem l2 36 WHERE 37 l2.l_orderkey = l1.l_orderkey 38 AND l2.l_suppkey <> l1.l_suppkey 39 ) 40 AND NOT EXISTS ( 41 SELECT 42 * 43 FROM 44 lineitem l3 45 WHERE 46 l3.l_orderkey = l1.l_orderkey 47 AND l3.l_suppkey <> l1.l_suppkey 48 AND l3.l_receiptDATE > l3.l_commitdate 49 ) 50 AND s_nationkey = n_nationkey 51 AND n_name = 'SAUDI ARABIA' 52 GROUP BY 53 s_name 54 ORDER BY 55 numwait DESC, 56 s_name 57 LIMIT 100; 58 ---- 59 limit 60 ├── save-table-name: q21_limit_1 61 ├── columns: s_name:2(char!null) numwait:69(int!null) 62 ├── internal-ordering: -69,+2 63 ├── cardinality: [0 - 100] 64 ├── stats: [rows=100, distinct(2)=100, null(2)=0, distinct(69)=100, null(69)=0] 65 ├── key: (2) 66 ├── fd: (2)-->(69) 67 ├── ordering: -69,+2 68 ├── sort 69 │ ├── save-table-name: q21_sort_2 70 │ ├── columns: s_name:2(char!null) count_rows:69(int!null) 71 │ ├── stats: [rows=8329.18391, distinct(2)=8329.18391, null(2)=0, distinct(69)=8329.18391, null(69)=0] 72 │ ├── key: (2) 73 │ ├── fd: (2)-->(69) 74 │ ├── ordering: -69,+2 75 │ ├── limit hint: 100.00 76 │ └── group-by 77 │ ├── save-table-name: q21_group_by_3 78 │ ├── columns: s_name:2(char!null) count_rows:69(int!null) 79 │ ├── grouping columns: s_name:2(char!null) 80 │ ├── stats: [rows=8329.18391, distinct(2)=8329.18391, null(2)=0, distinct(69)=8329.18391, null(69)=0] 81 │ ├── key: (2) 82 │ ├── fd: (2)-->(69) 83 │ ├── inner-join (lookup orders) 84 │ │ ├── save-table-name: q21_lookup_join_4 85 │ │ ├── columns: s_suppkey:1(int!null) s_name:2(char!null) s_nationkey:4(int!null) l1.l_orderkey:8(int!null) l1.l_suppkey:10(int!null) l1.l_commitdate:19(date!null) l1.l_receiptdate:20(date!null) o_orderkey:24(int!null) o_orderstatus:26(char!null) n_nationkey:33(int!null) n_name:34(char!null) 86 │ │ ├── key columns: [8] = [24] 87 │ │ ├── lookup columns are key 88 │ │ ├── stats: [rows=17924.776, distinct(1)=9920, null(1)=0, distinct(2)=8329.18391, null(2)=0, distinct(4)=1, null(4)=0, distinct(8)=17568.2329, null(8)=0, distinct(10)=9920, null(10)=0, distinct(19)=2464.28129, null(19)=0, distinct(20)=2551.71335, null(20)=0, distinct(24)=17568.2329, null(24)=0, distinct(26)=1, null(26)=0, distinct(33)=1, null(33)=0, distinct(34)=1, null(34)=0] 89 │ │ ├── fd: ()-->(26,34), (1)-->(2,4), (8)==(24), (24)==(8), (1)==(10), (10)==(1), (4)==(33), (33)==(4) 90 │ │ ├── inner-join (hash) 91 │ │ │ ├── save-table-name: q21_inner_join_5 92 │ │ │ ├── columns: s_suppkey:1(int!null) s_name:2(char!null) s_nationkey:4(int!null) l1.l_orderkey:8(int!null) l1.l_suppkey:10(int!null) l1.l_commitdate:19(date!null) l1.l_receiptdate:20(date!null) n_nationkey:33(int!null) n_name:34(char!null) 93 │ │ │ ├── stats: [rows=17924.776, distinct(1)=9920, null(1)=0, distinct(2)=8329.18391, null(2)=0, distinct(4)=1, null(4)=0, distinct(8)=17568.2329, null(8)=0, distinct(10)=9920, null(10)=0, distinct(19)=2464.28129, null(19)=0, distinct(20)=2551.71335, null(20)=0, distinct(33)=1, null(33)=0, distinct(34)=1, null(34)=0] 94 │ │ │ ├── fd: ()-->(34), (1)-->(2,4), (1)==(10), (10)==(1), (4)==(33), (33)==(4) 95 │ │ │ ├── semi-join (hash) 96 │ │ │ │ ├── save-table-name: q21_semi_join_6 97 │ │ │ │ ├── columns: l1.l_orderkey:8(int!null) l1.l_suppkey:10(int!null) l1.l_commitdate:19(date!null) l1.l_receiptdate:20(date!null) 98 │ │ │ │ ├── stats: [rows=444534.444, distinct(8)=444534.444, null(8)=0, distinct(10)=9920, null(10)=0, distinct(19)=2466, null(19)=0, distinct(20)=2554, null(20)=0] 99 │ │ │ │ ├── anti-join (merge) 100 │ │ │ │ │ ├── save-table-name: q21_merge_join_7 101 │ │ │ │ │ ├── columns: l1.l_orderkey:8(int!null) l1.l_suppkey:10(int!null) l1.l_commitdate:19(date!null) l1.l_receiptdate:20(date!null) 102 │ │ │ │ │ ├── left ordering: +8 103 │ │ │ │ │ ├── right ordering: +53 104 │ │ │ │ │ ├── stats: [rows=1333603.33, distinct(8)=1016901.08, null(8)=0, distinct(10)=9920, null(10)=0, distinct(19)=2466, null(19)=0, distinct(20)=2554, null(20)=0] 105 │ │ │ │ │ ├── select 106 │ │ │ │ │ │ ├── save-table-name: q21_select_8 107 │ │ │ │ │ │ ├── columns: l1.l_orderkey:8(int!null) l1.l_suppkey:10(int!null) l1.l_commitdate:19(date!null) l1.l_receiptdate:20(date!null) 108 │ │ │ │ │ │ ├── stats: [rows=2000405, distinct(8)=1216823.04, null(8)=0, distinct(10)=9920, null(10)=0, distinct(19)=2466, null(19)=0, distinct(20)=2554, null(20)=0] 109 │ │ │ │ │ │ ├── ordering: +8 110 │ │ │ │ │ │ ├── scan l1 111 │ │ │ │ │ │ │ ├── save-table-name: q21_scan_9 112 │ │ │ │ │ │ │ ├── columns: l1.l_orderkey:8(int!null) l1.l_suppkey:10(int!null) l1.l_commitdate:19(date!null) l1.l_receiptdate:20(date!null) 113 │ │ │ │ │ │ │ ├── stats: [rows=6001215, distinct(8)=1527270, null(8)=0, distinct(10)=9920, null(10)=0, distinct(19)=2466, null(19)=0, distinct(20)=2554, null(20)=0] 114 │ │ │ │ │ │ │ │ histogram(8)= 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 115 │ │ │ │ │ │ │ │ <--- 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 116 │ │ │ │ │ │ │ │ histogram(10)= 0 600 28805 3000 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 1200 29405 1200 28805 1200 28805 1800 29405 600 29405 1200 29405 600 29405 600 28805 1200 29405 1200 28805 1200 28205 1800 29405 1200 29405 600 29405 1200 29405 1200 29405 600 29405 1200 29405 1200 28805 1800 29405 600 28805 1800 28805 1200 28805 1200 29405 1200 28805 1800 29405 600 28205 1800 29405 600 29405 600 28805 1200 29405 600 28805 1200 29405 600 29405 600 28805 1200 28805 1800 27605 2400 29405 600 28205 1800 29405 2400 29405 600 28805 1800 28205 1800 28805 1200 29405 3000 29405 1200 29405 1800 29405 600 29405 600 28205 1800 29405 600 29405 1800 29405 1800 29405 600 29405 600 28805 1200 28805 1200 29405 1200 28205 1800 29405 600 28805 1200 27605 2400 29405 600 29405 1200 29405 1200 29405 600 29405 1800 29405 1200 28205 1800 29405 600 29405 1200 29405 1200 28805 1200 28205 1800 29405 1800 28805 1200 29405 600 29405 1800 28205 2400 29405 600 28805 1200 28205 2400 28805 1200 27605 2400 28805 1200 29405 600 28805 1800 29405 1800 28805 600 28205 1800 28805 600 29405 600 29405 1200 28805 600 28805 1200 29405 1800 27605 1800 27605 2400 27605 1800 29405 1200 28805 600 28805 1200 29405 1200 28805 2400 28805 1200 28805 600 28205 1200 28205 1200 29405 600 28805 1200 29405 600 28205 2400 28205 1200 29405 600 29405 1800 28805 1200 28205 1200 27605 2400 27605 1800 28805 1200 29405 600 28805 1200 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 28805 1200 29405 1200 28805 600 29405 1800 28205 1200 27605 1800 29405 600 29405 600 29405 1200 28805 1200 28805 1200 28205 1200 29405 1800 28205 1800 28805 600 28805 1200 28205 1200 29405 600 28805 1800 28205 1800 27605 2400 28805 600 29405 600 28805 1200 29405 600 28805 2400 28805 1200 28805 1200 28805 600 28205 1200 28805 1200 29405 600 29405 600 29405 1800 28805 600 28805 600 28805 2400 28805 600 28805 1800 28805 1200 28805 600 27005 2400 29405 600 28205 1800 29405 1200 27605 1800 28805 1200 28805 1200 29405 600 29405 600 29405 600 29405 1200 28805 600 29405 600 27605 2400 28805 1200 29405 600 28805 1800 28805 1800 28205 1200 28805 1200 28805 600 29405 1200 28205 1200 117 │ │ │ │ │ │ │ │ <--- 6 ------- 59 ------- 106 ------- 147 ------- 189 ------- 219 ------- 272 ------- 335 ------- 387 ------- 433 ------- 485 ------- 539 ------- 600 ------- 653 ------- 698 ------- 749 ------- 806 ------- 855 ------- 904 ------- 961 ------- 1008 ------- 1065 ------- 1115 ------- 1163 ------- 1212 ------- 1270 ------- 1329 ------- 1373 ------- 1417 ------- 1470 ------- 1514 ------- 1566 ------- 1616 ------- 1668 ------- 1719 ------- 1765 ------- 1819 ------- 1871 ------- 1926 ------- 1978 ------- 2030 ------- 2080 ------- 2128 ------- 2173 ------- 2223 ------- 2270 ------- 2318 ------- 2382 ------- 2444 ------- 2491 ------- 2534 ------- 2584 ------- 2632 ------- 2675 ------- 2736 ------- 2781 ------- 2841 ------- 2905 ------- 2940 ------- 2996 ------- 3045 ------- 3084 ------- 3124 ------- 3181 ------- 3224 ------- 3268 ------- 3318 ------- 3362 ------- 3419 ------- 3466 ------- 3515 ------- 3560 ------- 3615 ------- 3669 ------- 3725 ------- 3777 ------- 3825 ------- 3871 ------- 3923 ------- 3980 ------- 4035 ------- 4078 ------- 4135 ------- 4184 ------- 4244 ------- 4296 ------- 4346 ------- 4396 ------- 4444 ------- 4489 ------- 4540 ------- 4575 ------- 4627 ------- 4683 ------- 4731 ------- 4777 ------- 4831 ------- 4900 ------- 4953 ------- 5006 ------- 5061 ------- 5119 ------- 5161 ------- 5208 ------- 5260 ------- 5315 ------- 5361 ------- 5415 ------- 5474 ------- 5529 ------- 5572 ------- 5635 ------- 5689 ------- 5738 ------- 5792 ------- 5835 ------- 5890 ------- 5935 ------- 5997 ------- 6039 ------- 6094 ------- 6151 ------- 6201 ------- 6245 ------- 6291 ------- 6343 ------- 6387 ------- 6437 ------- 6480 ------- 6540 ------- 6580 ------- 6629 ------- 6673 ------- 6718 ------- 6771 ------- 6823 ------- 6878 ------- 6935 ------- 6974 ------- 7017 ------- 7060 ------- 7112 ------- 7170 ------- 7231 ------- 7279 ------- 7329 ------- 7373 ------- 7427 ------- 7477 ------- 7520 ------- 7564 ------- 7616 ------- 7671 ------- 7716 ------- 7760 ------- 7815 ------- 7861 ------- 7917 ------- 7969 ------- 8018 ------- 8063 ------- 8112 ------- 8180 ------- 8229 ------- 8268 ------- 8320 ------- 8376 ------- 8432 ------- 8474 ------- 8522 ------- 8569 ------- 8616 ------- 8664 ------- 8705 ------- 8765 ------- 8814 ------- 8868 ------- 8906 ------- 8948 ------- 8990 ------- 9035 ------- 9090 ------- 9137 ------- 9188 ------- 9241 ------- 9292 ------- 9354 ------- 9411 ------- 9472 ------- 9526 ------- 9569 ------- 9613 ------- 9658 ------- 9708 ------- 9737 ------- 9792 ------- 9838 ------- 9903 ------- 9952 ------- 10000 118 │ │ │ │ │ │ │ │ histogram(19)= 0 600 28805 1200 29405 3600 29405 1200 29405 1800 28205 1800 28805 4200 28205 3600 27005 4800 29405 3600 29405 1800 26405 3600 29405 600 27005 3000 29405 2400 28805 3000 29405 600 25805 4800 28805 3000 27605 2400 27605 5401 28805 3600 28805 2400 27605 3600 28805 6001 28805 3600 27005 3000 25205 4800 28805 4200 28205 1200 28805 3600 28205 4200 27605 3000 28205 3600 28805 1200 27605 3000 28205 1200 27005 3000 28805 1200 28205 1800 28205 1800 27605 1800 27605 3600 27605 3600 25805 5401 28805 4200 28205 1200 28805 3000 28805 4800 28805 1200 28805 4200 28205 2400 26405 3000 28205 3000 28805 2400 28805 2400 27605 5401 28805 1800 28805 2400 28805 1200 28805 3600 27605 5401 25805 5401 28205 3600 27005 3600 28205 3000 28805 1200 28805 4800 28205 2400 24604 5401 28805 3000 27605 2400 28205 4200 27005 3000 28805 3000 28805 600 26405 5401 27605 4800 27005 2400 26405 4200 28805 2400 27605 3000 28205 3000 27005 2400 26405 3600 28205 1200 27605 4200 27605 3000 28205 1800 25805 3000 28205 2400 28205 1200 27005 2400 27605 1800 25805 3600 27005 6601 27005 1800 24004 6001 27605 1800 28205 3000 27605 2400 27605 2400 27605 3000 27605 2400 28205 3000 26405 2400 26405 2400 26405 2400 26405 3600 28205 1800 28205 2400 27605 1200 27605 3000 27605 4800 24604 4200 28205 3000 24604 6001 25805 4200 25205 4200 26405 3000 28205 3000 27605 3000 28205 600 27605 3600 25805 4200 27005 3600 28205 600 28205 3000 28205 1200 25805 3000 28205 1200 27005 3000 28205 1200 24604 4200 27605 1800 28205 4200 27605 2400 26405 4200 27005 2400 27005 1800 27605 3600 25205 4800 27605 2400 28205 1800 27005 3000 27605 3000 25205 4200 25805 3000 27605 3600 25805 3600 27605 1800 24604 4200 25805 3600 26405 1800 27005 3000 27005 1200 27005 3000 24004 5401 26405 1800 25805 2400 27605 1200 27605 600 27005 2400 27605 1200 23404 7201 25205 3600 26405 3000 27605 3600 27605 2400 24604 3600 27605 4200 27605 3600 27005 1200 26405 1200 25805 1800 25205 3600 22804 4800 24604 3000 24004 3600 26405 2400 24604 4800 26405 3000 22204 5401 25805 2400 25205 2400 27005 2400 24604 4200 25205 3000 24004 4800 25205 3000 26405 1200 27005 2400 26405 2400 26405 4800 25205 3000 25805 1800 24004 4800 24604 3000 23404 600 24004 600 119 │ │ │ │ │ │ │ │ <--- '1992-02-06' ------- '1992-03-13' ------- '1992-03-29' ------- '1992-04-12' ------- '1992-04-24' ------- '1992-05-07' ------- '1992-05-18' ------- '1992-05-30' ------- '1992-06-15' ------- '1992-06-28' ------- '1992-07-10' ------- '1992-07-20' ------- '1992-08-04' ------- '1992-08-17' ------- '1992-08-30' ------- '1992-09-11' ------- '1992-09-25' ------- '1992-10-05' ------- '1992-10-16' ------- '1992-10-29' ------- '1992-11-10' ------- '1992-11-24' ------- '1992-12-05' ------- '1992-12-16' ------- '1992-12-31' ------- '1993-01-15' ------- '1993-01-28' ------- '1993-02-09' ------- '1993-02-21' ------- '1993-03-07' ------- '1993-03-17' ------- '1993-04-03' ------- '1993-04-17' ------- '1993-04-30' ------- '1993-05-12' ------- '1993-05-25' ------- '1993-06-08' ------- '1993-06-23' ------- '1993-07-04' ------- '1993-07-18' ------- '1993-08-02' ------- '1993-08-13' ------- '1993-08-24' ------- '1993-09-08' ------- '1993-09-20' ------- '1993-10-06' ------- '1993-10-22' ------- '1993-11-01' ------- '1993-11-14' ------- '1993-11-24' ------- '1993-12-07' ------- '1993-12-20' ------- '1994-01-01' ------- '1994-01-14' ------- '1994-01-31' ------- '1994-02-14' ------- '1994-02-26' ------- '1994-03-09' ------- '1994-03-22' ------- '1994-04-03' ------- '1994-04-14' ------- '1994-04-23' ------- '1994-05-07' ------- '1994-05-19' ------- '1994-05-31' ------- '1994-06-12' ------- '1994-06-22' ------- '1994-07-03' ------- '1994-07-14' ------- '1994-07-24' ------- '1994-08-04' ------- '1994-08-16' ------- '1994-08-29' ------- '1994-09-08' ------- '1994-09-23' ------- '1994-10-05' ------- '1994-10-16' ------- '1994-10-28' ------- '1994-11-08' ------- '1994-11-19' ------- '1994-12-05' ------- '1994-12-18' ------- '1994-12-29' ------- '1995-01-11' ------- '1995-01-23' ------- '1995-02-05' ------- '1995-02-15' ------- '1995-03-02' ------- '1995-03-14' ------- '1995-03-25' ------- '1995-04-05' ------- '1995-04-17' ------- '1995-04-30' ------- '1995-05-11' ------- '1995-05-23' ------- '1995-06-06' ------- '1995-06-20' ------- '1995-06-30' ------- '1995-07-12' ------- '1995-07-26' ------- '1995-08-07' ------- '1995-08-17' ------- '1995-08-28' ------- '1995-09-09' ------- '1995-09-21' ------- '1995-10-04' ------- '1995-10-14' ------- '1995-10-28' ------- '1995-11-07' ------- '1995-11-18' ------- '1995-11-29' ------- '1995-12-11' ------- '1995-12-21' ------- '1995-12-31' ------- '1996-01-11' ------- '1996-01-21' ------- '1996-01-31' ------- '1996-02-10' ------- '1996-02-24' ------- '1996-03-04' ------- '1996-03-13' ------- '1996-03-25' ------- '1996-04-07' ------- '1996-04-17' ------- '1996-04-28' ------- '1996-05-10' ------- '1996-05-22' ------- '1996-06-02' ------- '1996-06-15' ------- '1996-06-26' ------- '1996-07-09' ------- '1996-07-20' ------- '1996-07-31' ------- '1996-08-11' ------- '1996-08-25' ------- '1996-09-07' ------- '1996-09-21' ------- '1996-10-04' ------- '1996-10-15' ------- '1996-10-27' ------- '1996-11-07' ------- '1996-11-19' ------- '1996-11-30' ------- '1996-12-13' ------- '1996-12-27' ------- '1997-01-06' ------- '1997-01-18' ------- '1997-01-30' ------- '1997-02-12' ------- '1997-02-23' ------- '1997-03-07' ------- '1997-03-19' ------- '1997-03-31' ------- '1997-04-10' ------- '1997-04-23' ------- '1997-05-04' ------- '1997-05-17' ------- '1997-05-29' ------- '1997-06-12' ------- '1997-06-23' ------- '1997-07-04' ------- '1997-07-16' ------- '1997-07-28' ------- '1997-08-07' ------- '1997-08-19' ------- '1997-08-29' ------- '1997-09-10' ------- '1997-09-20' ------- '1997-10-03' ------- '1997-10-13' ------- '1997-10-25' ------- '1997-11-05' ------- '1997-11-17' ------- '1997-12-02' ------- '1997-12-15' ------- '1997-12-26' ------- '1998-01-07' ------- '1998-01-16' ------- '1998-01-25' ------- '1998-02-07' ------- '1998-02-20' ------- '1998-03-06' ------- '1998-03-14' ------- '1998-03-30' ------- '1998-04-08' ------- '1998-04-21' ------- '1998-05-03' ------- '1998-05-15' ------- '1998-05-27' ------- '1998-06-07' ------- '1998-06-19' ------- '1998-07-03' ------- '1998-07-15' ------- '1998-07-26' ------- '1998-08-07' ------- '1998-08-18' ------- '1998-08-30' ------- '1998-09-12' ------- '1998-10-01' ------- '1998-10-30' 120 │ │ │ │ │ │ │ │ histogram(20)= 0 1200 29405 1200 29405 1200 29405 1200 27605 2400 24004 6001 27605 5401 28205 4200 29405 2400 29405 1200 28205 4200 27005 3000 27005 3000 29405 4800 27605 3000 28205 1800 27605 2400 26405 3600 27605 4800 27605 3600 28805 3000 28205 6001 28205 1800 26405 3600 27005 4200 29405 4200 27605 2400 27605 1800 27005 3600 24604 4800 27605 3000 27605 1800 28205 2400 28205 3000 28805 1800 28805 600 28205 1200 27005 2400 27605 1800 26405 3000 26405 4800 28205 2400 28805 1200 28805 3600 28205 3000 28205 1200 28205 1200 25805 4200 28205 4800 26405 6001 28205 1800 27005 3000 28205 1800 27605 3000 28205 1200 28205 2400 27605 3000 28805 1800 26405 4200 28805 1800 24604 4800 28805 1200 27005 3000 26405 7201 25805 4800 28805 4200 28805 3600 25205 4200 27005 4800 27605 3600 28205 4200 28805 1800 27005 2400 28805 1800 27005 3000 28205 2400 28205 2400 27005 2400 25805 3600 26405 3600 28805 3600 25805 4200 28805 4200 28205 2400 26405 3600 27005 2400 27605 3600 28805 600 27005 4800 28205 1800 26405 4800 26405 3600 26405 3000 27005 3000 27605 2400 28205 4200 28805 1800 28205 2400 26405 4200 28805 4200 28205 1800 25205 4200 28805 4800 27605 4200 27605 3000 28805 1200 28805 3000 28205 2400 26405 4200 28805 4200 27605 1200 27605 2400 24604 4800 27605 3000 28205 3000 24604 5401 27605 4200 26405 3600 25805 4200 25805 4200 22804 6001 27605 3000 28205 2400 27005 4800 27605 1200 25205 4200 27605 2400 28205 3600 26405 2400 27005 3600 27005 1800 27605 1800 27005 2400 23404 5401 27605 3600 27605 3600 27605 4200 26405 3000 27605 1200 28205 3000 25205 4800 27605 3600 28205 3600 26405 2400 22204 6601 27005 2400 28205 4800 25805 3000 25805 3600 28205 4200 27605 3000 25205 4800 26405 2400 27005 1200 27605 2400 26405 2400 27605 3000 25205 3000 27005 1200 26405 3000 25805 4800 27605 1800 26405 4200 26405 1800 27005 2400 24604 4200 25205 3600 25205 4200 25805 4200 25805 3600 25805 4200 27005 3000 22204 6001 27605 3000 25805 1800 27005 1200 25205 4200 27005 4200 27005 3000 27005 1800 25805 3000 25805 2400 25805 1800 25805 3600 25805 1800 25205 4200 24004 3600 23404 6601 26405 1800 25205 3600 26405 3600 22804 4200 24604 2400 22204 4200 24604 1800 24004 2400 26405 600 26405 600 25805 1200 26405 600 121 │ │ │ │ │ │ │ │ <--- '1992-01-19' ------- '1992-03-11' ------- '1992-04-04' ------- '1992-04-23' ------- '1992-05-09' ------- '1992-05-21' ------- '1992-06-06' ------- '1992-06-17' ------- '1992-07-02' ------- '1992-07-17' ------- '1992-07-28' ------- '1992-08-09' ------- '1992-08-21' ------- '1992-09-01' ------- '1992-09-13' ------- '1992-09-23' ------- '1992-10-08' ------- '1992-10-25' ------- '1992-11-06' ------- '1992-11-18' ------- '1992-12-01' ------- '1992-12-12' ------- '1992-12-24' ------- '1993-01-04' ------- '1993-01-15' ------- '1993-01-27' ------- '1993-02-09' ------- '1993-02-20' ------- '1993-03-05' ------- '1993-03-18' ------- '1993-04-01' ------- '1993-04-13' ------- '1993-04-29' ------- '1993-05-13' ------- '1993-05-27' ------- '1993-06-08' ------- '1993-06-20' ------- '1993-07-03' ------- '1993-07-15' ------- '1993-07-29' ------- '1993-08-11' ------- '1993-08-25' ------- '1993-09-08' ------- '1993-09-21' ------- '1993-10-02' ------- '1993-10-15' ------- '1993-10-29' ------- '1993-11-08' ------- '1993-11-20' ------- '1993-12-05' ------- '1993-12-17' ------- '1993-12-30' ------- '1994-01-13' ------- '1994-01-26' ------- '1994-02-08' ------- '1994-02-19' ------- '1994-03-04' ------- '1994-03-14' ------- '1994-03-26' ------- '1994-04-08' ------- '1994-04-21' ------- '1994-05-03' ------- '1994-05-14' ------- '1994-05-24' ------- '1994-06-03' ------- '1994-06-15' ------- '1994-06-27' ------- '1994-07-07' ------- '1994-07-16' ------- '1994-07-26' ------- '1994-08-10' ------- '1994-08-22' ------- '1994-09-03' ------- '1994-09-15' ------- '1994-09-27' ------- '1994-10-11' ------- '1994-10-22' ------- '1994-11-02' ------- '1994-11-14' ------- '1994-11-26' ------- '1994-12-10' ------- '1994-12-22' ------- '1995-01-04' ------- '1995-01-19' ------- '1995-01-30' ------- '1995-02-13' ------- '1995-02-23' ------- '1995-03-07' ------- '1995-03-17' ------- '1995-03-28' ------- '1995-04-11' ------- '1995-04-22' ------- '1995-05-03' ------- '1995-05-17' ------- '1995-05-29' ------- '1995-06-11' ------- '1995-06-26' ------- '1995-07-06' ------- '1995-07-18' ------- '1995-08-01' ------- '1995-08-14' ------- '1995-08-27' ------- '1995-09-09' ------- '1995-09-22' ------- '1995-10-03' ------- '1995-10-14' ------- '1995-10-26' ------- '1995-11-07' ------- '1995-11-19' ------- '1995-11-30' ------- '1995-12-12' ------- '1995-12-25' ------- '1996-01-03' ------- '1996-01-12' ------- '1996-01-24' ------- '1996-02-03' ------- '1996-02-13' ------- '1996-02-25' ------- '1996-03-06' ------- '1996-03-15' ------- '1996-03-25' ------- '1996-04-08' ------- '1996-04-21' ------- '1996-05-01' ------- '1996-05-13' ------- '1996-05-24' ------- '1996-06-03' ------- '1996-06-17' ------- '1996-06-29' ------- '1996-07-09' ------- '1996-07-22' ------- '1996-08-04' ------- '1996-08-17' ------- '1996-08-29' ------- '1996-09-09' ------- '1996-09-21' ------- '1996-10-02' ------- '1996-10-13' ------- '1996-10-27' ------- '1996-11-10' ------- '1996-11-23' ------- '1996-12-03' ------- '1996-12-17' ------- '1996-12-28' ------- '1997-01-08' ------- '1997-01-18' ------- '1997-01-30' ------- '1997-02-11' ------- '1997-02-23' ------- '1997-03-10' ------- '1997-03-20' ------- '1997-03-31' ------- '1997-04-10' ------- '1997-04-23' ------- '1997-05-06' ------- '1997-05-18' ------- '1997-05-30' ------- '1997-06-12' ------- '1997-06-24' ------- '1997-07-07' ------- '1997-07-20' ------- '1997-08-03' ------- '1997-08-16' ------- '1997-08-27' ------- '1997-09-08' ------- '1997-09-18' ------- '1997-10-01' ------- '1997-10-10' ------- '1997-10-20' ------- '1997-11-01' ------- '1997-11-13' ------- '1997-11-27' ------- '1997-12-06' ------- '1997-12-19' ------- '1997-12-29' ------- '1998-01-10' ------- '1998-01-20' ------- '1998-02-03' ------- '1998-02-17' ------- '1998-02-28' ------- '1998-03-11' ------- '1998-03-24' ------- '1998-04-05' ------- '1998-04-17' ------- '1998-05-01' ------- '1998-05-11' ------- '1998-05-22' ------- '1998-06-03' ------- '1998-06-13' ------- '1998-06-27' ------- '1998-07-12' ------- '1998-07-21' ------- '1998-07-31' ------- '1998-08-08' ------- '1998-08-22' ------- '1998-09-03' ------- '1998-09-16' ------- '1998-10-03' ------- '1998-10-26' ------- '1998-12-16' 122 │ │ │ │ │ │ │ └── ordering: +8 123 │ │ │ │ │ │ └── filters 124 │ │ │ │ │ │ └── l1.l_receiptdate:20 > l1.l_commitdate:19 [type=bool, outer=(19,20), constraints=(/19: (/NULL - ]; /20: (/NULL - ])] 125 │ │ │ │ │ ├── select 126 │ │ │ │ │ │ ├── save-table-name: q21_select_10 127 │ │ │ │ │ │ ├── columns: l3.l_orderkey:53(int!null) l3.l_suppkey:55(int!null) l3.l_commitdate:64(date!null) l3.l_receiptdate:65(date!null) 128 │ │ │ │ │ │ ├── stats: [rows=2000405, distinct(53)=1216823.04, null(53)=0, distinct(55)=9920, null(55)=0, distinct(64)=2466, null(64)=0, distinct(65)=2554, null(65)=0] 129 │ │ │ │ │ │ ├── ordering: +53 130 │ │ │ │ │ │ ├── scan l3 131 │ │ │ │ │ │ │ ├── save-table-name: q21_scan_11 132 │ │ │ │ │ │ │ ├── columns: l3.l_orderkey:53(int!null) l3.l_suppkey:55(int!null) l3.l_commitdate:64(date!null) l3.l_receiptdate:65(date!null) 133 │ │ │ │ │ │ │ ├── stats: [rows=6001215, distinct(53)=1527270, null(53)=0, distinct(55)=9920, null(55)=0, distinct(64)=2466, null(64)=0, distinct(65)=2554, null(65)=0] 134 │ │ │ │ │ │ │ │ histogram(53)= 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 │ │ │ │ │ │ │ │ histogram(55)= 0 600 28805 3000 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 1200 29405 1200 28805 1200 28805 1800 29405 600 29405 1200 29405 600 29405 600 28805 1200 29405 1200 28805 1200 28205 1800 29405 1200 29405 600 29405 1200 29405 1200 29405 600 29405 1200 29405 1200 28805 1800 29405 600 28805 1800 28805 1200 28805 1200 29405 1200 28805 1800 29405 600 28205 1800 29405 600 29405 600 28805 1200 29405 600 28805 1200 29405 600 29405 600 28805 1200 28805 1800 27605 2400 29405 600 28205 1800 29405 2400 29405 600 28805 1800 28205 1800 28805 1200 29405 3000 29405 1200 29405 1800 29405 600 29405 600 28205 1800 29405 600 29405 1800 29405 1800 29405 600 29405 600 28805 1200 28805 1200 29405 1200 28205 1800 29405 600 28805 1200 27605 2400 29405 600 29405 1200 29405 1200 29405 600 29405 1800 29405 1200 28205 1800 29405 600 29405 1200 29405 1200 28805 1200 28205 1800 29405 1800 28805 1200 29405 600 29405 1800 28205 2400 29405 600 28805 1200 28205 2400 28805 1200 27605 2400 28805 1200 29405 600 28805 1800 29405 1800 28805 600 28205 1800 28805 600 29405 600 29405 1200 28805 600 28805 1200 29405 1800 27605 1800 27605 2400 27605 1800 29405 1200 28805 600 28805 1200 29405 1200 28805 2400 28805 1200 28805 600 28205 1200 28205 1200 29405 600 28805 1200 29405 600 28205 2400 28205 1200 29405 600 29405 1800 28805 1200 28205 1200 27605 2400 27605 1800 28805 1200 29405 600 28805 1200 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 28805 1200 29405 1200 28805 600 29405 1800 28205 1200 27605 1800 29405 600 29405 600 29405 1200 28805 1200 28805 1200 28205 1200 29405 1800 28205 1800 28805 600 28805 1200 28205 1200 29405 600 28805 1800 28205 1800 27605 2400 28805 600 29405 600 28805 1200 29405 600 28805 2400 28805 1200 28805 1200 28805 600 28205 1200 28805 1200 29405 600 29405 600 29405 1800 28805 600 28805 600 28805 2400 28805 600 28805 1800 28805 1200 28805 600 27005 2400 29405 600 28205 1800 29405 1200 27605 1800 28805 1200 28805 1200 29405 600 29405 600 29405 600 29405 1200 28805 600 29405 600 27605 2400 28805 1200 29405 600 28805 1800 28805 1800 28205 1200 28805 1200 28805 600 29405 1200 28205 1200 137 │ │ │ │ │ │ │ │ <--- 6 ------- 59 ------- 106 ------- 147 ------- 189 ------- 219 ------- 272 ------- 335 ------- 387 ------- 433 ------- 485 ------- 539 ------- 600 ------- 653 ------- 698 ------- 749 ------- 806 ------- 855 ------- 904 ------- 961 ------- 1008 ------- 1065 ------- 1115 ------- 1163 ------- 1212 ------- 1270 ------- 1329 ------- 1373 ------- 1417 ------- 1470 ------- 1514 ------- 1566 ------- 1616 ------- 1668 ------- 1719 ------- 1765 ------- 1819 ------- 1871 ------- 1926 ------- 1978 ------- 2030 ------- 2080 ------- 2128 ------- 2173 ------- 2223 ------- 2270 ------- 2318 ------- 2382 ------- 2444 ------- 2491 ------- 2534 ------- 2584 ------- 2632 ------- 2675 ------- 2736 ------- 2781 ------- 2841 ------- 2905 ------- 2940 ------- 2996 ------- 3045 ------- 3084 ------- 3124 ------- 3181 ------- 3224 ------- 3268 ------- 3318 ------- 3362 ------- 3419 ------- 3466 ------- 3515 ------- 3560 ------- 3615 ------- 3669 ------- 3725 ------- 3777 ------- 3825 ------- 3871 ------- 3923 ------- 3980 ------- 4035 ------- 4078 ------- 4135 ------- 4184 ------- 4244 ------- 4296 ------- 4346 ------- 4396 ------- 4444 ------- 4489 ------- 4540 ------- 4575 ------- 4627 ------- 4683 ------- 4731 ------- 4777 ------- 4831 ------- 4900 ------- 4953 ------- 5006 ------- 5061 ------- 5119 ------- 5161 ------- 5208 ------- 5260 ------- 5315 ------- 5361 ------- 5415 ------- 5474 ------- 5529 ------- 5572 ------- 5635 ------- 5689 ------- 5738 ------- 5792 ------- 5835 ------- 5890 ------- 5935 ------- 5997 ------- 6039 ------- 6094 ------- 6151 ------- 6201 ------- 6245 ------- 6291 ------- 6343 ------- 6387 ------- 6437 ------- 6480 ------- 6540 ------- 6580 ------- 6629 ------- 6673 ------- 6718 ------- 6771 ------- 6823 ------- 6878 ------- 6935 ------- 6974 ------- 7017 ------- 7060 ------- 7112 ------- 7170 ------- 7231 ------- 7279 ------- 7329 ------- 7373 ------- 7427 ------- 7477 ------- 7520 ------- 7564 ------- 7616 ------- 7671 ------- 7716 ------- 7760 ------- 7815 ------- 7861 ------- 7917 ------- 7969 ------- 8018 ------- 8063 ------- 8112 ------- 8180 ------- 8229 ------- 8268 ------- 8320 ------- 8376 ------- 8432 ------- 8474 ------- 8522 ------- 8569 ------- 8616 ------- 8664 ------- 8705 ------- 8765 ------- 8814 ------- 8868 ------- 8906 ------- 8948 ------- 8990 ------- 9035 ------- 9090 ------- 9137 ------- 9188 ------- 9241 ------- 9292 ------- 9354 ------- 9411 ------- 9472 ------- 9526 ------- 9569 ------- 9613 ------- 9658 ------- 9708 ------- 9737 ------- 9792 ------- 9838 ------- 9903 ------- 9952 ------- 10000 138 │ │ │ │ │ │ │ │ histogram(64)= 0 600 28805 1200 29405 3600 29405 1200 29405 1800 28205 1800 28805 4200 28205 3600 27005 4800 29405 3600 29405 1800 26405 3600 29405 600 27005 3000 29405 2400 28805 3000 29405 600 25805 4800 28805 3000 27605 2400 27605 5401 28805 3600 28805 2400 27605 3600 28805 6001 28805 3600 27005 3000 25205 4800 28805 4200 28205 1200 28805 3600 28205 4200 27605 3000 28205 3600 28805 1200 27605 3000 28205 1200 27005 3000 28805 1200 28205 1800 28205 1800 27605 1800 27605 3600 27605 3600 25805 5401 28805 4200 28205 1200 28805 3000 28805 4800 28805 1200 28805 4200 28205 2400 26405 3000 28205 3000 28805 2400 28805 2400 27605 5401 28805 1800 28805 2400 28805 1200 28805 3600 27605 5401 25805 5401 28205 3600 27005 3600 28205 3000 28805 1200 28805 4800 28205 2400 24604 5401 28805 3000 27605 2400 28205 4200 27005 3000 28805 3000 28805 600 26405 5401 27605 4800 27005 2400 26405 4200 28805 2400 27605 3000 28205 3000 27005 2400 26405 3600 28205 1200 27605 4200 27605 3000 28205 1800 25805 3000 28205 2400 28205 1200 27005 2400 27605 1800 25805 3600 27005 6601 27005 1800 24004 6001 27605 1800 28205 3000 27605 2400 27605 2400 27605 3000 27605 2400 28205 3000 26405 2400 26405 2400 26405 2400 26405 3600 28205 1800 28205 2400 27605 1200 27605 3000 27605 4800 24604 4200 28205 3000 24604 6001 25805 4200 25205 4200 26405 3000 28205 3000 27605 3000 28205 600 27605 3600 25805 4200 27005 3600 28205 600 28205 3000 28205 1200 25805 3000 28205 1200 27005 3000 28205 1200 24604 4200 27605 1800 28205 4200 27605 2400 26405 4200 27005 2400 27005 1800 27605 3600 25205 4800 27605 2400 28205 1800 27005 3000 27605 3000 25205 4200 25805 3000 27605 3600 25805 3600 27605 1800 24604 4200 25805 3600 26405 1800 27005 3000 27005 1200 27005 3000 24004 5401 26405 1800 25805 2400 27605 1200 27605 600 27005 2400 27605 1200 23404 7201 25205 3600 26405 3000 27605 3600 27605 2400 24604 3600 27605 4200 27605 3600 27005 1200 26405 1200 25805 1800 25205 3600 22804 4800 24604 3000 24004 3600 26405 2400 24604 4800 26405 3000 22204 5401 25805 2400 25205 2400 27005 2400 24604 4200 25205 3000 24004 4800 25205 3000 26405 1200 27005 2400 26405 2400 26405 4800 25205 3000 25805 1800 24004 4800 24604 3000 23404 600 24004 600 139 │ │ │ │ │ │ │ │ <--- '1992-02-06' ------- '1992-03-13' ------- '1992-03-29' ------- '1992-04-12' ------- '1992-04-24' ------- '1992-05-07' ------- '1992-05-18' ------- '1992-05-30' ------- '1992-06-15' ------- '1992-06-28' ------- '1992-07-10' ------- '1992-07-20' ------- '1992-08-04' ------- '1992-08-17' ------- '1992-08-30' ------- '1992-09-11' ------- '1992-09-25' ------- '1992-10-05' ------- '1992-10-16' ------- '1992-10-29' ------- '1992-11-10' ------- '1992-11-24' ------- '1992-12-05' ------- '1992-12-16' ------- '1992-12-31' ------- '1993-01-15' ------- '1993-01-28' ------- '1993-02-09' ------- '1993-02-21' ------- '1993-03-07' ------- '1993-03-17' ------- '1993-04-03' ------- '1993-04-17' ------- '1993-04-30' ------- '1993-05-12' ------- '1993-05-25' ------- '1993-06-08' ------- '1993-06-23' ------- '1993-07-04' ------- '1993-07-18' ------- '1993-08-02' ------- '1993-08-13' ------- '1993-08-24' ------- '1993-09-08' ------- '1993-09-20' ------- '1993-10-06' ------- '1993-10-22' ------- '1993-11-01' ------- '1993-11-14' ------- '1993-11-24' ------- '1993-12-07' ------- '1993-12-20' ------- '1994-01-01' ------- '1994-01-14' ------- '1994-01-31' ------- '1994-02-14' ------- '1994-02-26' ------- '1994-03-09' ------- '1994-03-22' ------- '1994-04-03' ------- '1994-04-14' ------- '1994-04-23' ------- '1994-05-07' ------- '1994-05-19' ------- '1994-05-31' ------- '1994-06-12' ------- '1994-06-22' ------- '1994-07-03' ------- '1994-07-14' ------- '1994-07-24' ------- '1994-08-04' ------- '1994-08-16' ------- '1994-08-29' ------- '1994-09-08' ------- '1994-09-23' ------- '1994-10-05' ------- '1994-10-16' ------- '1994-10-28' ------- '1994-11-08' ------- '1994-11-19' ------- '1994-12-05' ------- '1994-12-18' ------- '1994-12-29' ------- '1995-01-11' ------- '1995-01-23' ------- '1995-02-05' ------- '1995-02-15' ------- '1995-03-02' ------- '1995-03-14' ------- '1995-03-25' ------- '1995-04-05' ------- '1995-04-17' ------- '1995-04-30' ------- '1995-05-11' ------- '1995-05-23' ------- '1995-06-06' ------- '1995-06-20' ------- '1995-06-30' ------- '1995-07-12' ------- '1995-07-26' ------- '1995-08-07' ------- '1995-08-17' ------- '1995-08-28' ------- '1995-09-09' ------- '1995-09-21' ------- '1995-10-04' ------- '1995-10-14' ------- '1995-10-28' ------- '1995-11-07' ------- '1995-11-18' ------- '1995-11-29' ------- '1995-12-11' ------- '1995-12-21' ------- '1995-12-31' ------- '1996-01-11' ------- '1996-01-21' ------- '1996-01-31' ------- '1996-02-10' ------- '1996-02-24' ------- '1996-03-04' ------- '1996-03-13' ------- '1996-03-25' ------- '1996-04-07' ------- '1996-04-17' ------- '1996-04-28' ------- '1996-05-10' ------- '1996-05-22' ------- '1996-06-02' ------- '1996-06-15' ------- '1996-06-26' ------- '1996-07-09' ------- '1996-07-20' ------- '1996-07-31' ------- '1996-08-11' ------- '1996-08-25' ------- '1996-09-07' ------- '1996-09-21' ------- '1996-10-04' ------- '1996-10-15' ------- '1996-10-27' ------- '1996-11-07' ------- '1996-11-19' ------- '1996-11-30' ------- '1996-12-13' ------- '1996-12-27' ------- '1997-01-06' ------- '1997-01-18' ------- '1997-01-30' ------- '1997-02-12' ------- '1997-02-23' ------- '1997-03-07' ------- '1997-03-19' ------- '1997-03-31' ------- '1997-04-10' ------- '1997-04-23' ------- '1997-05-04' ------- '1997-05-17' ------- '1997-05-29' ------- '1997-06-12' ------- '1997-06-23' ------- '1997-07-04' ------- '1997-07-16' ------- '1997-07-28' ------- '1997-08-07' ------- '1997-08-19' ------- '1997-08-29' ------- '1997-09-10' ------- '1997-09-20' ------- '1997-10-03' ------- '1997-10-13' ------- '1997-10-25' ------- '1997-11-05' ------- '1997-11-17' ------- '1997-12-02' ------- '1997-12-15' ------- '1997-12-26' ------- '1998-01-07' ------- '1998-01-16' ------- '1998-01-25' ------- '1998-02-07' ------- '1998-02-20' ------- '1998-03-06' ------- '1998-03-14' ------- '1998-03-30' ------- '1998-04-08' ------- '1998-04-21' ------- '1998-05-03' ------- '1998-05-15' ------- '1998-05-27' ------- '1998-06-07' ------- '1998-06-19' ------- '1998-07-03' ------- '1998-07-15' ------- '1998-07-26' ------- '1998-08-07' ------- '1998-08-18' ------- '1998-08-30' ------- '1998-09-12' ------- '1998-10-01' ------- '1998-10-30' 140 │ │ │ │ │ │ │ │ histogram(65)= 0 1200 29405 1200 29405 1200 29405 1200 27605 2400 24004 6001 27605 5401 28205 4200 29405 2400 29405 1200 28205 4200 27005 3000 27005 3000 29405 4800 27605 3000 28205 1800 27605 2400 26405 3600 27605 4800 27605 3600 28805 3000 28205 6001 28205 1800 26405 3600 27005 4200 29405 4200 27605 2400 27605 1800 27005 3600 24604 4800 27605 3000 27605 1800 28205 2400 28205 3000 28805 1800 28805 600 28205 1200 27005 2400 27605 1800 26405 3000 26405 4800 28205 2400 28805 1200 28805 3600 28205 3000 28205 1200 28205 1200 25805 4200 28205 4800 26405 6001 28205 1800 27005 3000 28205 1800 27605 3000 28205 1200 28205 2400 27605 3000 28805 1800 26405 4200 28805 1800 24604 4800 28805 1200 27005 3000 26405 7201 25805 4800 28805 4200 28805 3600 25205 4200 27005 4800 27605 3600 28205 4200 28805 1800 27005 2400 28805 1800 27005 3000 28205 2400 28205 2400 27005 2400 25805 3600 26405 3600 28805 3600 25805 4200 28805 4200 28205 2400 26405 3600 27005 2400 27605 3600 28805 600 27005 4800 28205 1800 26405 4800 26405 3600 26405 3000 27005 3000 27605 2400 28205 4200 28805 1800 28205 2400 26405 4200 28805 4200 28205 1800 25205 4200 28805 4800 27605 4200 27605 3000 28805 1200 28805 3000 28205 2400 26405 4200 28805 4200 27605 1200 27605 2400 24604 4800 27605 3000 28205 3000 24604 5401 27605 4200 26405 3600 25805 4200 25805 4200 22804 6001 27605 3000 28205 2400 27005 4800 27605 1200 25205 4200 27605 2400 28205 3600 26405 2400 27005 3600 27005 1800 27605 1800 27005 2400 23404 5401 27605 3600 27605 3600 27605 4200 26405 3000 27605 1200 28205 3000 25205 4800 27605 3600 28205 3600 26405 2400 22204 6601 27005 2400 28205 4800 25805 3000 25805 3600 28205 4200 27605 3000 25205 4800 26405 2400 27005 1200 27605 2400 26405 2400 27605 3000 25205 3000 27005 1200 26405 3000 25805 4800 27605 1800 26405 4200 26405 1800 27005 2400 24604 4200 25205 3600 25205 4200 25805 4200 25805 3600 25805 4200 27005 3000 22204 6001 27605 3000 25805 1800 27005 1200 25205 4200 27005 4200 27005 3000 27005 1800 25805 3000 25805 2400 25805 1800 25805 3600 25805 1800 25205 4200 24004 3600 23404 6601 26405 1800 25205 3600 26405 3600 22804 4200 24604 2400 22204 4200 24604 1800 24004 2400 26405 600 26405 600 25805 1200 26405 600 141 │ │ │ │ │ │ │ │ <--- '1992-01-19' ------- '1992-03-11' ------- '1992-04-04' ------- '1992-04-23' ------- '1992-05-09' ------- '1992-05-21' ------- '1992-06-06' ------- '1992-06-17' ------- '1992-07-02' ------- '1992-07-17' ------- '1992-07-28' ------- '1992-08-09' ------- '1992-08-21' ------- '1992-09-01' ------- '1992-09-13' ------- '1992-09-23' ------- '1992-10-08' ------- '1992-10-25' ------- '1992-11-06' ------- '1992-11-18' ------- '1992-12-01' ------- '1992-12-12' ------- '1992-12-24' ------- '1993-01-04' ------- '1993-01-15' ------- '1993-01-27' ------- '1993-02-09' ------- '1993-02-20' ------- '1993-03-05' ------- '1993-03-18' ------- '1993-04-01' ------- '1993-04-13' ------- '1993-04-29' ------- '1993-05-13' ------- '1993-05-27' ------- '1993-06-08' ------- '1993-06-20' ------- '1993-07-03' ------- '1993-07-15' ------- '1993-07-29' ------- '1993-08-11' ------- '1993-08-25' ------- '1993-09-08' ------- '1993-09-21' ------- '1993-10-02' ------- '1993-10-15' ------- '1993-10-29' ------- '1993-11-08' ------- '1993-11-20' ------- '1993-12-05' ------- '1993-12-17' ------- '1993-12-30' ------- '1994-01-13' ------- '1994-01-26' ------- '1994-02-08' ------- '1994-02-19' ------- '1994-03-04' ------- '1994-03-14' ------- '1994-03-26' ------- '1994-04-08' ------- '1994-04-21' ------- '1994-05-03' ------- '1994-05-14' ------- '1994-05-24' ------- '1994-06-03' ------- '1994-06-15' ------- '1994-06-27' ------- '1994-07-07' ------- '1994-07-16' ------- '1994-07-26' ------- '1994-08-10' ------- '1994-08-22' ------- '1994-09-03' ------- '1994-09-15' ------- '1994-09-27' ------- '1994-10-11' ------- '1994-10-22' ------- '1994-11-02' ------- '1994-11-14' ------- '1994-11-26' ------- '1994-12-10' ------- '1994-12-22' ------- '1995-01-04' ------- '1995-01-19' ------- '1995-01-30' ------- '1995-02-13' ------- '1995-02-23' ------- '1995-03-07' ------- '1995-03-17' ------- '1995-03-28' ------- '1995-04-11' ------- '1995-04-22' ------- '1995-05-03' ------- '1995-05-17' ------- '1995-05-29' ------- '1995-06-11' ------- '1995-06-26' ------- '1995-07-06' ------- '1995-07-18' ------- '1995-08-01' ------- '1995-08-14' ------- '1995-08-27' ------- '1995-09-09' ------- '1995-09-22' ------- '1995-10-03' ------- '1995-10-14' ------- '1995-10-26' ------- '1995-11-07' ------- '1995-11-19' ------- '1995-11-30' ------- '1995-12-12' ------- '1995-12-25' ------- '1996-01-03' ------- '1996-01-12' ------- '1996-01-24' ------- '1996-02-03' ------- '1996-02-13' ------- '1996-02-25' ------- '1996-03-06' ------- '1996-03-15' ------- '1996-03-25' ------- '1996-04-08' ------- '1996-04-21' ------- '1996-05-01' ------- '1996-05-13' ------- '1996-05-24' ------- '1996-06-03' ------- '1996-06-17' ------- '1996-06-29' ------- '1996-07-09' ------- '1996-07-22' ------- '1996-08-04' ------- '1996-08-17' ------- '1996-08-29' ------- '1996-09-09' ------- '1996-09-21' ------- '1996-10-02' ------- '1996-10-13' ------- '1996-10-27' ------- '1996-11-10' ------- '1996-11-23' ------- '1996-12-03' ------- '1996-12-17' ------- '1996-12-28' ------- '1997-01-08' ------- '1997-01-18' ------- '1997-01-30' ------- '1997-02-11' ------- '1997-02-23' ------- '1997-03-10' ------- '1997-03-20' ------- '1997-03-31' ------- '1997-04-10' ------- '1997-04-23' ------- '1997-05-06' ------- '1997-05-18' ------- '1997-05-30' ------- '1997-06-12' ------- '1997-06-24' ------- '1997-07-07' ------- '1997-07-20' ------- '1997-08-03' ------- '1997-08-16' ------- '1997-08-27' ------- '1997-09-08' ------- '1997-09-18' ------- '1997-10-01' ------- '1997-10-10' ------- '1997-10-20' ------- '1997-11-01' ------- '1997-11-13' ------- '1997-11-27' ------- '1997-12-06' ------- '1997-12-19' ------- '1997-12-29' ------- '1998-01-10' ------- '1998-01-20' ------- '1998-02-03' ------- '1998-02-17' ------- '1998-02-28' ------- '1998-03-11' ------- '1998-03-24' ------- '1998-04-05' ------- '1998-04-17' ------- '1998-05-01' ------- '1998-05-11' ------- '1998-05-22' ------- '1998-06-03' ------- '1998-06-13' ------- '1998-06-27' ------- '1998-07-12' ------- '1998-07-21' ------- '1998-07-31' ------- '1998-08-08' ------- '1998-08-22' ------- '1998-09-03' ------- '1998-09-16' ------- '1998-10-03' ------- '1998-10-26' ------- '1998-12-16' 142 │ │ │ │ │ │ │ └── ordering: +53 143 │ │ │ │ │ │ └── filters 144 │ │ │ │ │ │ └── l3.l_receiptdate:65 > l3.l_commitdate:64 [type=bool, outer=(64,65), constraints=(/64: (/NULL - ]; /65: (/NULL - ])] 145 │ │ │ │ │ └── filters 146 │ │ │ │ │ └── l3.l_suppkey:55 != l1.l_suppkey:10 [type=bool, outer=(10,55), constraints=(/10: (/NULL - ]; /55: (/NULL - ])] 147 │ │ │ │ ├── scan l2@l_sk 148 │ │ │ │ │ ├── save-table-name: q21_scan_12 149 │ │ │ │ │ ├── columns: l2.l_orderkey:37(int!null) l2.l_suppkey:39(int!null) 150 │ │ │ │ │ └── stats: [rows=6001215, distinct(37)=1527270, null(37)=0, distinct(39)=9920, null(39)=0] 151 │ │ │ │ │ histogram(37)= 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 152 │ │ │ │ │ <--- 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 153 │ │ │ │ │ histogram(39)= 0 600 28805 3000 29405 600 29405 600 29405 600 29405 600 29405 1200 29405 1200 29405 1200 28805 1200 28805 1800 29405 600 29405 1200 29405 600 29405 600 28805 1200 29405 1200 28805 1200 28205 1800 29405 1200 29405 600 29405 1200 29405 1200 29405 600 29405 1200 29405 1200 28805 1800 29405 600 28805 1800 28805 1200 28805 1200 29405 1200 28805 1800 29405 600 28205 1800 29405 600 29405 600 28805 1200 29405 600 28805 1200 29405 600 29405 600 28805 1200 28805 1800 27605 2400 29405 600 28205 1800 29405 2400 29405 600 28805 1800 28205 1800 28805 1200 29405 3000 29405 1200 29405 1800 29405 600 29405 600 28205 1800 29405 600 29405 1800 29405 1800 29405 600 29405 600 28805 1200 28805 1200 29405 1200 28205 1800 29405 600 28805 1200 27605 2400 29405 600 29405 1200 29405 1200 29405 600 29405 1800 29405 1200 28205 1800 29405 600 29405 1200 29405 1200 28805 1200 28205 1800 29405 1800 28805 1200 29405 600 29405 1800 28205 2400 29405 600 28805 1200 28205 2400 28805 1200 27605 2400 28805 1200 29405 600 28805 1800 29405 1800 28805 600 28205 1800 28805 600 29405 600 29405 1200 28805 600 28805 1200 29405 1800 27605 1800 27605 2400 27605 1800 29405 1200 28805 600 28805 1200 29405 1200 28805 2400 28805 1200 28805 600 28205 1200 28205 1200 29405 600 28805 1200 29405 600 28205 2400 28205 1200 29405 600 29405 1800 28805 1200 28205 1200 27605 2400 27605 1800 28805 1200 29405 600 28805 1200 29405 600 29405 600 28805 1200 29405 600 29405 600 29405 600 28805 1200 29405 1200 28805 600 29405 1800 28205 1200 27605 1800 29405 600 29405 600 29405 1200 28805 1200 28805 1200 28205 1200 29405 1800 28205 1800 28805 600 28805 1200 28205 1200 29405 600 28805 1800 28205 1800 27605 2400 28805 600 29405 600 28805 1200 29405 600 28805 2400 28805 1200 28805 1200 28805 600 28205 1200 28805 1200 29405 600 29405 600 29405 1800 28805 600 28805 600 28805 2400 28805 600 28805 1800 28805 1200 28805 600 27005 2400 29405 600 28205 1800 29405 1200 27605 1800 28805 1200 28805 1200 29405 600 29405 600 29405 600 29405 1200 28805 600 29405 600 27605 2400 28805 1200 29405 600 28805 1800 28805 1800 28205 1200 28805 1200 28805 600 29405 1200 28205 1200 154 │ │ │ │ │ <--- 6 ------- 59 ------- 106 ------- 147 ------- 189 ------- 219 ------- 272 ------- 335 ------- 387 ------- 433 ------- 485 ------- 539 ------- 600 ------- 653 ------- 698 ------- 749 ------- 806 ------- 855 ------- 904 ------- 961 ------- 1008 ------- 1065 ------- 1115 ------- 1163 ------- 1212 ------- 1270 ------- 1329 ------- 1373 ------- 1417 ------- 1470 ------- 1514 ------- 1566 ------- 1616 ------- 1668 ------- 1719 ------- 1765 ------- 1819 ------- 1871 ------- 1926 ------- 1978 ------- 2030 ------- 2080 ------- 2128 ------- 2173 ------- 2223 ------- 2270 ------- 2318 ------- 2382 ------- 2444 ------- 2491 ------- 2534 ------- 2584 ------- 2632 ------- 2675 ------- 2736 ------- 2781 ------- 2841 ------- 2905 ------- 2940 ------- 2996 ------- 3045 ------- 3084 ------- 3124 ------- 3181 ------- 3224 ------- 3268 ------- 3318 ------- 3362 ------- 3419 ------- 3466 ------- 3515 ------- 3560 ------- 3615 ------- 3669 ------- 3725 ------- 3777 ------- 3825 ------- 3871 ------- 3923 ------- 3980 ------- 4035 ------- 4078 ------- 4135 ------- 4184 ------- 4244 ------- 4296 ------- 4346 ------- 4396 ------- 4444 ------- 4489 ------- 4540 ------- 4575 ------- 4627 ------- 4683 ------- 4731 ------- 4777 ------- 4831 ------- 4900 ------- 4953 ------- 5006 ------- 5061 ------- 5119 ------- 5161 ------- 5208 ------- 5260 ------- 5315 ------- 5361 ------- 5415 ------- 5474 ------- 5529 ------- 5572 ------- 5635 ------- 5689 ------- 5738 ------- 5792 ------- 5835 ------- 5890 ------- 5935 ------- 5997 ------- 6039 ------- 6094 ------- 6151 ------- 6201 ------- 6245 ------- 6291 ------- 6343 ------- 6387 ------- 6437 ------- 6480 ------- 6540 ------- 6580 ------- 6629 ------- 6673 ------- 6718 ------- 6771 ------- 6823 ------- 6878 ------- 6935 ------- 6974 ------- 7017 ------- 7060 ------- 7112 ------- 7170 ------- 7231 ------- 7279 ------- 7329 ------- 7373 ------- 7427 ------- 7477 ------- 7520 ------- 7564 ------- 7616 ------- 7671 ------- 7716 ------- 7760 ------- 7815 ------- 7861 ------- 7917 ------- 7969 ------- 8018 ------- 8063 ------- 8112 ------- 8180 ------- 8229 ------- 8268 ------- 8320 ------- 8376 ------- 8432 ------- 8474 ------- 8522 ------- 8569 ------- 8616 ------- 8664 ------- 8705 ------- 8765 ------- 8814 ------- 8868 ------- 8906 ------- 8948 ------- 8990 ------- 9035 ------- 9090 ------- 9137 ------- 9188 ------- 9241 ------- 9292 ------- 9354 ------- 9411 ------- 9472 ------- 9526 ------- 9569 ------- 9613 ------- 9658 ------- 9708 ------- 9737 ------- 9792 ------- 9838 ------- 9903 ------- 9952 ------- 10000 155 │ │ │ │ └── filters 156 │ │ │ │ ├── l2.l_orderkey:37 = l1.l_orderkey:8 [type=bool, outer=(8,37), constraints=(/8: (/NULL - ]; /37: (/NULL - ]), fd=(8)==(37), (37)==(8)] 157 │ │ │ │ └── l2.l_suppkey:39 != l1.l_suppkey:10 [type=bool, outer=(10,39), constraints=(/10: (/NULL - ]; /39: (/NULL - ])] 158 │ │ │ ├── inner-join (lookup supplier) 159 │ │ │ │ ├── save-table-name: q21_lookup_join_13 160 │ │ │ │ ├── columns: s_suppkey:1(int!null) s_name:2(char!null) s_nationkey:4(int!null) n_nationkey:33(int!null) n_name:34(char!null) 161 │ │ │ │ ├── key columns: [1] = [1] 162 │ │ │ │ ├── lookup columns are key 163 │ │ │ │ ├── stats: [rows=400, distinct(1)=399.934613, null(1)=0, distinct(2)=399.991883, null(2)=0, distinct(4)=1, null(4)=0, distinct(33)=1, null(33)=0, distinct(34)=1, null(34)=0] 164 │ │ │ │ ├── key: (1) 165 │ │ │ │ ├── fd: ()-->(34), (1)-->(2,4), (4)==(33), (33)==(4) 166 │ │ │ │ ├── inner-join (lookup supplier@s_nk) 167 │ │ │ │ │ ├── save-table-name: q21_lookup_join_14 168 │ │ │ │ │ ├── columns: s_suppkey:1(int!null) s_nationkey:4(int!null) n_nationkey:33(int!null) n_name:34(char!null) 169 │ │ │ │ │ ├── key columns: [33] = [4] 170 │ │ │ │ │ ├── stats: [rows=400, distinct(1)=399.934613, null(1)=0, distinct(4)=1, null(4)=0, distinct(33)=1, null(33)=0, distinct(34)=1, null(34)=0] 171 │ │ │ │ │ ├── key: (1) 172 │ │ │ │ │ ├── fd: ()-->(34), (1)-->(4), (4)==(33), (33)==(4) 173 │ │ │ │ │ ├── select 174 │ │ │ │ │ │ ├── save-table-name: q21_select_15 175 │ │ │ │ │ │ ├── columns: n_nationkey:33(int!null) n_name:34(char!null) 176 │ │ │ │ │ │ ├── stats: [rows=1, distinct(33)=1, null(33)=0, distinct(34)=1, null(34)=0] 177 │ │ │ │ │ │ ├── key: (33) 178 │ │ │ │ │ │ ├── fd: ()-->(34) 179 │ │ │ │ │ │ ├── scan nation 180 │ │ │ │ │ │ │ ├── save-table-name: q21_scan_16 181 │ │ │ │ │ │ │ ├── columns: n_nationkey:33(int!null) n_name:34(char!null) 182 │ │ │ │ │ │ │ ├── stats: [rows=25, distinct(33)=25, null(33)=0, distinct(34)=25, null(34)=0] 183 │ │ │ │ │ │ │ │ histogram(33)= 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 184 │ │ │ │ │ │ │ │ <--- 0 --- 1 --- 2 --- 3 --- 4 --- 5 --- 6 --- 7 --- 8 --- 9 --- 10 --- 11 --- 12 --- 13 --- 14 --- 15 --- 16 --- 17 --- 18 --- 19 --- 20 --- 21 --- 22 --- 23 --- 24 185 │ │ │ │ │ │ │ ├── key: (33) 186 │ │ │ │ │ │ │ └── fd: (33)-->(34) 187 │ │ │ │ │ │ └── filters 188 │ │ │ │ │ │ └── n_name:34 = 'SAUDI ARABIA' [type=bool, outer=(34), constraints=(/34: [/'SAUDI ARABIA' - /'SAUDI ARABIA']; tight), fd=()-->(34)] 189 │ │ │ │ │ └── filters (true) 190 │ │ │ │ └── filters (true) 191 │ │ │ └── filters 192 │ │ │ └── s_suppkey:1 = l1.l_suppkey:10 [type=bool, outer=(1,10), constraints=(/1: (/NULL - ]; /10: (/NULL - ]), fd=(1)==(10), (10)==(1)] 193 │ │ └── filters 194 │ │ └── o_orderstatus:26 = 'F' [type=bool, outer=(26), constraints=(/26: [/'F' - /'F']; tight), fd=()-->(26)] 195 │ └── aggregations 196 │ └── count-rows [as=count_rows:69, type=int] 197 └── 100 [type=int] 198 199 stats table=q21_limit_1 200 ---- 201 column_names row_count distinct_count null_count 202 {numwait} 100 8 0 203 {s_name} 100 100 0 204 ~~~~ 205 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 206 {numwait} 100.00 1.00 100.00 12.50 <== 0.00 1.00 207 {s_name} 100.00 1.00 100.00 1.00 0.00 1.00 208 209 stats table=q21_sort_2 210 ---- 211 column_names row_count distinct_count null_count 212 {count_rows} 100 8 0 213 {s_name} 100 100 0 214 ~~~~ 215 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 216 {count_rows} 8329.00 83.29 <== 8329.00 1041.12 <== 0.00 1.00 217 {s_name} 8329.00 83.29 <== 8329.00 83.29 <== 0.00 1.00 218 219 stats table=q21_group_by_3 220 ---- 221 column_names row_count distinct_count null_count 222 {count_rows} 411 17 0 223 {s_name} 411 411 0 224 ~~~~ 225 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 226 {count_rows} 8329.00 20.27 <== 8329.00 489.94 <== 0.00 1.00 227 {s_name} 8329.00 20.27 <== 8329.00 20.27 <== 0.00 1.00 228 229 stats table=q21_lookup_join_4 230 ---- 231 column_names row_count distinct_count null_count 232 {l_commitdate} 4141 1188 0 233 {l_orderkey} 4141 4127 0 234 {l_receiptdate} 4141 1174 0 235 {l_suppkey} 4141 411 0 236 {n_name} 4141 1 0 237 {n_nationkey} 4141 1 0 238 {o_orderkey} 4141 4127 0 239 {o_orderstatus} 4141 1 0 240 {s_name} 4141 411 0 241 {s_nationkey} 4141 1 0 242 {s_suppkey} 4141 411 0 243 ~~~~ 244 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 245 {l_commitdate} 17925.00 4.33 <== 2464.00 2.07 <== 0.00 1.00 246 {l_orderkey} 17925.00 4.33 <== 17568.00 4.26 <== 0.00 1.00 247 {l_receiptdate} 17925.00 4.33 <== 2552.00 2.17 <== 0.00 1.00 248 {l_suppkey} 17925.00 4.33 <== 9920.00 24.14 <== 0.00 1.00 249 {n_name} 17925.00 4.33 <== 1.00 1.00 0.00 1.00 250 {n_nationkey} 17925.00 4.33 <== 1.00 1.00 0.00 1.00 251 {o_orderkey} 17925.00 4.33 <== 17568.00 4.26 <== 0.00 1.00 252 {o_orderstatus} 17925.00 4.33 <== 1.00 1.00 0.00 1.00 253 {s_name} 17925.00 4.33 <== 8329.00 20.27 <== 0.00 1.00 254 {s_nationkey} 17925.00 4.33 <== 1.00 1.00 0.00 1.00 255 {s_suppkey} 17925.00 4.33 <== 9920.00 24.14 <== 0.00 1.00 256 257 stats table=q21_inner_join_5 258 ---- 259 column_names row_count distinct_count null_count 260 {l_commitdate} 8357 2357 0 261 {l_orderkey} 8357 8343 0 262 {l_receiptdate} 8357 2379 0 263 {l_suppkey} 8357 411 0 264 {n_name} 8357 1 0 265 {n_nationkey} 8357 1 0 266 {s_name} 8357 411 0 267 {s_nationkey} 8357 1 0 268 {s_suppkey} 8357 411 0 269 ~~~~ 270 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 271 {l_commitdate} 17925.00 2.14 <== 2464.00 1.05 0.00 1.00 272 {l_orderkey} 17925.00 2.14 <== 17568.00 2.11 <== 0.00 1.00 273 {l_receiptdate} 17925.00 2.14 <== 2552.00 1.07 0.00 1.00 274 {l_suppkey} 17925.00 2.14 <== 9920.00 24.14 <== 0.00 1.00 275 {n_name} 17925.00 2.14 <== 1.00 1.00 0.00 1.00 276 {n_nationkey} 17925.00 2.14 <== 1.00 1.00 0.00 1.00 277 {s_name} 17925.00 2.14 <== 8329.00 20.27 <== 0.00 1.00 278 {s_nationkey} 17925.00 2.14 <== 1.00 1.00 0.00 1.00 279 {s_suppkey} 17925.00 2.14 <== 9920.00 24.14 <== 0.00 1.00 280 281 stats table=q21_semi_join_6 282 ---- 283 column_names row_count distinct_count null_count 284 {l_commitdate} 202092 2465 0 285 {l_orderkey} 202092 202357 0 286 {l_receiptdate} 202092 2509 0 287 {l_suppkey} 202092 9920 0 288 ~~~~ 289 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 290 {l_commitdate} 444534.00 2.20 <== 2466.00 1.00 0.00 1.00 291 {l_orderkey} 444534.00 2.20 <== 444534.00 2.20 <== 0.00 1.00 292 {l_receiptdate} 444534.00 2.20 <== 2554.00 1.02 0.00 1.00 293 {l_suppkey} 444534.00 2.20 <== 9920.00 1.00 0.00 1.00 294 295 stats table=q21_merge_join_7 296 ---- 297 column_names row_count distinct_count null_count 298 {l_commitdate} 337680 2465 0 299 {l_orderkey} 337680 338428 0 300 {l_receiptdate} 337680 2513 0 301 {l_suppkey} 337680 9920 0 302 ~~~~ 303 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 304 {l_commitdate} 1333603.00 3.95 <== 2466.00 1.00 0.00 1.00 305 {l_orderkey} 1333603.00 3.95 <== 1016901.00 3.00 <== 0.00 1.00 306 {l_receiptdate} 1333603.00 3.95 <== 2554.00 1.02 0.00 1.00 307 {l_suppkey} 1333603.00 3.95 <== 9920.00 1.00 0.00 1.00 308 309 stats table=q21_select_8 310 ---- 311 column_names row_count distinct_count null_count 312 {l_commitdate} 3793296 2466 0 313 {l_orderkey} 3793296 1405723 0 314 {l_receiptdate} 3793296 2525 0 315 {l_suppkey} 3793296 9920 0 316 ~~~~ 317 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 318 {l_commitdate} 2000405.00 1.90 2466.00 1.00 0.00 1.00 319 {l_orderkey} 2000405.00 1.90 1216823.00 1.16 0.00 1.00 320 {l_receiptdate} 2000405.00 1.90 2554.00 1.01 0.00 1.00 321 {l_suppkey} 2000405.00 1.90 9920.00 1.00 0.00 1.00 322 323 stats table=q21_scan_9 324 ---- 325 column_names row_count distinct_count null_count 326 {l_commitdate} 6001215 2466 0 327 {l_orderkey} 6001215 1527270 0 328 {l_receiptdate} 6001215 2554 0 329 {l_suppkey} 6001215 9920 0 330 ~~~~ 331 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 332 {l_commitdate} 6001215.00 1.00 2466.00 1.00 0.00 1.00 333 {l_orderkey} 6001215.00 1.00 1527270.00 1.00 0.00 1.00 334 {l_receiptdate} 6001215.00 1.00 2554.00 1.00 0.00 1.00 335 {l_suppkey} 6001215.00 1.00 9920.00 1.00 0.00 1.00 336 337 stats table=q21_select_10 338 ---- 339 column_names row_count distinct_count null_count 340 {l_commitdate} 3793296 2466 0 341 {l_orderkey} 3793296 1405723 0 342 {l_receiptdate} 3793296 2525 0 343 {l_suppkey} 3793296 9920 0 344 ~~~~ 345 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 346 {l_commitdate} 2000405.00 1.90 2466.00 1.00 0.00 1.00 347 {l_orderkey} 2000405.00 1.90 1216823.00 1.16 0.00 1.00 348 {l_receiptdate} 2000405.00 1.90 2554.00 1.01 0.00 1.00 349 {l_suppkey} 2000405.00 1.90 9920.00 1.00 0.00 1.00 350 351 stats table=q21_scan_11 352 ---- 353 column_names row_count distinct_count null_count 354 {l_commitdate} 6001215 2466 0 355 {l_orderkey} 6001215 1527270 0 356 {l_receiptdate} 6001215 2554 0 357 {l_suppkey} 6001215 9920 0 358 ~~~~ 359 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 360 {l_commitdate} 6001215.00 1.00 2466.00 1.00 0.00 1.00 361 {l_orderkey} 6001215.00 1.00 1527270.00 1.00 0.00 1.00 362 {l_receiptdate} 6001215.00 1.00 2554.00 1.00 0.00 1.00 363 {l_suppkey} 6001215.00 1.00 9920.00 1.00 0.00 1.00 364 365 stats table=q21_scan_12 366 ---- 367 column_names row_count distinct_count null_count 368 {l_orderkey} 6001215 1527272 0 369 {l_suppkey} 6001215 9920 0 370 ~~~~ 371 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 372 {l_orderkey} 6001215.00 1.00 1527270.00 1.00 0.00 1.00 373 {l_suppkey} 6001215.00 1.00 9920.00 1.00 0.00 1.00 374 375 stats table=q21_lookup_join_13 376 ---- 377 column_names row_count distinct_count null_count 378 {n_name} 411 1 0 379 {n_nationkey} 411 1 0 380 {s_name} 411 411 0 381 {s_nationkey} 411 1 0 382 {s_suppkey} 411 411 0 383 ~~~~ 384 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 385 {n_name} 400.00 1.03 1.00 1.00 0.00 1.00 386 {n_nationkey} 400.00 1.03 1.00 1.00 0.00 1.00 387 {s_name} 400.00 1.03 400.00 1.03 0.00 1.00 388 {s_nationkey} 400.00 1.03 1.00 1.00 0.00 1.00 389 {s_suppkey} 400.00 1.03 400.00 1.03 0.00 1.00 390 391 stats table=q21_lookup_join_14 392 ---- 393 column_names row_count distinct_count null_count 394 {n_name} 411 1 0 395 {n_nationkey} 411 1 0 396 {s_nationkey} 411 1 0 397 {s_suppkey} 411 411 0 398 ~~~~ 399 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 400 {n_name} 400.00 1.03 1.00 1.00 0.00 1.00 401 {n_nationkey} 400.00 1.03 1.00 1.00 0.00 1.00 402 {s_nationkey} 400.00 1.03 1.00 1.00 0.00 1.00 403 {s_suppkey} 400.00 1.03 400.00 1.03 0.00 1.00 404 405 stats table=q21_select_15 406 ---- 407 column_names row_count distinct_count null_count 408 {n_name} 1 1 0 409 {n_nationkey} 1 1 0 410 ~~~~ 411 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 412 {n_name} 1.00 1.00 1.00 1.00 0.00 1.00 413 {n_nationkey} 1.00 1.00 1.00 1.00 0.00 1.00 414 415 stats table=q21_scan_16 416 ---- 417 column_names row_count distinct_count null_count 418 {n_name} 25 25 0 419 {n_nationkey} 25 25 0 420 ~~~~ 421 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 422 {n_name} 25.00 1.00 25.00 1.00 0.00 1.00 423 {n_nationkey} 25.00 1.00 25.00 1.00 0.00 1.00