github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/stats_quality/tpch/q11 (about) 1 import file=tpch_schema 2 ---- 3 4 import file=tpch_stats 5 ---- 6 7 # -------------------------------------------------- 8 # Q11 9 # Important Stock Identification 10 # Finds the most important subset of suppliers' stock in a given nation. 11 # 12 # Finds, from scanning the available stock of suppliers in a given nation, all 13 # the parts that represent a significant percentage of the total value of all 14 # available parts. The query displays the part number and the value of those 15 # parts in descending order of value. 16 # -------------------------------------------------- 17 save-tables database=tpch save-tables-prefix=q11 18 SELECT 19 ps_partkey, 20 sum(ps_supplycost * ps_availqty::float) AS value 21 FROM 22 partsupp, 23 supplier, 24 nation 25 WHERE 26 ps_suppkey = s_suppkey 27 AND s_nationkey = n_nationkey 28 AND n_name = 'GERMANY' 29 GROUP BY 30 ps_partkey HAVING 31 sum(ps_supplycost * ps_availqty::float) > ( 32 SELECT 33 sum(ps_supplycost * ps_availqty::float) * 0.0001 34 FROM 35 partsupp, 36 supplier, 37 nation 38 WHERE 39 ps_suppkey = s_suppkey 40 AND s_nationkey = n_nationkey 41 AND n_name = 'GERMANY' 42 ) 43 ORDER BY 44 value DESC; 45 ---- 46 sort 47 ├── save-table-name: q11_sort_1 48 ├── columns: ps_partkey:1(int!null) value:18(float!null) 49 ├── stats: [rows=9927.82897, distinct(1)=9927.82897, null(1)=0, distinct(18)=9927.82897, null(18)=0] 50 ├── key: (1) 51 ├── fd: (1)-->(18) 52 ├── ordering: -18 53 └── select 54 ├── save-table-name: q11_select_2 55 ├── columns: ps_partkey:1(int!null) sum:18(float!null) 56 ├── stats: [rows=9927.82897, distinct(1)=9927.82897, null(1)=0, distinct(18)=9927.82897, null(18)=0] 57 ├── key: (1) 58 ├── fd: (1)-->(18) 59 ├── group-by 60 │ ├── save-table-name: q11_group_by_3 61 │ ├── columns: ps_partkey:1(int!null) sum:18(float!null) 62 │ ├── grouping columns: ps_partkey:1(int!null) 63 │ ├── stats: [rows=29783.4869, distinct(1)=29783.4869, null(1)=0, distinct(18)=29783.4869, null(18)=0] 64 │ ├── key: (1) 65 │ ├── fd: (1)-->(18) 66 │ ├── project 67 │ │ ├── save-table-name: q11_project_4 68 │ │ ├── columns: column17:17(float!null) ps_partkey:1(int!null) 69 │ │ ├── stats: [rows=32258.0645, distinct(1)=29783.4869, null(1)=0, distinct(17)=31617.9161, null(17)=0] 70 │ │ ├── inner-join (lookup partsupp) 71 │ │ │ ├── save-table-name: q11_lookup_join_5 72 │ │ │ ├── columns: ps_partkey:1(int!null) ps_suppkey:2(int!null) ps_availqty:3(int!null) ps_supplycost:4(float!null) s_suppkey:6(int!null) s_nationkey:9(int!null) n_nationkey:13(int!null) n_name:14(char!null) 73 │ │ │ ├── key columns: [1 2] = [1 2] 74 │ │ │ ├── lookup columns are key 75 │ │ │ ├── stats: [rows=32258.0645, distinct(1)=29783.4869, null(1)=0, distinct(2)=399.934613, null(2)=0, distinct(3)=9536.12259, null(3)=0, distinct(4)=27589.3232, null(4)=0, distinct(6)=399.934613, null(6)=0, distinct(9)=1, null(9)=0, distinct(13)=1, null(13)=0, distinct(14)=1, null(14)=0, distinct(3,4)=31617.9161, null(3,4)=0] 76 │ │ │ ├── key: (1,6) 77 │ │ │ ├── fd: ()-->(14), (1,2)-->(3,4), (6)-->(9), (9)==(13), (13)==(9), (2)==(6), (6)==(2) 78 │ │ │ ├── inner-join (lookup partsupp@ps_sk) 79 │ │ │ │ ├── save-table-name: q11_lookup_join_6 80 │ │ │ │ ├── columns: ps_partkey:1(int!null) ps_suppkey:2(int!null) s_suppkey:6(int!null) s_nationkey:9(int!null) n_nationkey:13(int!null) n_name:14(char!null) 81 │ │ │ │ ├── key columns: [6] = [2] 82 │ │ │ │ ├── stats: [rows=32258.0645, distinct(1)=29783.4869, null(1)=0, distinct(2)=399.934613, null(2)=0, distinct(6)=399.934613, null(6)=0, distinct(9)=1, null(9)=0, distinct(13)=1, null(13)=0, distinct(14)=1, null(14)=0] 83 │ │ │ │ ├── key: (1,6) 84 │ │ │ │ ├── fd: ()-->(14), (6)-->(9), (9)==(13), (13)==(9), (2)==(6), (6)==(2) 85 │ │ │ │ ├── inner-join (lookup supplier@s_nk) 86 │ │ │ │ │ ├── save-table-name: q11_lookup_join_7 87 │ │ │ │ │ ├── columns: s_suppkey:6(int!null) s_nationkey:9(int!null) n_nationkey:13(int!null) n_name:14(char!null) 88 │ │ │ │ │ ├── key columns: [13] = [9] 89 │ │ │ │ │ ├── stats: [rows=400, distinct(6)=399.934613, null(6)=0, distinct(9)=1, null(9)=0, distinct(13)=1, null(13)=0, distinct(14)=1, null(14)=0] 90 │ │ │ │ │ ├── key: (6) 91 │ │ │ │ │ ├── fd: ()-->(14), (6)-->(9), (9)==(13), (13)==(9) 92 │ │ │ │ │ ├── select 93 │ │ │ │ │ │ ├── save-table-name: q11_select_8 94 │ │ │ │ │ │ ├── columns: n_nationkey:13(int!null) n_name:14(char!null) 95 │ │ │ │ │ │ ├── stats: [rows=1, distinct(13)=1, null(13)=0, distinct(14)=1, null(14)=0] 96 │ │ │ │ │ │ ├── key: (13) 97 │ │ │ │ │ │ ├── fd: ()-->(14) 98 │ │ │ │ │ │ ├── scan nation 99 │ │ │ │ │ │ │ ├── save-table-name: q11_scan_9 100 │ │ │ │ │ │ │ ├── columns: n_nationkey:13(int!null) n_name:14(char!null) 101 │ │ │ │ │ │ │ ├── stats: [rows=25, distinct(13)=25, null(13)=0, distinct(14)=25, null(14)=0] 102 │ │ │ │ │ │ │ │ histogram(13)= 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 103 │ │ │ │ │ │ │ │ <--- 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 104 │ │ │ │ │ │ │ ├── key: (13) 105 │ │ │ │ │ │ │ └── fd: (13)-->(14) 106 │ │ │ │ │ │ └── filters 107 │ │ │ │ │ │ └── n_name:14 = 'GERMANY' [type=bool, outer=(14), constraints=(/14: [/'GERMANY' - /'GERMANY']; tight), fd=()-->(14)] 108 │ │ │ │ │ └── filters (true) 109 │ │ │ │ └── filters (true) 110 │ │ │ └── filters (true) 111 │ │ └── projections 112 │ │ └── ps_supplycost:4 * ps_availqty:3::FLOAT8 [as=column17:17, type=float, outer=(3,4)] 113 │ └── aggregations 114 │ └── sum [as=sum:18, type=float, outer=(17)] 115 │ └── column17:17 [type=float] 116 └── filters 117 └── gt [type=bool, outer=(18), subquery, constraints=(/18: (/NULL - ])] 118 ├── sum:18 [type=float] 119 └── subquery [type=float] 120 └── project 121 ├── save-table-name: q11_project_10 122 ├── columns: "?column?":37(float) 123 ├── cardinality: [1 - 1] 124 ├── stats: [rows=1, distinct(37)=1, null(37)=0] 125 ├── key: () 126 ├── fd: ()-->(37) 127 ├── scalar-group-by 128 │ ├── save-table-name: q11_scalar_group_by_11 129 │ ├── columns: sum:36(float) 130 │ ├── cardinality: [1 - 1] 131 │ ├── stats: [rows=1, distinct(36)=1, null(36)=0] 132 │ ├── key: () 133 │ ├── fd: ()-->(36) 134 │ ├── project 135 │ │ ├── save-table-name: q11_project_12 136 │ │ ├── columns: column35:35(float!null) 137 │ │ ├── stats: [rows=32258.0645, distinct(35)=31617.9161, null(35)=0] 138 │ │ ├── inner-join (lookup partsupp) 139 │ │ │ ├── save-table-name: q11_lookup_join_13 140 │ │ │ ├── columns: ps_suppkey:20(int!null) ps_availqty:21(int!null) ps_supplycost:22(float!null) s_suppkey:24(int!null) s_nationkey:27(int!null) n_nationkey:31(int!null) n_name:32(char!null) 141 │ │ │ ├── key columns: [19 20] = [19 20] 142 │ │ │ ├── lookup columns are key 143 │ │ │ ├── stats: [rows=32258.0645, distinct(20)=399.934613, null(20)=0, distinct(21)=9536.12259, null(21)=0, distinct(22)=27589.3232, null(22)=0, distinct(24)=399.934613, null(24)=0, distinct(27)=1, null(27)=0, distinct(31)=1, null(31)=0, distinct(32)=1, null(32)=0, distinct(21,22)=31617.9161, null(21,22)=0] 144 │ │ │ ├── fd: ()-->(32), (24)-->(27), (27)==(31), (31)==(27), (20)==(24), (24)==(20) 145 │ │ │ ├── inner-join (lookup partsupp@ps_sk) 146 │ │ │ │ ├── save-table-name: q11_lookup_join_14 147 │ │ │ │ ├── columns: ps_partkey:19(int!null) ps_suppkey:20(int!null) s_suppkey:24(int!null) s_nationkey:27(int!null) n_nationkey:31(int!null) n_name:32(char!null) 148 │ │ │ │ ├── key columns: [24] = [20] 149 │ │ │ │ ├── stats: [rows=32258.0645, distinct(19)=29783.4869, null(19)=0, distinct(20)=399.934613, null(20)=0, distinct(24)=399.934613, null(24)=0, distinct(27)=1, null(27)=0, distinct(31)=1, null(31)=0, distinct(32)=1, null(32)=0] 150 │ │ │ │ ├── key: (19,24) 151 │ │ │ │ ├── fd: ()-->(32), (24)-->(27), (27)==(31), (31)==(27), (20)==(24), (24)==(20) 152 │ │ │ │ ├── inner-join (lookup supplier@s_nk) 153 │ │ │ │ │ ├── save-table-name: q11_lookup_join_15 154 │ │ │ │ │ ├── columns: s_suppkey:24(int!null) s_nationkey:27(int!null) n_nationkey:31(int!null) n_name:32(char!null) 155 │ │ │ │ │ ├── key columns: [31] = [27] 156 │ │ │ │ │ ├── stats: [rows=400, distinct(24)=399.934613, null(24)=0, distinct(27)=1, null(27)=0, distinct(31)=1, null(31)=0, distinct(32)=1, null(32)=0] 157 │ │ │ │ │ ├── key: (24) 158 │ │ │ │ │ ├── fd: ()-->(32), (24)-->(27), (27)==(31), (31)==(27) 159 │ │ │ │ │ ├── select 160 │ │ │ │ │ │ ├── save-table-name: q11_select_16 161 │ │ │ │ │ │ ├── columns: n_nationkey:31(int!null) n_name:32(char!null) 162 │ │ │ │ │ │ ├── stats: [rows=1, distinct(31)=1, null(31)=0, distinct(32)=1, null(32)=0] 163 │ │ │ │ │ │ ├── key: (31) 164 │ │ │ │ │ │ ├── fd: ()-->(32) 165 │ │ │ │ │ │ ├── scan nation 166 │ │ │ │ │ │ │ ├── save-table-name: q11_scan_17 167 │ │ │ │ │ │ │ ├── columns: n_nationkey:31(int!null) n_name:32(char!null) 168 │ │ │ │ │ │ │ ├── stats: [rows=25, distinct(31)=25, null(31)=0, distinct(32)=25, null(32)=0] 169 │ │ │ │ │ │ │ │ histogram(31)= 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 170 │ │ │ │ │ │ │ │ <--- 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 171 │ │ │ │ │ │ │ ├── key: (31) 172 │ │ │ │ │ │ │ └── fd: (31)-->(32) 173 │ │ │ │ │ │ └── filters 174 │ │ │ │ │ │ └── n_name:32 = 'GERMANY' [type=bool, outer=(32), constraints=(/32: [/'GERMANY' - /'GERMANY']; tight), fd=()-->(32)] 175 │ │ │ │ │ └── filters (true) 176 │ │ │ │ └── filters (true) 177 │ │ │ └── filters (true) 178 │ │ └── projections 179 │ │ └── ps_supplycost:22 * ps_availqty:21::FLOAT8 [as=column35:35, type=float, outer=(21,22)] 180 │ └── aggregations 181 │ └── sum [as=sum:36, type=float, outer=(35)] 182 │ └── column35:35 [type=float] 183 └── projections 184 └── sum:36 * 0.0001 [as="?column?":37, type=float, outer=(36)] 185 186 stats table=q11_sort_1 187 ---- 188 column_names row_count distinct_count null_count 189 {ps_partkey} 1048 1048 0 190 {value} 1048 1048 0 191 ~~~~ 192 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 193 {ps_partkey} 9928.00 9.47 <== 9928.00 9.47 <== 0.00 1.00 194 {value} 9928.00 9.47 <== 9928.00 9.47 <== 0.00 1.00 195 196 stats table=q11_select_2 197 ---- 198 column_names row_count distinct_count null_count 199 {ps_partkey} 1048 1048 0 200 {sum} 1048 1048 0 201 ~~~~ 202 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 203 {ps_partkey} 9928.00 9.47 <== 9928.00 9.47 <== 0.00 1.00 204 {sum} 9928.00 9.47 <== 9928.00 9.47 <== 0.00 1.00 205 206 stats table=q11_group_by_3 207 ---- 208 column_names row_count distinct_count null_count 209 {ps_partkey} 29818 29669 0 210 {sum} 29818 29969 0 211 ~~~~ 212 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 213 {ps_partkey} 29783.00 1.00 29783.00 1.00 0.00 1.00 214 {sum} 29783.00 1.00 29783.00 1.01 0.00 1.00 215 216 stats table=q11_project_4 217 ---- 218 column_names row_count distinct_count null_count 219 {column17} 31680 31888 0 220 {ps_partkey} 31680 29669 0 221 ~~~~ 222 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 223 {column17} 32258.00 1.02 31618.00 1.01 0.00 1.00 224 {ps_partkey} 32258.00 1.02 29783.00 1.00 0.00 1.00 225 226 stats table=q11_lookup_join_5 227 ---- 228 column_names row_count distinct_count null_count 229 {n_name} 31680 1 0 230 {n_nationkey} 31680 1 0 231 {ps_availqty} 31680 9556 0 232 {ps_partkey} 31680 29669 0 233 {ps_suppkey} 31680 396 0 234 {ps_supplycost} 31680 27350 0 235 {s_nationkey} 31680 1 0 236 {s_suppkey} 31680 396 0 237 ~~~~ 238 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 239 {n_name} 32258.00 1.02 1.00 1.00 0.00 1.00 240 {n_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 241 {ps_availqty} 32258.00 1.02 9536.00 1.00 0.00 1.00 242 {ps_partkey} 32258.00 1.02 29783.00 1.00 0.00 1.00 243 {ps_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 244 {ps_supplycost} 32258.00 1.02 27589.00 1.01 0.00 1.00 245 {s_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 246 {s_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 247 248 stats table=q11_lookup_join_6 249 ---- 250 column_names row_count distinct_count null_count 251 {n_name} 31680 1 0 252 {n_nationkey} 31680 1 0 253 {ps_partkey} 31680 29669 0 254 {ps_suppkey} 31680 396 0 255 {s_nationkey} 31680 1 0 256 {s_suppkey} 31680 396 0 257 ~~~~ 258 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 259 {n_name} 32258.00 1.02 1.00 1.00 0.00 1.00 260 {n_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 261 {ps_partkey} 32258.00 1.02 29783.00 1.00 0.00 1.00 262 {ps_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 263 {s_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 264 {s_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 265 266 stats table=q11_lookup_join_7 267 ---- 268 column_names row_count distinct_count null_count 269 {n_name} 396 1 0 270 {n_nationkey} 396 1 0 271 {s_nationkey} 396 1 0 272 {s_suppkey} 396 396 0 273 ~~~~ 274 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 275 {n_name} 400.00 1.01 1.00 1.00 0.00 1.00 276 {n_nationkey} 400.00 1.01 1.00 1.00 0.00 1.00 277 {s_nationkey} 400.00 1.01 1.00 1.00 0.00 1.00 278 {s_suppkey} 400.00 1.01 400.00 1.01 0.00 1.00 279 280 stats table=q11_select_8 281 ---- 282 column_names row_count distinct_count null_count 283 {n_name} 1 1 0 284 {n_nationkey} 1 1 0 285 ~~~~ 286 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 287 {n_name} 1.00 1.00 1.00 1.00 0.00 1.00 288 {n_nationkey} 1.00 1.00 1.00 1.00 0.00 1.00 289 290 stats table=q11_scan_9 291 ---- 292 column_names row_count distinct_count null_count 293 {n_name} 25 25 0 294 {n_nationkey} 25 25 0 295 ~~~~ 296 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 297 {n_name} 25.00 1.00 25.00 1.00 0.00 1.00 298 {n_nationkey} 25.00 1.00 25.00 1.00 0.00 1.00 299 300 stats table=q11_project_10 301 ---- 302 column_names row_count distinct_count null_count 303 {?column?} 1 1 0 304 ~~~~ 305 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 306 {?column?} 1.00 1.00 1.00 1.00 0.00 1.00 307 308 stats table=q11_scalar_group_by_11 309 ---- 310 column_names row_count distinct_count null_count 311 {sum} 1 1 0 312 ~~~~ 313 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 314 {sum} 1.00 1.00 1.00 1.00 0.00 1.00 315 316 stats table=q11_project_12 317 ---- 318 column_names row_count distinct_count null_count 319 {column35} 31680 31888 0 320 ~~~~ 321 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 322 {column35} 32258.00 1.02 31618.00 1.01 0.00 1.00 323 324 stats table=q11_lookup_join_13 325 ---- 326 column_names row_count distinct_count null_count 327 {n_name} 31680 1 0 328 {n_nationkey} 31680 1 0 329 {ps_availqty} 31680 9556 0 330 {ps_suppkey} 31680 396 0 331 {ps_supplycost} 31680 27350 0 332 {s_nationkey} 31680 1 0 333 {s_suppkey} 31680 396 0 334 ~~~~ 335 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 336 {n_name} 32258.00 1.02 1.00 1.00 0.00 1.00 337 {n_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 338 {ps_availqty} 32258.00 1.02 9536.00 1.00 0.00 1.00 339 {ps_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 340 {ps_supplycost} 32258.00 1.02 27589.00 1.01 0.00 1.00 341 {s_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 342 {s_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 343 344 stats table=q11_lookup_join_14 345 ---- 346 column_names row_count distinct_count null_count 347 {n_name} 31680 1 0 348 {n_nationkey} 31680 1 0 349 {ps_partkey} 31680 29669 0 350 {ps_suppkey} 31680 396 0 351 {s_nationkey} 31680 1 0 352 {s_suppkey} 31680 396 0 353 ~~~~ 354 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 355 {n_name} 32258.00 1.02 1.00 1.00 0.00 1.00 356 {n_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 357 {ps_partkey} 32258.00 1.02 29783.00 1.00 0.00 1.00 358 {ps_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 359 {s_nationkey} 32258.00 1.02 1.00 1.00 0.00 1.00 360 {s_suppkey} 32258.00 1.02 400.00 1.01 0.00 1.00 361 362 stats table=q11_lookup_join_15 363 ---- 364 column_names row_count distinct_count null_count 365 {n_name} 396 1 0 366 {n_nationkey} 396 1 0 367 {s_nationkey} 396 1 0 368 {s_suppkey} 396 396 0 369 ~~~~ 370 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 371 {n_name} 400.00 1.01 1.00 1.00 0.00 1.00 372 {n_nationkey} 400.00 1.01 1.00 1.00 0.00 1.00 373 {s_nationkey} 400.00 1.01 1.00 1.00 0.00 1.00 374 {s_suppkey} 400.00 1.01 400.00 1.01 0.00 1.00 375 376 stats table=q11_select_16 377 ---- 378 column_names row_count distinct_count null_count 379 {n_name} 1 1 0 380 {n_nationkey} 1 1 0 381 ~~~~ 382 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 383 {n_name} 1.00 1.00 1.00 1.00 0.00 1.00 384 {n_nationkey} 1.00 1.00 1.00 1.00 0.00 1.00 385 386 stats table=q11_scan_17 387 ---- 388 column_names row_count distinct_count null_count 389 {n_name} 25 25 0 390 {n_nationkey} 25 25 0 391 ~~~~ 392 column_names row_count_est row_count_err distinct_count_est distinct_count_err null_count_est null_count_err 393 {n_name} 25.00 1.00 25.00 1.00 0.00 1.00 394 {n_nationkey} 25.00 1.00 25.00 1.00 0.00 1.00