github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/stats_quality/tpch/q20 (about) 1 import file=tpch_schema 2 ---- 3 4 import file=tpch_stats 5 ---- 6 7 # -------------------------------------------------- 8 # Q20 9 # Potential Part Promotion 10 # Identifies suppliers in a particular nation having selected parts that may be 11 # candidates for a promotional offer. 12 # 13 # Identifies suppliers who have an excess of a given part available; an excess 14 # defined to be more than 50% of the parts like the given part that the supplier 15 # shipped in a given year for a given nation. Only parts whose names share a 16 # certain naming convention are considered. 17 # 18 # TODO: 19 # 1. Push 'forest%' prefix filter down into Scan 20 # -------------------------------------------------- 21 save-tables database=tpch save-tables-prefix=q20 22 SELECT 23 s_name, 24 s_address 25 FROM 26 supplier, 27 nation 28 WHERE 29 s_suppkey IN ( 30 SELECT 31 ps_suppkey 32 FROM 33 partsupp 34 WHERE 35 ps_partkey IN ( 36 SELECT 37 p_partkey 38 FROM 39 part 40 WHERE 41 p_name LIKE 'forest%' 42 ) 43 AND ps_availqty > ( 44 SELECT 45 0.5 * sum(l_quantity) 46 FROM 47 lineitem 48 WHERE 49 l_partkey = ps_partkey 50 AND l_suppkey = ps_suppkey 51 AND l_shipdate >= DATE '1994-01-01' 52 AND l_shipdate < DATE '1994-01-01' + INTERVAL '1' YEAR 53 ) 54 ) 55 AND s_nationkey = n_nationkey 56 AND n_name = 'CANADA' 57 ORDER BY 58 s_name; 59 ---- 60 sort 61 ├── save-table-name: q20_sort_1 62 ├── columns: s_name:2(char!null) s_address:3(varchar!null) 63 ├── stats: [rows=392.749612, distinct(2)=392.742232, null(2)=0, distinct(3)=392.749612, null(3)=0] 64 ├── ordering: +2 65 └── project 66 ├── save-table-name: q20_project_2 67 ├── columns: s_name:2(char!null) s_address:3(varchar!null) 68 ├── stats: [rows=392.749612, distinct(2)=392.742232, null(2)=0, distinct(3)=392.749612, null(3)=0] 69 └── inner-join (hash) 70 ├── save-table-name: q20_inner_join_3 71 ├── columns: s_suppkey:1(int!null) s_name:2(char!null) s_address:3(varchar!null) s_nationkey:4(int!null) n_nationkey:8(int!null) n_name:9(char!null) 72 ├── stats: [rows=392.749612, distinct(1)=392.685411, null(1)=0, distinct(2)=392.742232, null(2)=0, distinct(3)=392.749612, null(3)=0, distinct(4)=1, null(4)=0, distinct(8)=1, null(8)=0, distinct(9)=1, null(9)=0] 73 ├── key: (1) 74 ├── fd: ()-->(9), (1)-->(2-4), (4)==(8), (8)==(4) 75 ├── semi-join (hash) 76 │ ├── save-table-name: q20_semi_join_4 77 │ ├── columns: s_suppkey:1(int!null) s_name:2(char!null) s_address:3(varchar!null) s_nationkey:4(int!null) 78 │ ├── stats: [rows=9818.7403, distinct(1)=9740.19038, null(1)=0, distinct(2)=9809.64703, null(2)=0, distinct(3)=9818.7403, null(3)=0, distinct(4)=25, null(4)=0] 79 │ ├── key: (1) 80 │ ├── fd: (1)-->(2-4) 81 │ ├── scan supplier 82 │ │ ├── save-table-name: q20_scan_5 83 │ │ ├── columns: s_suppkey:1(int!null) s_name:2(char!null) s_address:3(varchar!null) s_nationkey:4(int!null) 84 │ │ ├── stats: [rows=10000, distinct(1)=9920, null(1)=0, distinct(2)=9990, null(2)=0, distinct(3)=10000, null(3)=0, distinct(4)=25, null(4)=0] 85 │ │ │ histogram(1)= 0 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 49 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 50 1 86 │ │ │ <--- 1 ---- 51 ---- 101 ---- 151 ---- 201 ---- 251 ---- 301 ---- 351 ---- 401 ---- 451 ---- 501 ---- 551 ---- 601 ---- 651 ---- 701 ---- 751 ---- 801 ---- 851 ---- 901 ---- 951 ---- 1001 ---- 1051 ---- 1101 ---- 1151 ---- 1201 ---- 1251 ---- 1301 ---- 1351 ---- 1401 ---- 1451 ---- 1501 ---- 1551 ---- 1601 ---- 1651 ---- 1701 ---- 1751 ---- 1801 ---- 1851 ---- 1901 ---- 1951 ---- 2001 ---- 2051 ---- 2101 ---- 2151 ---- 2201 ---- 2251 ---- 2301 ---- 2351 ---- 2401 ---- 2451 ---- 2501 ---- 2551 ---- 2601 ---- 2651 ---- 2701 ---- 2751 ---- 2801 ---- 2851 ---- 2901 ---- 2951 ---- 3001 ---- 3051 ---- 3101 ---- 3151 ---- 3201 ---- 3251 ---- 3301 ---- 3351 ---- 3401 ---- 3451 ---- 3501 ---- 3551 ---- 3601 ---- 3651 ---- 3701 ---- 3751 ---- 3801 ---- 3851 ---- 3901 ---- 3951 ---- 4001 ---- 4051 ---- 4101 ---- 4151 ---- 4201 ---- 4251 ---- 4301 ---- 4351 ---- 4401 ---- 4451 ---- 4501 ---- 4551 ---- 4601 ---- 4651 ---- 4701 ---- 4751 ---- 4801 ---- 4851 ---- 4901 ---- 4951 ---- 5001 ---- 5051 ---- 5101 ---- 5151 ---- 5201 ---- 5251 ---- 5301 ---- 5351 ---- 5401 ---- 5451 ---- 5501 ---- 5551 ---- 5601 ---- 5651 ---- 5701 ---- 5751 ---- 5801 ---- 5851 ---- 5901 ---- 5951 ---- 6001 ---- 6051 ---- 6101 ---- 6151 ---- 6201 ---- 6251 ---- 6301 ---- 6351 ---- 6401 ---- 6451 ---- 6501 ---- 6551 ---- 6601 ---- 6651 ---- 6701 ---- 6751 ---- 6801 ---- 6851 ---- 6901 ---- 6951 ---- 7001 ---- 7051 ---- 7101 ---- 7151 ---- 7201 ---- 7251 ---- 7301 ---- 7351 ---- 7401 ---- 7451 ---- 7501 ---- 7552 ---- 7603 ---- 7654 ---- 7705 ---- 7756 ---- 7807 ---- 7858 ---- 7909 ---- 7960 ---- 8011 ---- 8062 ---- 8113 ---- 8164 ---- 8215 ---- 8266 ---- 8317 ---- 8368 ---- 8419 ---- 8470 ---- 8521 ---- 8572 ---- 8623 ---- 8674 ---- 8725 ---- 8776 ---- 8827 ---- 8878 ---- 8929 ---- 8980 ---- 9031 ---- 9082 ---- 9133 ---- 9184 ---- 9235 ---- 9286 ---- 9337 ---- 9388 ---- 9439 ---- 9490 ---- 9541 ---- 9592 ---- 9643 ---- 9694 ---- 9745 ---- 9796 ---- 9847 ---- 9898 ---- 9949 ---- 10000 87 │ │ │ histogram(4)= 0 420 0 413 0 397 0 412 0 415 0 380 0 402 0 396 0 415 0 405 0 393 0 438 0 377 0 362 0 376 0 373 0 406 0 421 0 407 0 398 0 411 0 399 0 401 0 390 0 393 88 │ │ │ <--- 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 89 │ │ ├── key: (1) 90 │ │ └── fd: (1)-->(2-4) 91 │ ├── project 92 │ │ ├── save-table-name: q20_project_6 93 │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) 94 │ │ ├── stats: [rows=36952.1991, distinct(12)=22217.3354, null(12)=0, distinct(13)=9740.19038, null(13)=0] 95 │ │ ├── key: (12,13) 96 │ │ └── project 97 │ │ ├── save-table-name: q20_project_7 98 │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) p_partkey:17(int!null) 99 │ │ ├── stats: [rows=36960.327, distinct(12)=22217.3354, null(12)=0, distinct(13)=9681.00153, null(13)=0, distinct(17)=22217.3354, null(17)=0] 100 │ │ ├── key: (13,17) 101 │ │ ├── fd: (12)==(17), (17)==(12) 102 │ │ └── inner-join (hash) 103 │ │ ├── save-table-name: q20_inner_join_8 104 │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) ps_availqty:14(int!null) p_partkey:17(int!null) p_name:18(varchar!null) sum:42(float) 105 │ │ ├── stats: [rows=36960.327, distinct(12)=22217.3354, null(12)=0, distinct(13)=9681.00153, null(13)=0, distinct(14)=34508.432, null(14)=0, distinct(17)=22217.3354, null(17)=0, distinct(18)=17907.1379, null(18)=0, distinct(42)=34508.432, null(42)=0] 106 │ │ ├── key: (13,17) 107 │ │ ├── fd: (12,13)-->(14,42), (17)-->(18), (12)==(17), (17)==(12) 108 │ │ ├── select 109 │ │ │ ├── save-table-name: q20_select_9 110 │ │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) ps_availqty:14(int!null) sum:42(float) 111 │ │ │ ├── stats: [rows=266100.667, distinct(12)=159991.77, null(12)=0, distinct(13)=9920, null(13)=0, distinct(14)=266100.667, null(14)=0, distinct(42)=266100.667, null(42)=0] 112 │ │ │ ├── key: (12,13) 113 │ │ │ ├── fd: (12,13)-->(14,42) 114 │ │ │ ├── group-by 115 │ │ │ │ ├── save-table-name: q20_group_by_10 116 │ │ │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) ps_availqty:14(int!null) sum:42(float) 117 │ │ │ │ ├── grouping columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) 118 │ │ │ │ ├── stats: [rows=798302, distinct(12)=199241, null(12)=0, distinct(13)=9920, null(13)=0, distinct(14)=798302, null(14)=0, distinct(42)=798302, null(42)=0, distinct(12,13)=798302, null(12,13)=0] 119 │ │ │ │ ├── key: (12,13) 120 │ │ │ │ ├── fd: (12,13)-->(14,42) 121 │ │ │ │ ├── right-join (hash) 122 │ │ │ │ │ ├── save-table-name: q20_right_join_11 123 │ │ │ │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) ps_availqty:14(int!null) l_partkey:27(int) l_suppkey:28(int) l_quantity:30(float) l_shipdate:36(date) 124 │ │ │ │ │ ├── stats: [rows=800000, distinct(12)=199241, null(12)=0, distinct(13)=9920, null(13)=0, distinct(14)=9920, null(14)=0, distinct(27)=379.722303, null(27)=799620.278, distinct(28)=379.722303, null(28)=799620.278, distinct(30)=49.9748381, null(30)=799620.278, distinct(36)=236.032274, null(36)=799620.278, distinct(12,13)=798302, null(12,13)=0] 125 │ │ │ │ │ ├── fd: (12,13)-->(14) 126 │ │ │ │ │ ├── index-join lineitem 127 │ │ │ │ │ │ ├── save-table-name: q20_index_join_12 128 │ │ │ │ │ │ ├── columns: l_partkey:27(int!null) l_suppkey:28(int!null) l_quantity:30(float!null) l_shipdate:36(date!null) 129 │ │ │ │ │ │ ├── stats: [rows=938137.516, distinct(27)=198050.435, null(27)=0, distinct(28)=9920, null(28)=0, distinct(30)=50, null(30)=0, distinct(36)=365, null(36)=0] 130 │ │ │ │ │ │ │ histogram(36)= 0 0 3150.6 4200 25805 3600 25805 3600 26405 3600 28805 1200 27605 2400 27005 3600 28805 1200 27005 4800 28205 3000 25205 4800 28805 4800 28805 600 28205 1200 24604 6601 24604 4800 28205 3600 27605 3600 27005 4200 28205 2400 28205 4200 28805 1200 28205 1800 28205 1200 28205 3000 27005 4800 28805 600 27005 3600 25805 5401 27005 2400 28205 3000 11502 2300.4 131 │ │ │ │ │ │ │ <--- '1993-12-31' -------- '1994-01-02' ------- '1994-01-16' ------- '1994-01-30' ------- '1994-02-08' ------- '1994-02-18' ------- '1994-03-04' ------- '1994-03-15' ------- '1994-03-29' ------- '1994-04-10' ------- '1994-04-24' ------- '1994-05-03' ------- '1994-05-13' ------- '1994-05-24' ------- '1994-06-04' ------- '1994-06-13' ------- '1994-06-22' ------- '1994-07-05' ------- '1994-07-16' ------- '1994-07-29' ------- '1994-08-09' ------- '1994-08-22' ------- '1994-09-04' ------- '1994-09-15' ------- '1994-09-29' ------- '1994-10-10' ------- '1994-10-20' ------- '1994-11-03' ------- '1994-11-16' ------- '1994-11-29' ------- '1994-12-11' ------- '1994-12-25' ------- '1994-12-31' 132 │ │ │ │ │ │ └── scan lineitem@l_sd 133 │ │ │ │ │ │ ├── save-table-name: q20_scan_13 134 │ │ │ │ │ │ ├── columns: l_orderkey:26(int!null) l_linenumber:29(int!null) l_shipdate:36(date!null) 135 │ │ │ │ │ │ ├── constraint: /36/26/29: [/'1994-01-01' - /'1994-12-31'] 136 │ │ │ │ │ │ ├── stats: [rows=938137.516, distinct(26)=744144.6, null(26)=0, distinct(29)=7, null(29)=0, distinct(36)=365, null(36)=0] 137 │ │ │ │ │ │ │ histogram(26)= 0 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4596.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 4690.7 93.795 138 │ │ │ │ │ │ │ <--- 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 139 │ │ │ │ │ │ │ histogram(36)= 0 0 3150.6 4200 25805 3600 25805 3600 26405 3600 28805 1200 27605 2400 27005 3600 28805 1200 27005 4800 28205 3000 25205 4800 28805 4800 28805 600 28205 1200 24604 6601 24604 4800 28205 3600 27605 3600 27005 4200 28205 2400 28205 4200 28805 1200 28205 1800 28205 1200 28205 3000 27005 4800 28805 600 27005 3600 25805 5401 27005 2400 28205 3000 11502 2300.4 140 │ │ │ │ │ │ │ <--- '1993-12-31' -------- '1994-01-02' ------- '1994-01-16' ------- '1994-01-30' ------- '1994-02-08' ------- '1994-02-18' ------- '1994-03-04' ------- '1994-03-15' ------- '1994-03-29' ------- '1994-04-10' ------- '1994-04-24' ------- '1994-05-03' ------- '1994-05-13' ------- '1994-05-24' ------- '1994-06-04' ------- '1994-06-13' ------- '1994-06-22' ------- '1994-07-05' ------- '1994-07-16' ------- '1994-07-29' ------- '1994-08-09' ------- '1994-08-22' ------- '1994-09-04' ------- '1994-09-15' ------- '1994-09-29' ------- '1994-10-10' ------- '1994-10-20' ------- '1994-11-03' ------- '1994-11-16' ------- '1994-11-29' ------- '1994-12-11' ------- '1994-12-25' ------- '1994-12-31' 141 │ │ │ │ │ │ ├── key: (26,29) 142 │ │ │ │ │ │ └── fd: (26,29)-->(36) 143 │ │ │ │ │ ├── scan partsupp 144 │ │ │ │ │ │ ├── save-table-name: q20_scan_14 145 │ │ │ │ │ │ ├── columns: ps_partkey:12(int!null) ps_suppkey:13(int!null) ps_availqty:14(int!null) 146 │ │ │ │ │ │ ├── stats: [rows=800000, distinct(12)=199241, null(12)=0, distinct(13)=9920, null(13)=0, distinct(14)=9920, null(14)=0, distinct(12,13)=798302, null(12,13)=0] 147 │ │ │ │ │ │ │ histogram(12)= 0 80 3920 80 3920 80 3920 80 3920 80 3840 160 3840 160 3920 80 3920 80 3920 80 3920 80 3920 160 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3840 160 3920 80 3920 80 3920 80 3920 80 3920 160 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3840 160 3920 80 3920 80 3920 160 3920 80 3920 160 3920 80 3920 80 3920 80 3920 80 3920 80 3920 160 3920 80 3920 80 3920 80 3920 80 3920 80 3920 160 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 3920 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 3920 160 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 4000 80 148 │ │ │ │ │ │ │ <--- 4 ------ 793 ------ 1856 ------ 2808 ------ 3809 ------ 4923 ------ 5975 ------ 6944 ------ 8085 ------ 8945 ------ 9831 ------ 10952 ------ 11932 ------ 12775 ------ 13849 ------ 14925 ------ 16016 ------ 16828 ------ 17768 ------ 18705 ------ 19631 ------ 20600 ------ 21491 ------ 22254 ------ 23327 ------ 24491 ------ 25470 ------ 26331 ------ 27327 ------ 28308 ------ 29359 ------ 30542 ------ 31592 ------ 32495 ------ 33408 ------ 34624 ------ 35726 ------ 36676 ------ 37637 ------ 38485 ------ 39368 ------ 40372 ------ 41034 ------ 42185 ------ 43333 ------ 44466 ------ 45440 ------ 46571 ------ 47469 ------ 48346 ------ 49379 ------ 50571 ------ 51830 ------ 52967 ------ 53673 ------ 54656 ------ 55504 ------ 56539 ------ 57393 ------ 58366 ------ 59577 ------ 60559 ------ 61676 ------ 62471 ------ 63421 ------ 64449 ------ 65409 ------ 66254 ------ 67127 ------ 68127 ------ 69177 ------ 70183 ------ 71209 ------ 72101 ------ 73102 ------ 73994 ------ 74899 ------ 76016 ------ 77098 ------ 77842 ------ 79137 ------ 80242 ------ 81364 ------ 82331 ------ 83158 ------ 84283 ------ 85282 ------ 86437 ------ 87450 ------ 88419 ------ 89493 ------ 90478 ------ 91468 ------ 92552 ------ 93200 ------ 94191 ------ 95067 ------ 96272 ------ 97228 ------ 98126 ------ 99198 ------ 100219 ------ 101057 ------ 102038 ------ 102775 ------ 103711 ------ 104623 ------ 105710 ------ 106734 ------ 107932 ------ 109255 ------ 110220 ------ 111235 ------ 112174 ------ 113260 ------ 114081 ------ 115103 ------ 115864 ------ 116794 ------ 117741 ------ 118712 ------ 119470 ------ 120528 ------ 121572 ------ 122536 ------ 123629 ------ 124404 ------ 125301 ------ 126257 ------ 127139 ------ 128267 ------ 129258 ------ 130442 ------ 131845 ------ 133164 ------ 134005 ------ 135076 ------ 135868 ------ 137297 ------ 138777 ------ 139806 ------ 140741 ------ 141896 ------ 142719 ------ 143727 ------ 144645 ------ 145510 ------ 146507 ------ 147449 ------ 148467 ------ 149635 ------ 150563 ------ 151751 ------ 152613 ------ 153416 ------ 154612 ------ 155853 ------ 156866 ------ 158311 ------ 159230 ------ 160390 ------ 161455 ------ 162555 ------ 163435 ------ 164549 ------ 165663 ------ 166891 ------ 167757 ------ 168732 ------ 169644 ------ 170532 ------ 171671 ------ 172778 ------ 173599 ------ 174321 ------ 175624 ------ 176663 ------ 177632 ------ 178555 ------ 179551 ------ 180510 ------ 181682 ------ 182648 ------ 183408 ------ 184543 ------ 185722 ------ 186713 ------ 187787 ------ 188730 ------ 189604 ------ 190711 ------ 191690 ------ 192692 ------ 193702 ------ 194685 ------ 195725 ------ 196730 ------ 197724 ------ 198701 ------ 199973 149 │ │ │ │ │ │ │ histogram(13)= 0 80 3920 240 3920 80 3920 160 3920 80 3920 240 3920 80 3760 320 3680 320 3920 80 3920 160 3920 240 3920 80 3920 160 3840 160 3920 80 3920 80 3760 240 3840 160 3920 80 3840 160 3680 320 3920 80 3840 160 3840 160 3760 320 3840 160 3840 160 3920 80 3840 240 3920 80 3920 80 3840 160 3760 240 3920 160 3920 80 3920 80 3920 80 3920 320 3920 80 3920 160 3840 400 3760 240 3920 160 3920 160 3600 480 3920 80 3680 320 3840 160 3840 160 3920 240 3840 160 3920 160 3920 80 3920 160 3920 80 3760 240 3920 80 3920 80 3840 320 3840 160 3840 160 3920 240 3840 480 3920 160 3840 240 3920 160 3920 160 3920 80 3840 160 3920 80 3920 80 3920 80 3920 80 3840 240 3840 240 3920 80 3840 320 3920 80 3920 80 3920 240 3840 240 3920 160 3920 80 3840 160 3840 240 3920 240 3840 80 3680 320 3920 160 3840 160 3840 80 3920 80 3840 160 3840 160 3920 80 3920 80 3840 160 3920 80 3920 160 3840 240 3840 80 3840 160 3760 160 3920 80 3920 80 3840 240 3760 240 3840 80 3920 160 3840 80 3920 80 3920 80 3920 80 3920 160 3840 80 3920 80 3760 240 3920 80 3920 160 3760 160 3920 160 3840 80 3920 160 3840 160 3840 160 3600 320 3920 160 3840 80 3920 80 3680 320 3840 240 3760 160 3920 80 3920 80 3920 80 3920 80 3920 80 3680 320 3920 160 3840 160 3760 160 3920 240 3840 160 3840 240 3600 320 3840 80 3840 80 3920 160 3760 160 3840 160 3840 320 3840 80 3840 160 3760 240 3840 80 3840 240 3760 160 3840 160 3840 160 3920 240 3760 160 3840 80 3920 160 3680 240 3840 160 3840 160 3760 240 3920 80 3920 240 3760 160 3760 240 3840 80 3840 240 3840 240 3760 320 3760 240 3840 80 3840 160 3840 240 3760 320 3760 160 3840 160 3840 160 3840 80 3760 160 3840 80 3840 160 3920 160 3840 80 3920 80 3840 160 3920 80 3840 240 3840 80 3920 80 3760 240 3920 240 3840 80 3680 240 150 │ │ │ │ │ │ │ <--- 2 ------ 49 ------ 90 ------ 141 ------ 183 ------ 235 ------ 278 ------ 319 ------ 360 ------ 406 ------ 458 ------ 511 ------ 561 ------ 622 ------ 674 ------ 731 ------ 781 ------ 822 ------ 882 ------ 934 ------ 988 ------ 1026 ------ 1072 ------ 1114 ------ 1188 ------ 1245 ------ 1291 ------ 1335 ------ 1380 ------ 1433 ------ 1488 ------ 1537 ------ 1590 ------ 1642 ------ 1692 ------ 1751 ------ 1807 ------ 1846 ------ 1887 ------ 1939 ------ 1994 ------ 2045 ------ 2097 ------ 2139 ------ 2190 ------ 2240 ------ 2293 ------ 2344 ------ 2385 ------ 2427 ------ 2484 ------ 2538 ------ 2601 ------ 2651 ------ 2730 ------ 2781 ------ 2825 ------ 2874 ------ 2938 ------ 2978 ------ 3034 ------ 3086 ------ 3139 ------ 3179 ------ 3231 ------ 3274 ------ 3334 ------ 3387 ------ 3431 ------ 3477 ------ 3530 ------ 3581 ------ 3633 ------ 3680 ------ 3725 ------ 3775 ------ 3820 ------ 3876 ------ 3923 ------ 3982 ------ 4036 ------ 4078 ------ 4116 ------ 4183 ------ 4227 ------ 4275 ------ 4336 ------ 4376 ------ 4424 ------ 4481 ------ 4537 ------ 4582 ------ 4630 ------ 4680 ------ 4727 ------ 4779 ------ 4828 ------ 4881 ------ 4938 ------ 4986 ------ 5040 ------ 5087 ------ 5138 ------ 5188 ------ 5237 ------ 5280 ------ 5318 ------ 5358 ------ 5405 ------ 5459 ------ 5516 ------ 5561 ------ 5615 ------ 5681 ------ 5744 ------ 5790 ------ 5847 ------ 5885 ------ 5927 ------ 5991 ------ 6042 ------ 6111 ------ 6165 ------ 6207 ------ 6259 ------ 6313 ------ 6359 ------ 6418 ------ 6471 ------ 6530 ------ 6587 ------ 6626 ------ 6672 ------ 6739 ------ 6784 ------ 6837 ------ 6886 ------ 6952 ------ 6994 ------ 7040 ------ 7081 ------ 7134 ------ 7178 ------ 7232 ------ 7280 ------ 7330 ------ 7378 ------ 7435 ------ 7486 ------ 7537 ------ 7593 ------ 7636 ------ 7680 ------ 7737 ------ 7788 ------ 7836 ------ 7877 ------ 7928 ------ 7993 ------ 8036 ------ 8083 ------ 8135 ------ 8180 ------ 8221 ------ 8263 ------ 8313 ------ 8352 ------ 8399 ------ 8453 ------ 8517 ------ 8566 ------ 8612 ------ 8664 ------ 8716 ------ 8766 ------ 8821 ------ 8871 ------ 8922 ------ 8956 ------ 9007 ------ 9050 ------ 9100 ------ 9154 ------ 9203 ------ 9246 ------ 9311 ------ 9358 ------ 9407 ------ 9470 ------ 9525 ------ 9564 ------ 9633 ------ 9672 ------ 9730 ------ 9778 ------ 9824 ------ 9868 ------ 9919 ------ 9959 ------ 10000 151 │ │ │ │ │ │ ├── key: (12,13) 152 │ │ │ │ │ │ └── fd: (12,13)-->(14) 153 │ │ │ │ │ └── filters 154 │ │ │ │ │ ├── l_partkey:27 = ps_partkey:12 [type=bool, outer=(12,27), constraints=(/12: (/NULL - ]; /27: (/NULL - ]), fd=(12)==(27), (27)==(12)] 155 │ │ │ │ │ └── l_suppkey:28 = ps_suppkey:13 [type=bool, outer=(13,28), constraints=(/13: (/NULL - ]; /28: (/NULL - ]), fd=(13)==(28), (28)==(13)] 156 │ │ │ │ └── aggregations 157 │ │ │ │ ├── sum [as=sum:42, type=float, outer=(30)] 158 │ │ │ │ │ └── l_quantity:30 [type=float] 159 │ │ │ │ └── const-agg [as=ps_availqty:14, type=int, outer=(14)] 160 │ │ │ │ └── ps_availqty:14 [type=int] 161 │ │ │ └── filters 162 │ │ │ └── ps_availqty:14 > (sum:42 * 0.5) [type=bool, outer=(14,42), constraints=(/14: (/NULL - ])] 163 │ │ ├── select 164 │ │ │ ├── save-table-name: q20_select_15 165 │ │ │ ├── columns: p_partkey:17(int!null) p_name:18(varchar!null) 166 │ │ │ ├── stats: [rows=22222.2222, distinct(17)=22217.3354, null(17)=0, distinct(18)=22014.5556, null(18)=0] 167 │ │ │ ├── key: (17) 168 │ │ │ ├── fd: (17)-->(18) 169 │ │ │ ├── scan part 170 │ │ │ │ ├── save-table-name: q20_scan_16 171 │ │ │ │ ├── columns: p_partkey:17(int!null) p_name:18(varchar!null) 172 │ │ │ │ ├── stats: [rows=200000, distinct(17)=199241, null(17)=0, distinct(18)=198131, null(18)=0] 173 │ │ │ │ │ histogram(17)= 0 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 980 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 1000 20 174 │ │ │ │ │ <--- 27 ----- 1110 ----- 2241 ----- 3086 ----- 4134 ----- 5302 ----- 6222 ----- 7308 ----- 8249 ----- 9171 ----- 10049 ----- 10958 ----- 11832 ----- 13025 ----- 14063 ----- 14953 ----- 16249 ----- 17419 ----- 18363 ----- 19412 ----- 20257 ----- 21190 ----- 22110 ----- 23045 ----- 23956 ----- 24962 ----- 25942 ----- 26990 ----- 27934 ----- 28876 ----- 29513 ----- 30326 ----- 31259 ----- 32300 ----- 33577 ----- 34550 ----- 35562 ----- 36498 ----- 37475 ----- 38584 ----- 39641 ----- 40548 ----- 41605 ----- 42527 ----- 43612 ----- 44702 ----- 45701 ----- 46726 ----- 47795 ----- 48935 ----- 50152 ----- 51183 ----- 52001 ----- 52904 ----- 53868 ----- 54808 ----- 55986 ----- 57155 ----- 58516 ----- 59526 ----- 60557 ----- 61547 ----- 62369 ----- 63672 ----- 64583 ----- 65360 ----- 66147 ----- 67201 ----- 68142 ----- 69145 ----- 70209 ----- 71141 ----- 71923 ----- 73031 ----- 73987 ----- 74974 ----- 76170 ----- 77138 ----- 77849 ----- 78931 ----- 79832 ----- 80761 ----- 81843 ----- 82834 ----- 84032 ----- 85072 ----- 86287 ----- 87302 ----- 88422 ----- 89432 ----- 90550 ----- 91463 ----- 92249 ----- 93385 ----- 94789 ----- 96013 ----- 96893 ----- 98000 ----- 99008 ----- 100166 ----- 101263 ----- 102351 ----- 103236 ----- 104121 ----- 105363 ----- 106329 ----- 107325 ----- 108231 ----- 109054 ----- 110019 ----- 111185 ----- 112112 ----- 112908 ----- 113904 ----- 114785 ----- 115410 ----- 116526 ----- 117559 ----- 118310 ----- 119073 ----- 120034 ----- 120817 ----- 121744 ----- 122566 ----- 123720 ----- 124813 ----- 125835 ----- 126622 ----- 127651 ----- 128328 ----- 129315 ----- 130244 ----- 131450 ----- 132439 ----- 133288 ----- 134164 ----- 135298 ----- 136347 ----- 137243 ----- 138256 ----- 139427 ----- 140374 ----- 141371 ----- 142302 ----- 143322 ----- 144335 ----- 145333 ----- 146212 ----- 147321 ----- 148591 ----- 149594 ------ 150514 ------ 151361 ------ 152059 ------ 153070 ------ 154059 ------ 155259 ------ 156473 ------ 157690 ------ 158703 ------ 159675 ------ 160597 ------ 161668 ------ 162737 ------ 163955 ------ 164942 ------ 165924 ------ 167059 ------ 167866 ------ 169034 ------ 169935 ------ 170712 ------ 171806 ------ 172841 ------ 174078 ------ 175347 ------ 176430 ------ 177346 ------ 178566 ------ 179515 ------ 180677 ------ 181729 ------ 182983 ------ 183814 ------ 184892 ------ 185696 ------ 186611 ------ 187744 ------ 188974 ------ 189911 ------ 190671 ------ 191607 ------ 192820 ------ 193789 ------ 195057 ------ 196224 ------ 197231 ------ 198281 ------ 199119 ------ 199999 175 │ │ │ │ ├── key: (17) 176 │ │ │ │ └── fd: (17)-->(18) 177 │ │ │ └── filters 178 │ │ │ └── p_name:18 LIKE 'forest%' [type=bool, outer=(18), constraints=(/18: [/'forest' - /'foresu'); tight)] 179 │ │ └── filters 180 │ │ └── ps_partkey:12 = p_partkey:17 [type=bool, outer=(12,17), constraints=(/12: (/NULL - ]; /17: (/NULL - ]), fd=(12)==(17), (17)==(12)] 181 │ └── filters 182 │ └── s_suppkey:1 = ps_suppkey:13 [type=bool, outer=(1,13), constraints=(/1: (/NULL - ]; /13: (/NULL - ]), fd=(1)==(13), (13)==(1)] 183 ├── select 184 │ ├── save-table-name: q20_select_17 185 │ ├── columns: n_nationkey:8(int!null) n_name:9(char!null) 186 │ ├── stats: [rows=1, distinct(8)=1, null(8)=0, distinct(9)=1, null(9)=0] 187 │ ├── key: (8) 188 │ ├── fd: ()-->(9) 189 │ ├── scan nation 190 │ │ ├── save-table-name: q20_scan_18 191 │ │ ├── columns: n_nationkey:8(int!null) n_name:9(char!null) 192 │ │ ├── stats: [rows=25, distinct(8)=25, null(8)=0, distinct(9)=25, null(9)=0] 193 │ │ │ histogram(8)= 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 194 │ │ │ <--- 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 195 │ │ ├── key: (8) 196 │ │ └── fd: (8)-->(9) 197 │ └── filters 198 │ └── n_name:9 = 'CANADA' [type=bool, outer=(9), constraints=(/9: [/'CANADA' - /'CANADA']; tight), fd=()-->(9)] 199 └── filters 200 └── s_nationkey:4 = n_nationkey:8 [type=bool, outer=(4,8), constraints=(/4: (/NULL - ]; /8: (/NULL - ]), fd=(4)==(8), (8)==(4)] 201 202 stats table=q20_sort_1 203 ---- 204 column_names row_count distinct_count null_count 205 {s_address} 186 186 0 206 {s_name} 186 186 0 207 ~~~~ 208 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 209 {s_address} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 210 {s_name} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 211 212 stats table=q20_project_2 213 ---- 214 column_names row_count distinct_count null_count 215 {s_address} 186 186 0 216 {s_name} 186 186 0 217 ~~~~ 218 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 219 {s_address} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 220 {s_name} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 221 222 stats table=q20_inner_join_3 223 ---- 224 column_names row_count distinct_count null_count 225 {n_name} 186 1 0 226 {n_nationkey} 186 1 0 227 {s_address} 186 186 0 228 {s_name} 186 186 0 229 {s_nationkey} 186 1 0 230 {s_suppkey} 186 186 0 231 ~~~~ 232 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 233 {n_name} 393.00 2.11 <== 1.00 1.00 0.00 1.00 234 {n_nationkey} 393.00 2.11 <== 1.00 1.00 0.00 1.00 235 {s_address} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 236 {s_name} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 237 {s_nationkey} 393.00 2.11 <== 1.00 1.00 0.00 1.00 238 {s_suppkey} 393.00 2.11 <== 393.00 2.11 <== 0.00 1.00 239 240 stats table=q20_semi_join_4 241 ---- 242 column_names row_count distinct_count null_count 243 {s_address} 4397 4369 0 244 {s_name} 4397 4373 0 245 {s_nationkey} 4397 25 0 246 {s_suppkey} 4397 4434 0 247 ~~~~ 248 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 249 {s_address} 9819.00 2.23 <== 9819.00 2.25 <== 0.00 1.00 250 {s_name} 9819.00 2.23 <== 9810.00 2.24 <== 0.00 1.00 251 {s_nationkey} 9819.00 2.23 <== 25.00 1.00 0.00 1.00 252 {s_suppkey} 9819.00 2.23 <== 9740.00 2.20 <== 0.00 1.00 253 254 stats table=q20_scan_5 255 ---- 256 column_names row_count distinct_count null_count 257 {s_address} 10000 10027 0 258 {s_name} 10000 9990 0 259 {s_nationkey} 10000 25 0 260 {s_suppkey} 10000 9920 0 261 ~~~~ 262 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 263 {s_address} 10000.00 1.00 10000.00 1.00 0.00 1.00 264 {s_name} 10000.00 1.00 9990.00 1.00 0.00 1.00 265 {s_nationkey} 10000.00 1.00 25.00 1.00 0.00 1.00 266 {s_suppkey} 10000.00 1.00 9920.00 1.00 0.00 1.00 267 268 stats table=q20_project_6 269 ---- 270 column_names row_count distinct_count null_count 271 {ps_partkey} 5833 2106 0 272 {ps_suppkey} 5833 4434 0 273 ~~~~ 274 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 275 {ps_partkey} 36952.00 6.33 <== 22217.00 10.55 <== 0.00 1.00 276 {ps_suppkey} 36952.00 6.33 <== 9740.00 2.20 <== 0.00 1.00 277 278 stats table=q20_project_7 279 ---- 280 column_names row_count distinct_count null_count 281 {p_partkey} 5833 2106 0 282 {ps_partkey} 5833 2106 0 283 {ps_suppkey} 5833 4434 0 284 ~~~~ 285 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 286 {p_partkey} 36960.00 6.34 <== 22217.00 10.55 <== 0.00 1.00 287 {ps_partkey} 36960.00 6.34 <== 22217.00 10.55 <== 0.00 1.00 288 {ps_suppkey} 36960.00 6.34 <== 9681.00 2.18 <== 0.00 1.00 289 290 stats table=q20_inner_join_8 291 ---- 292 column_names row_count distinct_count null_count 293 {p_name} 5833 2106 0 294 {p_partkey} 5833 2106 0 295 {ps_availqty} 5833 4441 0 296 {ps_partkey} 5833 2106 0 297 {ps_suppkey} 5833 4434 0 298 {sum} 5833 164 0 299 ~~~~ 300 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 301 {p_name} 36960.00 6.34 <== 17907.00 8.50 <== 0.00 1.00 302 {p_partkey} 36960.00 6.34 <== 22217.00 10.55 <== 0.00 1.00 303 {ps_availqty} 36960.00 6.34 <== 34508.00 7.77 <== 0.00 1.00 304 {ps_partkey} 36960.00 6.34 <== 22217.00 10.55 <== 0.00 1.00 305 {ps_suppkey} 36960.00 6.34 <== 9681.00 2.18 <== 0.00 1.00 306 {sum} 36960.00 6.34 <== 34508.00 210.41 <== 0.00 1.00 307 308 stats table=q20_select_9 309 ---- 310 column_names row_count distinct_count null_count 311 {ps_availqty} 542095 9920 0 312 {ps_partkey} 542095 197197 0 313 {ps_suppkey} 542095 9920 0 314 {sum} 542095 246 0 315 ~~~~ 316 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 317 {ps_availqty} 266101.00 2.04 <== 266101.00 26.82 <== 0.00 1.00 318 {ps_partkey} 266101.00 2.04 <== 159992.00 1.23 0.00 1.00 319 {ps_suppkey} 266101.00 2.04 <== 9920.00 1.00 0.00 1.00 320 {sum} 266101.00 2.04 <== 266101.00 1081.71 <== 0.00 1.00 321 322 stats table=q20_group_by_10 323 ---- 324 column_names row_count distinct_count null_count 325 {ps_availqty} 800000 9920 0 326 {ps_partkey} 800000 199241 0 327 {ps_suppkey} 800000 9920 0 328 {sum} 800000 247 256790 329 ~~~~ 330 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 331 {ps_availqty} 798302.00 1.00 798302.00 80.47 <== 0.00 1.00 332 {ps_partkey} 798302.00 1.00 199241.00 1.00 0.00 1.00 333 {ps_suppkey} 798302.00 1.00 9920.00 1.00 0.00 1.00 334 {sum} 798302.00 1.00 798302.00 3231.99 <== 0.00 +Inf <== 335 336 stats table=q20_right_join_11 337 ---- 338 column_names row_count distinct_count null_count 339 {l_partkey} 1166245 197252 256790 340 {l_quantity} 1166245 51 256790 341 {l_shipdate} 1166245 366 256790 342 {l_suppkey} 1166245 9922 256790 343 {ps_availqty} 1166245 9920 0 344 {ps_partkey} 1166245 199241 0 345 {ps_suppkey} 1166245 9920 0 346 ~~~~ 347 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 348 {l_partkey} 800000.00 1.46 380.00 519.08 <== 799620.00 3.11 <== 349 {l_quantity} 800000.00 1.46 50.00 1.02 799620.00 3.11 <== 350 {l_shipdate} 800000.00 1.46 236.00 1.55 799620.00 3.11 <== 351 {l_suppkey} 800000.00 1.46 380.00 26.11 <== 799620.00 3.11 <== 352 {ps_availqty} 800000.00 1.46 9920.00 1.00 0.00 1.00 353 {ps_partkey} 800000.00 1.46 199241.00 1.00 0.00 1.00 354 {ps_suppkey} 800000.00 1.46 9920.00 1.00 0.00 1.00 355 356 stats table=q20_index_join_12 357 ---- 358 column_names row_count distinct_count null_count 359 {l_partkey} 909455 197252 0 360 {l_quantity} 909455 50 0 361 {l_shipdate} 909455 365 0 362 {l_suppkey} 909455 9920 0 363 ~~~~ 364 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 365 {l_partkey} 938138.00 1.03 198050.00 1.00 0.00 1.00 366 {l_quantity} 938138.00 1.03 50.00 1.00 0.00 1.00 367 {l_shipdate} 938138.00 1.03 365.00 1.00 0.00 1.00 368 {l_suppkey} 938138.00 1.03 9920.00 1.00 0.00 1.00 369 370 stats table=q20_scan_14 371 ---- 372 column_names row_count distinct_count null_count 373 {ps_availqty} 800000 9920 0 374 {ps_partkey} 800000 199241 0 375 {ps_suppkey} 800000 9920 0 376 ~~~~ 377 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 378 {ps_availqty} 800000.00 1.00 9920.00 1.00 0.00 1.00 379 {ps_partkey} 800000.00 1.00 199241.00 1.00 0.00 1.00 380 {ps_suppkey} 800000.00 1.00 9920.00 1.00 0.00 1.00 381 382 stats table=q20_select_15 383 ---- 384 column_names row_count distinct_count null_count 385 {p_name} 2127 2127 0 386 {p_partkey} 2127 2127 0 387 ~~~~ 388 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 389 {p_name} 22222.00 10.45 <== 22015.00 10.35 <== 0.00 1.00 390 {p_partkey} 22222.00 10.45 <== 22217.00 10.45 <== 0.00 1.00 391 392 stats table=q20_scan_16 393 ---- 394 column_names row_count distinct_count null_count 395 {p_name} 200000 198131 0 396 {p_partkey} 200000 199241 0 397 ~~~~ 398 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 399 {p_name} 200000.00 1.00 198131.00 1.00 0.00 1.00 400 {p_partkey} 200000.00 1.00 199241.00 1.00 0.00 1.00 401 402 stats table=q20_select_17 403 ---- 404 column_names row_count distinct_count null_count 405 {n_name} 1 1 0 406 {n_nationkey} 1 1 0 407 ~~~~ 408 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 409 {n_name} 1.00 1.00 1.00 1.00 0.00 1.00 410 {n_nationkey} 1.00 1.00 1.00 1.00 0.00 1.00 411 412 stats table=q20_scan_18 413 ---- 414 column_names row_count distinct_count null_count 415 {n_name} 25 25 0 416 {n_nationkey} 25 25 0 417 ~~~~ 418 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 419 {n_name} 25.00 1.00 25.00 1.00 0.00 1.00 420 {n_nationkey} 25.00 1.00 25.00 1.00 0.00 1.00