github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/testutils/opttester/testfixtures/tpcc_stats_w10 (about) 1 # Stats for TPC-C with 10 warehouses, collected soon after the initial data 2 # import. 3 4 exec-ddl 5 ALTER TABLE customer INJECT STATISTICS '[ 6 { 7 "columns": [ 8 "c_w_id" 9 ], 10 "created_at": "2019-07-29 14:57:11.866104+00:00", 11 "distinct_count": 10, 12 "histo_buckets": [ 13 { 14 "distinct_range": 0, 15 "num_eq": 29910, 16 "num_range": 0, 17 "upper_bound": "0" 18 }, 19 { 20 "distinct_range": 0, 21 "num_eq": 31650, 22 "num_range": 0, 23 "upper_bound": "1" 24 }, 25 { 26 "distinct_range": 0, 27 "num_eq": 28530, 28 "num_range": 0, 29 "upper_bound": "2" 30 }, 31 { 32 "distinct_range": 0, 33 "num_eq": 28830, 34 "num_range": 0, 35 "upper_bound": "3" 36 }, 37 { 38 "distinct_range": 0, 39 "num_eq": 29190, 40 "num_range": 0, 41 "upper_bound": "4" 42 }, 43 { 44 "distinct_range": 0, 45 "num_eq": 29610, 46 "num_range": 0, 47 "upper_bound": "5" 48 }, 49 { 50 "distinct_range": 0, 51 "num_eq": 31950, 52 "num_range": 0, 53 "upper_bound": "6" 54 }, 55 { 56 "distinct_range": 0, 57 "num_eq": 30270, 58 "num_range": 0, 59 "upper_bound": "7" 60 }, 61 { 62 "distinct_range": 0, 63 "num_eq": 29430, 64 "num_range": 0, 65 "upper_bound": "8" 66 }, 67 { 68 "distinct_range": 0, 69 "num_eq": 30630, 70 "num_range": 0, 71 "upper_bound": "9" 72 } 73 ], 74 "histo_col_type": "INT8", 75 "name": "__auto__", 76 "null_count": 0, 77 "row_count": 300000 78 }, 79 { 80 "columns": [ 81 "c_id" 82 ], 83 "created_at": "2019-07-29 14:57:11.866104+00:00", 84 "distinct_count": 2999, 85 "histo_col_type": "", 86 "name": "__auto__", 87 "null_count": 0, 88 "row_count": 300000 89 }, 90 { 91 "columns": [ 92 "c_d_id" 93 ], 94 "created_at": "2019-07-29 14:57:11.866104+00:00", 95 "distinct_count": 10, 96 "histo_col_type": "", 97 "name": "__auto__", 98 "null_count": 0, 99 "row_count": 300000 100 }, 101 { 102 "columns": [ 103 "c_first" 104 ], 105 "created_at": "2019-07-29 14:57:11.866104+00:00", 106 "distinct_count": 558, 107 "histo_col_type": "", 108 "name": "__auto__", 109 "null_count": 0, 110 "row_count": 300000 111 }, 112 { 113 "columns": [ 114 "c_middle" 115 ], 116 "created_at": "2019-07-29 14:57:11.866104+00:00", 117 "distinct_count": 1, 118 "histo_col_type": "", 119 "name": "__auto__", 120 "null_count": 0, 121 "row_count": 300000 122 }, 123 { 124 "columns": [ 125 "c_last" 126 ], 127 "created_at": "2019-07-29 14:57:11.866104+00:00", 128 "distinct_count": 1000, 129 "histo_col_type": "", 130 "name": "__auto__", 131 "null_count": 0, 132 "row_count": 300000 133 }, 134 { 135 "columns": [ 136 "c_street_1" 137 ], 138 "created_at": "2019-07-29 14:57:11.866104+00:00", 139 "distinct_count": 770, 140 "histo_col_type": "", 141 "name": "__auto__", 142 "null_count": 0, 143 "row_count": 300000 144 }, 145 { 146 "columns": [ 147 "c_street_2" 148 ], 149 "created_at": "2019-07-29 14:57:11.866104+00:00", 150 "distinct_count": 880, 151 "histo_col_type": "", 152 "name": "__auto__", 153 "null_count": 0, 154 "row_count": 300000 155 }, 156 { 157 "columns": [ 158 "c_city" 159 ], 160 "created_at": "2019-07-29 14:57:11.866104+00:00", 161 "distinct_count": 965, 162 "histo_col_type": "", 163 "name": "__auto__", 164 "null_count": 0, 165 "row_count": 300000 166 }, 167 { 168 "columns": [ 169 "c_state" 170 ], 171 "created_at": "2019-07-29 14:57:11.866104+00:00", 172 "distinct_count": 26, 173 "histo_col_type": "", 174 "name": "__auto__", 175 "null_count": 0, 176 "row_count": 300000 177 }, 178 { 179 "columns": [ 180 "c_zip" 181 ], 182 "created_at": "2019-07-29 14:57:11.866104+00:00", 183 "distinct_count": 10, 184 "histo_col_type": "", 185 "name": "__auto__", 186 "null_count": 0, 187 "row_count": 300000 188 }, 189 { 190 "columns": [ 191 "c_phone" 192 ], 193 "created_at": "2019-07-29 14:57:11.866104+00:00", 194 "distinct_count": 10, 195 "histo_col_type": "", 196 "name": "__auto__", 197 "null_count": 0, 198 "row_count": 300000 199 }, 200 { 201 "columns": [ 202 "c_since" 203 ], 204 "created_at": "2019-07-29 14:57:11.866104+00:00", 205 "distinct_count": 1, 206 "histo_col_type": "", 207 "name": "__auto__", 208 "null_count": 0, 209 "row_count": 300000 210 }, 211 { 212 "columns": [ 213 "c_credit" 214 ], 215 "created_at": "2019-07-29 14:57:11.866104+00:00", 216 "distinct_count": 2, 217 "histo_col_type": "", 218 "name": "__auto__", 219 "null_count": 0, 220 "row_count": 300000 221 }, 222 { 223 "columns": [ 224 "c_credit_lim" 225 ], 226 "created_at": "2019-07-29 14:57:11.866104+00:00", 227 "distinct_count": 1, 228 "histo_col_type": "", 229 "name": "__auto__", 230 "null_count": 0, 231 "row_count": 300000 232 }, 233 { 234 "columns": [ 235 "c_discount" 236 ], 237 "created_at": "2019-07-29 14:57:11.866104+00:00", 238 "distinct_count": 5000, 239 "histo_col_type": "", 240 "name": "__auto__", 241 "null_count": 0, 242 "row_count": 300000 243 }, 244 { 245 "columns": [ 246 "c_balance" 247 ], 248 "created_at": "2019-07-29 14:57:11.866104+00:00", 249 "distinct_count": 1, 250 "histo_col_type": "", 251 "name": "__auto__", 252 "null_count": 0, 253 "row_count": 300000 254 }, 255 { 256 "columns": [ 257 "c_ytd_payment" 258 ], 259 "created_at": "2019-07-29 14:57:11.866104+00:00", 260 "distinct_count": 1, 261 "histo_col_type": "", 262 "name": "__auto__", 263 "null_count": 0, 264 "row_count": 300000 265 }, 266 { 267 "columns": [ 268 "c_payment_cnt" 269 ], 270 "created_at": "2019-07-29 14:57:11.866104+00:00", 271 "distinct_count": 1, 272 "histo_col_type": "", 273 "name": "__auto__", 274 "null_count": 0, 275 "row_count": 300000 276 }, 277 { 278 "columns": [ 279 "c_delivery_cnt" 280 ], 281 "created_at": "2019-07-29 14:57:11.866104+00:00", 282 "distinct_count": 1, 283 "histo_col_type": "", 284 "name": "__auto__", 285 "null_count": 0, 286 "row_count": 300000 287 }, 288 { 289 "columns": [ 290 "c_data" 291 ], 292 "created_at": "2019-07-29 14:57:11.866104+00:00", 293 "distinct_count": 16976, 294 "histo_col_type": "", 295 "name": "__auto__", 296 "null_count": 0, 297 "row_count": 300000 298 } 299 ]'; 300 ---- 301 302 exec-ddl 303 ALTER TABLE district INJECT STATISTICS '[ 304 { 305 "columns": [ 306 "d_w_id" 307 ], 308 "created_at": "2019-07-29 14:56:50.028642+00:00", 309 "distinct_count": 10, 310 "histo_buckets": [ 311 { 312 "distinct_range": 0, 313 "num_eq": 10, 314 "num_range": 0, 315 "upper_bound": "0" 316 }, 317 { 318 "distinct_range": 0, 319 "num_eq": 10, 320 "num_range": 0, 321 "upper_bound": "1" 322 }, 323 { 324 "distinct_range": 0, 325 "num_eq": 10, 326 "num_range": 0, 327 "upper_bound": "2" 328 }, 329 { 330 "distinct_range": 0, 331 "num_eq": 10, 332 "num_range": 0, 333 "upper_bound": "3" 334 }, 335 { 336 "distinct_range": 0, 337 "num_eq": 10, 338 "num_range": 0, 339 "upper_bound": "4" 340 }, 341 { 342 "distinct_range": 0, 343 "num_eq": 10, 344 "num_range": 0, 345 "upper_bound": "5" 346 }, 347 { 348 "distinct_range": 0, 349 "num_eq": 10, 350 "num_range": 0, 351 "upper_bound": "6" 352 }, 353 { 354 "distinct_range": 0, 355 "num_eq": 10, 356 "num_range": 0, 357 "upper_bound": "7" 358 }, 359 { 360 "distinct_range": 0, 361 "num_eq": 10, 362 "num_range": 0, 363 "upper_bound": "8" 364 }, 365 { 366 "distinct_range": 0, 367 "num_eq": 10, 368 "num_range": 0, 369 "upper_bound": "9" 370 } 371 ], 372 "histo_col_type": "INT8", 373 "name": "__auto__", 374 "null_count": 0, 375 "row_count": 100 376 }, 377 { 378 "columns": [ 379 "d_id" 380 ], 381 "created_at": "2019-07-29 14:56:50.028642+00:00", 382 "distinct_count": 10, 383 "histo_col_type": "", 384 "name": "__auto__", 385 "null_count": 0, 386 "row_count": 100 387 }, 388 { 389 "columns": [ 390 "d_name" 391 ], 392 "created_at": "2019-07-29 14:56:50.028642+00:00", 393 "distinct_count": 78, 394 "histo_col_type": "", 395 "name": "__auto__", 396 "null_count": 0, 397 "row_count": 100 398 }, 399 { 400 "columns": [ 401 "d_street_1" 402 ], 403 "created_at": "2019-07-29 14:56:50.028642+00:00", 404 "distinct_count": 91, 405 "histo_col_type": "", 406 "name": "__auto__", 407 "null_count": 0, 408 "row_count": 100 409 }, 410 { 411 "columns": [ 412 "d_street_2" 413 ], 414 "created_at": "2019-07-29 14:56:50.028642+00:00", 415 "distinct_count": 95, 416 "histo_col_type": "", 417 "name": "__auto__", 418 "null_count": 0, 419 "row_count": 100 420 }, 421 { 422 "columns": [ 423 "d_city" 424 ], 425 "created_at": "2019-07-29 14:56:50.028642+00:00", 426 "distinct_count": 94, 427 "histo_col_type": "", 428 "name": "__auto__", 429 "null_count": 0, 430 "row_count": 100 431 }, 432 { 433 "columns": [ 434 "d_state" 435 ], 436 "created_at": "2019-07-29 14:56:50.028642+00:00", 437 "distinct_count": 25, 438 "histo_col_type": "", 439 "name": "__auto__", 440 "null_count": 0, 441 "row_count": 100 442 }, 443 { 444 "columns": [ 445 "d_zip" 446 ], 447 "created_at": "2019-07-29 14:56:50.028642+00:00", 448 "distinct_count": 10, 449 "histo_col_type": "", 450 "name": "__auto__", 451 "null_count": 0, 452 "row_count": 100 453 }, 454 { 455 "columns": [ 456 "d_tax" 457 ], 458 "created_at": "2019-07-29 14:56:50.028642+00:00", 459 "distinct_count": 98, 460 "histo_col_type": "", 461 "name": "__auto__", 462 "null_count": 0, 463 "row_count": 100 464 }, 465 { 466 "columns": [ 467 "d_ytd" 468 ], 469 "created_at": "2019-07-29 14:56:50.028642+00:00", 470 "distinct_count": 1, 471 "histo_col_type": "", 472 "name": "__auto__", 473 "null_count": 0, 474 "row_count": 100 475 }, 476 { 477 "columns": [ 478 "d_next_o_id" 479 ], 480 "created_at": "2019-07-29 14:56:50.028642+00:00", 481 "distinct_count": 1, 482 "histo_col_type": "", 483 "name": "__auto__", 484 "null_count": 0, 485 "row_count": 100 486 }, 487 { 488 "columns": [ 489 "d_w_id", 490 "d_id" 491 ], 492 "created_at": "2019-07-29 14:56:50.028642+00:00", 493 "distinct_count": 100, 494 "histo_col_type": "", 495 "name": "__auto__", 496 "null_count": 0, 497 "row_count": 100 498 } 499 ]'; 500 ---- 501 502 exec-ddl 503 ALTER TABLE history INJECT STATISTICS '[ 504 { 505 "columns": [ 506 "h_w_id" 507 ], 508 "created_at": "2019-07-29 14:56:54.830587+00:00", 509 "distinct_count": 10, 510 "histo_buckets": [ 511 { 512 "distinct_range": 0, 513 "num_eq": 28410, 514 "num_range": 0, 515 "upper_bound": "0" 516 }, 517 { 518 "distinct_range": 0, 519 "num_eq": 29820, 520 "num_range": 0, 521 "upper_bound": "1" 522 }, 523 { 524 "distinct_range": 0, 525 "num_eq": 29280, 526 "num_range": 0, 527 "upper_bound": "2" 528 }, 529 { 530 "distinct_range": 0, 531 "num_eq": 31350, 532 "num_range": 0, 533 "upper_bound": "3" 534 }, 535 { 536 "distinct_range": 0, 537 "num_eq": 29370, 538 "num_range": 0, 539 "upper_bound": "4" 540 }, 541 { 542 "distinct_range": 0, 543 "num_eq": 30240, 544 "num_range": 0, 545 "upper_bound": "5" 546 }, 547 { 548 "distinct_range": 0, 549 "num_eq": 30270, 550 "num_range": 0, 551 "upper_bound": "6" 552 }, 553 { 554 "distinct_range": 0, 555 "num_eq": 30660, 556 "num_range": 0, 557 "upper_bound": "7" 558 }, 559 { 560 "distinct_range": 0, 561 "num_eq": 30450, 562 "num_range": 0, 563 "upper_bound": "8" 564 }, 565 { 566 "distinct_range": 0, 567 "num_eq": 30150, 568 "num_range": 0, 569 "upper_bound": "9" 570 } 571 ], 572 "histo_col_type": "INT8", 573 "name": "__auto__", 574 "null_count": 0, 575 "row_count": 300000 576 }, 577 { 578 "columns": [ 579 "h_c_w_id" 580 ], 581 "created_at": "2019-07-29 14:56:54.830587+00:00", 582 "distinct_count": 10, 583 "histo_buckets": [ 584 { 585 "distinct_range": 0, 586 "num_eq": 28410, 587 "num_range": 0, 588 "upper_bound": "0" 589 }, 590 { 591 "distinct_range": 0, 592 "num_eq": 29820, 593 "num_range": 0, 594 "upper_bound": "1" 595 }, 596 { 597 "distinct_range": 0, 598 "num_eq": 29280, 599 "num_range": 0, 600 "upper_bound": "2" 601 }, 602 { 603 "distinct_range": 0, 604 "num_eq": 31350, 605 "num_range": 0, 606 "upper_bound": "3" 607 }, 608 { 609 "distinct_range": 0, 610 "num_eq": 29370, 611 "num_range": 0, 612 "upper_bound": "4" 613 }, 614 { 615 "distinct_range": 0, 616 "num_eq": 30240, 617 "num_range": 0, 618 "upper_bound": "5" 619 }, 620 { 621 "distinct_range": 0, 622 "num_eq": 30270, 623 "num_range": 0, 624 "upper_bound": "6" 625 }, 626 { 627 "distinct_range": 0, 628 "num_eq": 30660, 629 "num_range": 0, 630 "upper_bound": "7" 631 }, 632 { 633 "distinct_range": 0, 634 "num_eq": 30450, 635 "num_range": 0, 636 "upper_bound": "8" 637 }, 638 { 639 "distinct_range": 0, 640 "num_eq": 30150, 641 "num_range": 0, 642 "upper_bound": "9" 643 } 644 ], 645 "histo_col_type": "INT8", 646 "name": "__auto__", 647 "null_count": 0, 648 "row_count": 300000 649 }, 650 { 651 "columns": [ 652 "rowid" 653 ], 654 "created_at": "2019-07-29 14:56:54.830587+00:00", 655 "distinct_count": 299387, 656 "histo_col_type": "", 657 "name": "__auto__", 658 "null_count": 0, 659 "row_count": 300000 660 }, 661 { 662 "columns": [ 663 "h_c_id" 664 ], 665 "created_at": "2019-07-29 14:56:54.830587+00:00", 666 "distinct_count": 2999, 667 "histo_col_type": "", 668 "name": "__auto__", 669 "null_count": 0, 670 "row_count": 300000 671 }, 672 { 673 "columns": [ 674 "h_c_d_id" 675 ], 676 "created_at": "2019-07-29 14:56:54.830587+00:00", 677 "distinct_count": 10, 678 "histo_col_type": "", 679 "name": "__auto__", 680 "null_count": 0, 681 "row_count": 300000 682 }, 683 { 684 "columns": [ 685 "h_d_id" 686 ], 687 "created_at": "2019-07-29 14:56:54.830587+00:00", 688 "distinct_count": 10, 689 "histo_col_type": "", 690 "name": "__auto__", 691 "null_count": 0, 692 "row_count": 300000 693 }, 694 { 695 "columns": [ 696 "h_date" 697 ], 698 "created_at": "2019-07-29 14:56:54.830587+00:00", 699 "distinct_count": 1, 700 "histo_col_type": "", 701 "name": "__auto__", 702 "null_count": 0, 703 "row_count": 300000 704 }, 705 { 706 "columns": [ 707 "h_amount" 708 ], 709 "created_at": "2019-07-29 14:56:54.830587+00:00", 710 "distinct_count": 1, 711 "histo_col_type": "", 712 "name": "__auto__", 713 "null_count": 0, 714 "row_count": 300000 715 }, 716 { 717 "columns": [ 718 "h_data" 719 ], 720 "created_at": "2019-07-29 14:56:54.830587+00:00", 721 "distinct_count": 806, 722 "histo_col_type": "", 723 "name": "__auto__", 724 "null_count": 0, 725 "row_count": 300000 726 }, 727 { 728 "columns": [ 729 "h_w_id", 730 "rowid" 731 ], 732 "created_at": "2019-07-29 14:56:54.830587+00:00", 733 "distinct_count": 300385, 734 "histo_col_type": "", 735 "name": "__auto__", 736 "null_count": 0, 737 "row_count": 300000 738 }, 739 { 740 "columns": [ 741 "h_c_w_id", 742 "h_c_d_id" 743 ], 744 "created_at": "2019-07-29 14:56:54.830587+00:00", 745 "distinct_count": 100, 746 "histo_col_type": "", 747 "name": "__auto__", 748 "null_count": 0, 749 "row_count": 300000 750 }, 751 { 752 "columns": [ 753 "h_c_w_id", 754 "h_c_d_id", 755 "h_c_id" 756 ], 757 "created_at": "2019-07-29 14:56:54.830587+00:00", 758 "distinct_count": 295745, 759 "histo_col_type": "", 760 "name": "__auto__", 761 "null_count": 0, 762 "row_count": 300000 763 }, 764 { 765 "columns": [ 766 "h_w_id", 767 "h_d_id" 768 ], 769 "created_at": "2019-07-29 14:56:54.830587+00:00", 770 "distinct_count": 100, 771 "histo_col_type": "", 772 "name": "__auto__", 773 "null_count": 0, 774 "row_count": 300000 775 } 776 ]'; 777 ---- 778 779 exec-ddl 780 ALTER TABLE item INJECT STATISTICS '[ 781 { 782 "columns": [ 783 "i_id" 784 ], 785 "created_at": "2019-07-29 14:57:03.349887+00:00", 786 "distinct_count": 99658, 787 "histo_buckets": [ 788 { 789 "distinct_range": 0, 790 "num_eq": 10, 791 "num_range": 0, 792 "upper_bound": "5" 793 }, 794 { 795 "distinct_range": 509.35264526769146, 796 "num_eq": 10, 797 "num_range": 490, 798 "upper_bound": "528" 799 }, 800 { 801 "distinct_range": 503.42468885589636, 802 "num_eq": 10, 803 "num_range": 490, 804 "upper_bound": "1036" 805 }, 806 { 807 "distinct_range": 488.1353271318339, 808 "num_eq": 10, 809 "num_range": 490, 810 "upper_bound": "1508" 811 }, 812 { 813 "distinct_range": 468.64756018004056, 814 "num_eq": 10, 815 "num_range": 490, 816 "upper_bound": "1939" 817 }, 818 { 819 "distinct_range": 487.6876558710101, 820 "num_eq": 10, 821 "num_range": 490, 822 "upper_bound": "2410" 823 }, 824 { 825 "distinct_range": 419.32887527285845, 826 "num_eq": 10, 827 "num_range": 490, 828 "upper_bound": "2756" 829 }, 830 { 831 "distinct_range": 494.6971485899354, 832 "num_eq": 10, 833 "num_range": 490, 834 "upper_bound": "3243" 835 }, 836 { 837 "distinct_range": 480.3433358153391, 838 "num_eq": 10, 839 "num_range": 490, 840 "upper_bound": "3698" 841 }, 842 { 843 "distinct_range": 516.8883706487006, 844 "num_eq": 10, 845 "num_range": 490, 846 "upper_bound": "4241" 847 }, 848 { 849 "distinct_range": 453.8663603554201, 850 "num_eq": 10, 851 "num_range": 490, 852 "upper_bound": "4644" 853 }, 854 { 855 "distinct_range": 492.5413193501455, 856 "num_eq": 10, 857 "num_range": 490, 858 "upper_bound": "5126" 859 }, 860 { 861 "distinct_range": 461.94528133198094, 862 "num_eq": 10, 863 "num_range": 490, 864 "upper_bound": "5544" 865 }, 866 { 867 "distinct_range": 491.67028018552986, 868 "num_eq": 10, 869 "num_range": 490, 870 "upper_bound": "6024" 871 }, 872 { 873 "distinct_range": 444.81349363601134, 874 "num_eq": 10, 875 "num_range": 490, 876 "upper_bound": "6411" 877 }, 878 { 879 "distinct_range": 500.9835495652874, 880 "num_eq": 10, 881 "num_range": 490, 882 "upper_bound": "6913" 883 }, 884 { 885 "distinct_range": 485.4295800369194, 886 "num_eq": 10, 887 "num_range": 490, 888 "upper_bound": "7379" 889 }, 890 { 891 "distinct_range": 471.65167632664685, 892 "num_eq": 10, 893 "num_range": 490, 894 "upper_bound": "7816" 895 }, 896 { 897 "distinct_range": 466.1015741382656, 898 "num_eq": 10, 899 "num_range": 490, 900 "upper_bound": "8242" 901 }, 902 { 903 "distinct_range": 516.1529295038566, 904 "num_eq": 10, 905 "num_range": 490, 906 "upper_bound": "8783" 907 }, 908 { 909 "distinct_range": 513.5476103045908, 910 "num_eq": 10, 911 "num_range": 490, 912 "upper_bound": "9317" 913 }, 914 { 915 "distinct_range": 475.08786714482216, 916 "num_eq": 10, 917 "num_range": 490, 918 "upper_bound": "9761" 919 }, 920 { 921 "distinct_range": 484.5170440559773, 922 "num_eq": 10, 923 "num_range": 490, 924 "upper_bound": "10225" 925 }, 926 { 927 "distinct_range": 452.75994739416785, 928 "num_eq": 10, 929 "num_range": 490, 930 "upper_bound": "10626" 931 }, 932 { 933 "distinct_range": 482.6757724894591, 934 "num_eq": 10, 935 "num_range": 490, 936 "upper_bound": "11086" 937 }, 938 { 939 "distinct_range": 542.7897719496233, 940 "num_eq": 10, 941 "num_range": 490, 942 "upper_bound": "11707" 943 }, 944 { 945 "distinct_range": 495.5508795971156, 946 "num_eq": 10, 947 "num_range": 490, 948 "upper_bound": "12196" 949 }, 950 { 951 "distinct_range": 521.9284999145146, 952 "num_eq": 10, 953 "num_range": 490, 954 "upper_bound": "12753" 955 }, 956 { 957 "distinct_range": 491.67028018552986, 958 "num_eq": 10, 959 "num_range": 490, 960 "upper_bound": "13233" 961 }, 962 { 963 "distinct_range": 531.4725860263484, 964 "num_eq": 10, 965 "num_range": 490, 966 "upper_bound": "13818" 967 }, 968 { 969 "distinct_range": 503.8275861457508, 970 "num_eq": 10, 971 "num_range": 490, 972 "upper_bound": "14327" 973 }, 974 { 975 "distinct_range": 502.61551883200974, 976 "num_eq": 10, 977 "num_range": 490, 978 "upper_bound": "14833" 979 }, 980 { 981 "distinct_range": 469.15208145080874, 982 "num_eq": 10, 983 "num_range": 490, 984 "upper_bound": "15265" 985 }, 986 { 987 "distinct_range": 431.57159107829415, 988 "num_eq": 10, 989 "num_range": 490, 990 "upper_bound": "15630" 991 }, 992 { 993 "distinct_range": 526.7867750035747, 994 "num_eq": 10, 995 "num_range": 490, 996 "upper_bound": "16201" 997 }, 998 { 999 "distinct_range": 492.9749627984456, 1000 "num_eq": 10, 1001 "num_range": 490, 1002 "upper_bound": "16684" 1003 }, 1004 { 1005 "distinct_range": 503.42468885589636, 1006 "num_eq": 10, 1007 "num_range": 490, 1008 "upper_bound": "17192" 1009 }, 1010 { 1011 "distinct_range": 528.1427815756143, 1012 "num_eq": 10, 1013 "num_range": 490, 1014 "upper_bound": "17767" 1015 }, 1016 { 1017 "distinct_range": 484.0587596250974, 1018 "num_eq": 10, 1019 "num_range": 490, 1020 "upper_bound": "18230" 1021 }, 1022 { 1023 "distinct_range": 522.6334472055559, 1024 "num_eq": 10, 1025 "num_range": 490, 1026 "upper_bound": "18789" 1027 }, 1028 { 1029 "distinct_range": 537.5716680843786, 1030 "num_eq": 10, 1031 "num_range": 490, 1032 "upper_bound": "19393" 1033 }, 1034 { 1035 "distinct_range": 495.1246233956038, 1036 "num_eq": 10, 1037 "num_range": 490, 1038 "upper_bound": "19881" 1039 }, 1040 { 1041 "distinct_range": 472.6408984471385, 1042 "num_eq": 10, 1043 "num_range": 490, 1044 "upper_bound": "20320" 1045 }, 1046 { 1047 "distinct_range": 535.3583980442121, 1048 "num_eq": 10, 1049 "num_range": 490, 1050 "upper_bound": "20917" 1051 }, 1052 { 1053 "distinct_range": 495.1246233956038, 1054 "num_eq": 10, 1055 "num_range": 490, 1056 "upper_bound": "21405" 1057 }, 1058 { 1059 "distinct_range": 479.40061458778047, 1060 "num_eq": 10, 1061 "num_range": 490, 1062 "upper_bound": "21858" 1063 }, 1064 { 1065 "distinct_range": 427.1519443087804, 1066 "num_eq": 10, 1067 "num_range": 490, 1068 "upper_bound": "22216" 1069 }, 1070 { 1071 "distinct_range": 509.73921549297336, 1072 "num_eq": 10, 1073 "num_range": 490, 1074 "upper_bound": "22740" 1075 }, 1076 { 1077 "distinct_range": 499.3331618512828, 1078 "num_eq": 10, 1079 "num_range": 490, 1080 "upper_bound": "23238" 1081 }, 1082 { 1083 "distinct_range": 521.9284999145146, 1084 "num_eq": 10, 1085 "num_range": 490, 1086 "upper_bound": "23795" 1087 }, 1088 { 1089 "distinct_range": 499.3331618512828, 1090 "num_eq": 10, 1091 "num_range": 490, 1092 "upper_bound": "24293" 1093 }, 1094 { 1095 "distinct_range": 497.24381761114597, 1096 "num_eq": 10, 1097 "num_range": 490, 1098 "upper_bound": "24786" 1099 }, 1100 { 1101 "distinct_range": 512.4159181036472, 1102 "num_eq": 10, 1103 "num_range": 490, 1104 "upper_bound": "25317" 1105 }, 1106 { 1107 "distinct_range": 473.6241323347582, 1108 "num_eq": 10, 1109 "num_range": 490, 1110 "upper_bound": "25758" 1111 }, 1112 { 1113 "distinct_range": 504.63002778131096, 1114 "num_eq": 10, 1115 "num_range": 490, 1116 "upper_bound": "26269" 1117 }, 1118 { 1119 "distinct_range": 477.97594157249034, 1120 "num_eq": 10, 1121 "num_range": 490, 1122 "upper_bound": "26719" 1123 }, 1124 { 1125 "distinct_range": 499.3331618512828, 1126 "num_eq": 10, 1127 "num_range": 490, 1128 "upper_bound": "27217" 1129 }, 1130 { 1131 "distinct_range": 467.1246715879139, 1132 "num_eq": 10, 1133 "num_range": 490, 1134 "upper_bound": "27645" 1135 }, 1136 { 1137 "distinct_range": 495.97592217596167, 1138 "num_eq": 10, 1139 "num_range": 490, 1140 "upper_bound": "28135" 1141 }, 1142 { 1143 "distinct_range": 500.1606766636571, 1144 "num_eq": 10, 1145 "num_range": 490, 1146 "upper_bound": "28635" 1147 }, 1148 { 1149 "distinct_range": 536.3116773647997, 1150 "num_eq": 10, 1151 "num_range": 490, 1152 "upper_bound": "29235" 1153 }, 1154 { 1155 "distinct_range": 526.1035068937593, 1156 "num_eq": 10, 1157 "num_range": 490, 1158 "upper_bound": "29804" 1159 }, 1160 { 1161 "distinct_range": 511.2749949339112, 1162 "num_eq": 10, 1163 "num_range": 490, 1164 "upper_bound": "30332" 1165 }, 1166 { 1167 "distinct_range": 480.3433358153391, 1168 "num_eq": 10, 1169 "num_range": 490, 1170 "upper_bound": "30787" 1171 }, 1172 { 1173 "distinct_range": 529.4849228506725, 1174 "num_eq": 10, 1175 "num_range": 490, 1176 "upper_bound": "31366" 1177 }, 1178 { 1179 "distinct_range": 514.2969967303736, 1180 "num_eq": 10, 1181 "num_range": 490, 1182 "upper_bound": "31902" 1183 }, 1184 { 1185 "distinct_range": 538.5084747325484, 1186 "num_eq": 10, 1187 "num_range": 490, 1188 "upper_bound": "32509" 1189 }, 1190 { 1191 "distinct_range": 501.3932569997425, 1192 "num_eq": 10, 1193 "num_range": 490, 1194 "upper_bound": "33012" 1195 }, 1196 { 1197 "distinct_range": 500.1606766636571, 1198 "num_eq": 10, 1199 "num_range": 490, 1200 "upper_bound": "33512" 1201 }, 1202 { 1203 "distinct_range": 451.0870506585421, 1204 "num_eq": 10, 1205 "num_range": 490, 1206 "upper_bound": "33910" 1207 }, 1208 { 1209 "distinct_range": 529.4849228506725, 1210 "num_eq": 10, 1211 "num_range": 490, 1212 "upper_bound": "34489" 1213 }, 1214 { 1215 "distinct_range": 468.64756018004056, 1216 "num_eq": 10, 1217 "num_range": 490, 1218 "upper_bound": "34920" 1219 }, 1220 { 1221 "distinct_range": 513.1713985500509, 1222 "num_eq": 10, 1223 "num_range": 490, 1224 "upper_bound": "35453" 1225 }, 1226 { 1227 "distinct_range": 541.5815129088834, 1228 "num_eq": 10, 1229 "num_range": 490, 1230 "upper_bound": "36070" 1231 }, 1232 { 1233 "distinct_range": 567.8935461665706, 1234 "num_eq": 10, 1235 "num_range": 490, 1236 "upper_bound": "36784" 1237 }, 1238 { 1239 "distinct_range": 494.6971485899354, 1240 "num_eq": 10, 1241 "num_range": 490, 1242 "upper_bound": "37271" 1243 }, 1244 { 1245 "distinct_range": 491.2328741156806, 1246 "num_eq": 10, 1247 "num_range": 490, 1248 "upper_bound": "37750" 1249 }, 1250 { 1251 "distinct_range": 494.26845017305845, 1252 "num_eq": 10, 1253 "num_range": 490, 1254 "upper_bound": "38236" 1255 }, 1256 { 1257 "distinct_range": 505.0295810591341, 1258 "num_eq": 10, 1259 "num_range": 490, 1260 "upper_bound": "38748" 1261 }, 1262 { 1263 "distinct_range": 497.24381761114597, 1264 "num_eq": 10, 1265 "num_range": 490, 1266 "upper_bound": "39241" 1267 }, 1268 { 1269 "distinct_range": 529.8183158973062, 1270 "num_eq": 10, 1271 "num_range": 490, 1272 "upper_bound": "39821" 1273 }, 1274 { 1275 "distinct_range": 491.67028018552986, 1276 "num_eq": 10, 1277 "num_range": 490, 1278 "upper_bound": "40301" 1279 }, 1280 { 1281 "distinct_range": 521.2198424157408, 1282 "num_eq": 10, 1283 "num_range": 490, 1284 "upper_bound": "40856" 1285 }, 1286 { 1287 "distinct_range": 557.4880411244509, 1288 "num_eq": 10, 1289 "num_range": 490, 1290 "upper_bound": "41529" 1291 }, 1292 { 1293 "distinct_range": 495.5508795971156, 1294 "num_eq": 10, 1295 "num_range": 490, 1296 "upper_bound": "42018" 1297 }, 1298 { 1299 "distinct_range": 485.8838428314034, 1300 "num_eq": 10, 1301 "num_range": 490, 1302 "upper_bound": "42485" 1303 }, 1304 { 1305 "distinct_range": 454.41693487400806, 1306 "num_eq": 10, 1307 "num_range": 490, 1308 "upper_bound": "42889" 1309 }, 1310 { 1311 "distinct_range": 512.7941691465979, 1312 "num_eq": 10, 1313 "num_range": 490, 1314 "upper_bound": "43421" 1315 }, 1316 { 1317 "distinct_range": 505.82537469697223, 1318 "num_eq": 10, 1319 "num_range": 490, 1320 "upper_bound": "43935" 1321 }, 1322 { 1323 "distinct_range": 461.94528133198094, 1324 "num_eq": 10, 1325 "num_range": 490, 1326 "upper_bound": "44353" 1327 }, 1328 { 1329 "distinct_range": 529.4849228506725, 1330 "num_eq": 10, 1331 "num_range": 490, 1332 "upper_bound": "44932" 1333 }, 1334 { 1335 "distinct_range": 477.0190284219111, 1336 "num_eq": 10, 1337 "num_range": 490, 1338 "upper_bound": "45380" 1339 }, 1340 { 1341 "distinct_range": 470.1565018222196, 1342 "num_eq": 10, 1343 "num_range": 490, 1344 "upper_bound": "45814" 1345 }, 1346 { 1347 "distinct_range": 510.8926170287179, 1348 "num_eq": 10, 1349 "num_range": 490, 1350 "upper_bound": "46341" 1351 }, 1352 { 1353 "distinct_range": 488.1353271318339, 1354 "num_eq": 10, 1355 "num_range": 490, 1356 "upper_bound": "46813" 1357 }, 1358 { 1359 "distinct_range": 510.8926170287179, 1360 "num_eq": 10, 1361 "num_range": 490, 1362 "upper_bound": "47340" 1363 }, 1364 { 1365 "distinct_range": 535.0390445128946, 1366 "num_eq": 10, 1367 "num_range": 490, 1368 "upper_bound": "47936" 1369 }, 1370 { 1371 "distinct_range": 440.70337078894255, 1372 "num_eq": 10, 1373 "num_range": 490, 1374 "upper_bound": "48316" 1375 }, 1376 { 1377 "distinct_range": 485.8838428314034, 1378 "num_eq": 10, 1379 "num_range": 490, 1380 "upper_bound": "48783" 1381 }, 1382 { 1383 "distinct_range": 478.92714173849447, 1384 "num_eq": 10, 1385 "num_range": 490, 1386 "upper_bound": "49235" 1387 }, 1388 { 1389 "distinct_range": 516.1529295038566, 1390 "num_eq": 10, 1391 "num_range": 490, 1392 "upper_bound": "49776" 1393 }, 1394 { 1395 "distinct_range": 507.79573770067157, 1396 "num_eq": 10, 1397 "num_range": 490, 1398 "upper_bound": "50295" 1399 }, 1400 { 1401 "distinct_range": 513.5476103045908, 1402 "num_eq": 10, 1403 "num_range": 490, 1404 "upper_bound": "50829" 1405 }, 1406 { 1407 "distinct_range": 500.9835495652874, 1408 "num_eq": 10, 1409 "num_range": 490, 1410 "upper_bound": "51331" 1411 }, 1412 { 1413 "distinct_range": 501.3932569997425, 1414 "num_eq": 10, 1415 "num_range": 490, 1416 "upper_bound": "51834" 1417 }, 1418 { 1419 "distinct_range": 486.33677627644795, 1420 "num_eq": 10, 1421 "num_range": 490, 1422 "upper_bound": "52302" 1423 }, 1424 { 1425 "distinct_range": 509.73921549297336, 1426 "num_eq": 10, 1427 "num_range": 490, 1428 "upper_bound": "52826" 1429 }, 1430 { 1431 "distinct_range": 512.4159181036472, 1432 "num_eq": 10, 1433 "num_range": 490, 1434 "upper_bound": "53357" 1435 }, 1436 { 1437 "distinct_range": 446.54657831460594, 1438 "num_eq": 10, 1439 "num_range": 490, 1440 "upper_bound": "53747" 1441 }, 1442 { 1443 "distinct_range": 477.0190284219111, 1444 "num_eq": 10, 1445 "num_range": 490, 1446 "upper_bound": "54195" 1447 }, 1448 { 1449 "distinct_range": 525.4166935493558, 1450 "num_eq": 10, 1451 "num_range": 490, 1452 "upper_bound": "54762" 1453 }, 1454 { 1455 "distinct_range": 542.7897719496233, 1456 "num_eq": 10, 1457 "num_range": 490, 1458 "upper_bound": "55383" 1459 }, 1460 { 1461 "distinct_range": 460.3598077805104, 1462 "num_eq": 10, 1463 "num_range": 490, 1464 "upper_bound": "55798" 1465 }, 1466 { 1467 "distinct_range": 509.35264526769146, 1468 "num_eq": 10, 1469 "num_range": 490, 1470 "upper_bound": "56321" 1471 }, 1472 { 1473 "distinct_range": 447.69267128766455, 1474 "num_eq": 10, 1475 "num_range": 490, 1476 "upper_bound": "56713" 1477 }, 1478 { 1479 "distinct_range": 490.354262916728, 1480 "num_eq": 10, 1481 "num_range": 490, 1482 "upper_bound": "57190" 1483 }, 1484 { 1485 "distinct_range": 480.3433358153391, 1486 "num_eq": 10, 1487 "num_range": 490, 1488 "upper_bound": "57645" 1489 }, 1490 { 1491 "distinct_range": 518.3475373127319, 1492 "num_eq": 10, 1493 "num_range": 490, 1494 "upper_bound": "58192" 1495 }, 1496 { 1497 "distinct_range": 502.61551883200974, 1498 "num_eq": 10, 1499 "num_range": 490, 1500 "upper_bound": "58698" 1501 }, 1502 { 1503 "distinct_range": 428.4252839541942, 1504 "num_eq": 10, 1505 "num_range": 490, 1506 "upper_bound": "59058" 1507 }, 1508 { 1509 "distinct_range": 520.1498372358991, 1510 "num_eq": 10, 1511 "num_range": 490, 1512 "upper_bound": "59610" 1513 }, 1514 { 1515 "distinct_range": 484.97398231432663, 1516 "num_eq": 10, 1517 "num_range": 490, 1518 "upper_bound": "60075" 1519 }, 1520 { 1521 "distinct_range": 475.5728397905521, 1522 "num_eq": 10, 1523 "num_range": 490, 1524 "upper_bound": "60520" 1525 }, 1526 { 1527 "distinct_range": 509.35264526769146, 1528 "num_eq": 10, 1529 "num_range": 490, 1530 "upper_bound": "61043" 1531 }, 1532 { 1533 "distinct_range": 459.82800297875747, 1534 "num_eq": 10, 1535 "num_range": 490, 1536 "upper_bound": "61457" 1537 }, 1538 { 1539 "distinct_range": 499.7475018482512, 1540 "num_eq": 10, 1541 "num_range": 490, 1542 "upper_bound": "61956" 1543 }, 1544 { 1545 "distinct_range": 503.8275861457508, 1546 "num_eq": 10, 1547 "num_range": 490, 1548 "upper_bound": "62465" 1549 }, 1550 { 1551 "distinct_range": 554.2541360077583, 1552 "num_eq": 10, 1553 "num_range": 490, 1554 "upper_bound": "63126" 1555 }, 1556 { 1557 "distinct_range": 486.33677627644795, 1558 "num_eq": 10, 1559 "num_range": 490, 1560 "upper_bound": "63594" 1561 }, 1562 { 1563 "distinct_range": 492.9749627984456, 1564 "num_eq": 10, 1565 "num_range": 490, 1566 "upper_bound": "64077" 1567 }, 1568 { 1569 "distinct_range": 464.0363200331638, 1570 "num_eq": 10, 1571 "num_range": 490, 1572 "upper_bound": "64499" 1573 }, 1574 { 1575 "distinct_range": 538.8191993291548, 1576 "num_eq": 10, 1577 "num_range": 490, 1578 "upper_bound": "65107" 1579 }, 1580 { 1581 "distinct_range": 557.2219619410254, 1582 "num_eq": 10, 1583 "num_range": 490, 1584 "upper_bound": "65779" 1585 }, 1586 { 1587 "distinct_range": 461.41843969674596, 1588 "num_eq": 10, 1589 "num_range": 490, 1590 "upper_bound": "66196" 1591 }, 1592 { 1593 "distinct_range": 473.6241323347582, 1594 "num_eq": 10, 1595 "num_range": 490, 1596 "upper_bound": "66637" 1597 }, 1598 { 1599 "distinct_range": 482.2120464126888, 1600 "num_eq": 10, 1601 "num_range": 490, 1602 "upper_bound": "67096" 1603 }, 1604 { 1605 "distinct_range": 427.1519443087804, 1606 "num_eq": 10, 1607 "num_range": 490, 1608 "upper_bound": "67454" 1609 }, 1610 { 1611 "distinct_range": 486.33677627644795, 1612 "num_eq": 10, 1613 "num_range": 490, 1614 "upper_bound": "67922" 1615 }, 1616 { 1617 "distinct_range": 466.61391124742653, 1618 "num_eq": 10, 1619 "num_range": 490, 1620 "upper_bound": "68349" 1621 }, 1622 { 1623 "distinct_range": 535.3583980442121, 1624 "num_eq": 10, 1625 "num_range": 490, 1626 "upper_bound": "68946" 1627 }, 1628 { 1629 "distinct_range": 426.5120606780091, 1630 "num_eq": 10, 1631 "num_range": 490, 1632 "upper_bound": "69303" 1633 }, 1634 { 1635 "distinct_range": 550.6470987543071, 1636 "num_eq": 10, 1637 "num_range": 490, 1638 "upper_bound": "69951" 1639 }, 1640 { 1641 "distinct_range": 541.5815129088834, 1642 "num_eq": 10, 1643 "num_range": 490, 1644 "upper_bound": "70568" 1645 }, 1646 { 1647 "distinct_range": 492.5413193501455, 1648 "num_eq": 10, 1649 "num_range": 490, 1650 "upper_bound": "71050" 1651 }, 1652 { 1653 "distinct_range": 467.63386199582635, 1654 "num_eq": 10, 1655 "num_range": 490, 1656 "upper_bound": "71479" 1657 }, 1658 { 1659 "distinct_range": 501.3932569997425, 1660 "num_eq": 10, 1661 "num_range": 490, 1662 "upper_bound": "71982" 1663 }, 1664 { 1665 "distinct_range": 466.1015741382656, 1666 "num_eq": 10, 1667 "num_range": 490, 1668 "upper_bound": "72408" 1669 }, 1670 { 1671 "distinct_range": 473.6241323347582, 1672 "num_eq": 10, 1673 "num_range": 490, 1674 "upper_bound": "72849" 1675 }, 1676 { 1677 "distinct_range": 429.6901183217293, 1678 "num_eq": 10, 1679 "num_range": 490, 1680 "upper_bound": "73211" 1681 }, 1682 { 1683 "distinct_range": 508.5763252375702, 1684 "num_eq": 10, 1685 "num_range": 490, 1686 "upper_bound": "73732" 1687 }, 1688 { 1689 "distinct_range": 527.8050879224052, 1690 "num_eq": 10, 1691 "num_range": 490, 1692 "upper_bound": "74306" 1693 }, 1694 { 1695 "distinct_range": 525.190468968422, 1696 "num_eq": 10, 1697 "num_range": 500, 1698 "upper_bound": "74854" 1699 }, 1700 { 1701 "distinct_range": 520.2620465814824, 1702 "num_eq": 10, 1703 "num_range": 500, 1704 "upper_bound": "75389" 1705 }, 1706 { 1707 "distinct_range": 534.5574955978867, 1708 "num_eq": 10, 1709 "num_range": 500, 1710 "upper_bound": "75963" 1711 }, 1712 { 1713 "distinct_range": 482.80312078617715, 1714 "num_eq": 10, 1715 "num_range": 500, 1716 "upper_bound": "76412" 1717 }, 1718 { 1719 "distinct_range": 534.9053665095355, 1720 "num_eq": 10, 1721 "num_range": 500, 1722 "upper_bound": "76987" 1723 }, 1724 { 1725 "distinct_range": 557.2264671752764, 1726 "num_eq": 10, 1727 "num_range": 500, 1728 "upper_bound": "77632" 1729 }, 1730 { 1731 "distinct_range": 526.3039339983202, 1732 "num_eq": 10, 1733 "num_range": 500, 1734 "upper_bound": "78183" 1735 }, 1736 { 1737 "distinct_range": 546.5447724676774, 1738 "num_eq": 10, 1739 "num_range": 500, 1740 "upper_bound": "78793" 1741 }, 1742 { 1743 "distinct_range": 534.5574955978867, 1744 "num_eq": 10, 1745 "num_range": 500, 1746 "upper_bound": "79367" 1747 }, 1748 { 1749 "distinct_range": 545.586343654011, 1750 "num_eq": 10, 1751 "num_range": 500, 1752 "upper_bound": "79974" 1753 }, 1754 { 1755 "distinct_range": 504.8219280458486, 1756 "num_eq": 10, 1757 "num_range": 500, 1758 "upper_bound": "80471" 1759 }, 1760 { 1761 "distinct_range": 503.96354854326313, 1762 "num_eq": 10, 1763 "num_range": 500, 1764 "upper_bound": "80966" 1765 }, 1766 { 1767 "distinct_range": 515.9559549353281, 1768 "num_eq": 10, 1769 "num_range": 500, 1770 "upper_bound": "81490" 1771 }, 1772 { 1773 "distinct_range": 545.9066050933661, 1774 "num_eq": 10, 1775 "num_range": 500, 1776 "upper_bound": "82098" 1777 }, 1778 { 1779 "distinct_range": 506.10051885256644, 1780 "num_eq": 10, 1781 "num_range": 500, 1782 "upper_bound": "82598" 1783 }, 1784 { 1785 "distinct_range": 542.6681450342514, 1786 "num_eq": 10, 1787 "num_range": 500, 1788 "upper_bound": "83196" 1789 }, 1790 { 1791 "distinct_range": 456.8350532039654, 1792 "num_eq": 10, 1793 "num_range": 500, 1794 "upper_bound": "83596" 1795 }, 1796 { 1797 "distinct_range": 544.6208143581271, 1798 "num_eq": 10, 1799 "num_range": 500, 1800 "upper_bound": "84200" 1801 }, 1802 { 1803 "distinct_range": 530.3126625902235, 1804 "num_eq": 10, 1805 "num_range": 500, 1806 "upper_bound": "84762" 1807 }, 1808 { 1809 "distinct_range": 490.95343156651285, 1810 "num_eq": 10, 1811 "num_range": 500, 1812 "upper_bound": "85228" 1813 }, 1814 { 1815 "distinct_range": 483.7833173338483, 1816 "num_eq": 10, 1817 "num_range": 500, 1818 "upper_bound": "85679" 1819 }, 1820 { 1821 "distinct_range": 493.2744878998475, 1822 "num_eq": 10, 1823 "num_range": 500, 1824 "upper_bound": "86150" 1825 }, 1826 { 1827 "distinct_range": 509.8728412901637, 1828 "num_eq": 10, 1829 "num_range": 500, 1830 "upper_bound": "86659" 1831 }, 1832 { 1833 "distinct_range": 466.8313622072348, 1834 "num_eq": 10, 1835 "num_range": 500, 1836 "upper_bound": "87077" 1837 }, 1838 { 1839 "distinct_range": 520.2620465814824, 1840 "num_eq": 10, 1841 "num_range": 500, 1842 "upper_bound": "87612" 1843 }, 1844 { 1845 "distinct_range": 484.2712401134161, 1846 "num_eq": 10, 1847 "num_range": 500, 1848 "upper_bound": "88064" 1849 }, 1850 { 1851 "distinct_range": 546.2260804264541, 1852 "num_eq": 10, 1853 "num_range": 500, 1854 "upper_bound": "88673" 1855 }, 1856 { 1857 "distinct_range": 479.8272799790062, 1858 "num_eq": 10, 1859 "num_range": 500, 1860 "upper_bound": "89116" 1861 }, 1862 { 1863 "distinct_range": 513.9558916962948, 1864 "num_eq": 10, 1865 "num_range": 500, 1866 "upper_bound": "89635" 1867 }, 1868 { 1869 "distinct_range": 476.7975080514336, 1870 "num_eq": 10, 1871 "num_range": 500, 1872 "upper_bound": "90072" 1873 }, 1874 { 1875 "distinct_range": 504.8219280458486, 1876 "num_eq": 10, 1877 "num_range": 500, 1878 "upper_bound": "90569" 1879 }, 1880 { 1881 "distinct_range": 508.2078786734727, 1882 "num_eq": 10, 1883 "num_range": 500, 1884 "upper_bound": "91074" 1885 }, 1886 { 1887 "distinct_range": 527.0413856173174, 1888 "num_eq": 10, 1889 "num_range": 500, 1890 "upper_bound": "91627" 1891 }, 1892 { 1893 "distinct_range": 525.190468968422, 1894 "num_eq": 10, 1895 "num_range": 500, 1896 "upper_bound": "92175" 1897 }, 1898 { 1899 "distinct_range": 497.3688887860809, 1900 "num_eq": 10, 1901 "num_range": 500, 1902 "upper_bound": "92655" 1903 }, 1904 { 1905 "distinct_range": 513.1482081548593, 1906 "num_eq": 10, 1907 "num_range": 500, 1908 "upper_bound": "93172" 1909 }, 1910 { 1911 "distinct_range": 563.5009857168437, 1912 "num_eq": 10, 1913 "num_range": 500, 1914 "upper_bound": "93839" 1915 }, 1916 { 1917 "distinct_range": 487.64665329475656, 1918 "num_eq": 10, 1919 "num_range": 500, 1920 "upper_bound": "94298" 1921 }, 1922 { 1923 "distinct_range": 491.88589617972406, 1924 "num_eq": 10, 1925 "num_range": 500, 1926 "upper_bound": "94766" 1927 }, 1928 { 1929 "distinct_range": 515.9559549353281, 1930 "num_eq": 10, 1931 "num_range": 500, 1932 "upper_bound": "95290" 1933 }, 1934 { 1935 "distinct_range": 482.80312078617715, 1936 "num_eq": 10, 1937 "num_range": 500, 1938 "upper_bound": "95739" 1939 }, 1940 { 1941 "distinct_range": 534.5574955978867, 1942 "num_eq": 10, 1943 "num_range": 500, 1944 "upper_bound": "96313" 1945 }, 1946 { 1947 "distinct_range": 483.2939462585094, 1948 "num_eq": 10, 1949 "num_range": 500, 1950 "upper_bound": "96763" 1951 }, 1952 { 1953 "distinct_range": 549.3782107384154, 1954 "num_eq": 10, 1955 "num_range": 500, 1956 "upper_bound": "97382" 1957 }, 1958 { 1959 "distinct_range": 531.0292824534696, 1960 "num_eq": 10, 1961 "num_range": 500, 1962 "upper_bound": "97946" 1963 }, 1964 { 1965 "distinct_range": 530.6714362137712, 1966 "num_eq": 10, 1967 "num_range": 500, 1968 "upper_bound": "98509" 1969 }, 1970 { 1971 "distinct_range": 462.4578078381812, 1972 "num_eq": 10, 1973 "num_range": 500, 1974 "upper_bound": "98919" 1975 }, 1976 { 1977 "distinct_range": 533.1570784022684, 1978 "num_eq": 10, 1979 "num_range": 500, 1980 "upper_bound": "99489" 1981 }, 1982 { 1983 "distinct_range": 499.15500106215626, 1984 "num_eq": 10, 1985 "num_range": 500, 1986 "upper_bound": "99973" 1987 } 1988 ], 1989 "histo_col_type": "INT8", 1990 "name": "__auto__", 1991 "null_count": 0, 1992 "row_count": 100000 1993 }, 1994 { 1995 "columns": [ 1996 "i_im_id" 1997 ], 1998 "created_at": "2019-07-29 14:57:03.349887+00:00", 1999 "distinct_count": 9918, 2000 "histo_col_type": "", 2001 "name": "__auto__", 2002 "null_count": 0, 2003 "row_count": 100000 2004 }, 2005 { 2006 "columns": [ 2007 "i_name" 2008 ], 2009 "created_at": "2019-07-29 14:57:03.349887+00:00", 2010 "distinct_count": 682, 2011 "histo_col_type": "", 2012 "name": "__auto__", 2013 "null_count": 0, 2014 "row_count": 100000 2015 }, 2016 { 2017 "columns": [ 2018 "i_price" 2019 ], 2020 "created_at": "2019-07-29 14:57:03.349887+00:00", 2021 "distinct_count": 9857, 2022 "histo_col_type": "", 2023 "name": "__auto__", 2024 "null_count": 0, 2025 "row_count": 100000 2026 }, 2027 { 2028 "columns": [ 2029 "i_data" 2030 ], 2031 "created_at": "2019-07-29 14:57:03.349887+00:00", 2032 "distinct_count": 11682, 2033 "histo_col_type": "", 2034 "name": "__auto__", 2035 "null_count": 0, 2036 "row_count": 100000 2037 } 2038 ]'; 2039 ---- 2040 2041 exec-ddl 2042 ALTER TABLE new_order INJECT STATISTICS '[ 2043 { 2044 "columns": [ 2045 "no_w_id" 2046 ], 2047 "created_at": "2019-07-29 14:57:13.695475+00:00", 2048 "distinct_count": 10, 2049 "histo_buckets": [ 2050 { 2051 "distinct_range": 0, 2052 "num_eq": 9333, 2053 "num_range": 0, 2054 "upper_bound": "0" 2055 }, 2056 { 2057 "distinct_range": 0, 2058 "num_eq": 9189, 2059 "num_range": 0, 2060 "upper_bound": "1" 2061 }, 2062 { 2063 "distinct_range": 0, 2064 "num_eq": 9261, 2065 "num_range": 0, 2066 "upper_bound": "2" 2067 }, 2068 { 2069 "distinct_range": 0, 2070 "num_eq": 9162, 2071 "num_range": 0, 2072 "upper_bound": "3" 2073 }, 2074 { 2075 "distinct_range": 0, 2076 "num_eq": 9306, 2077 "num_range": 0, 2078 "upper_bound": "4" 2079 }, 2080 { 2081 "distinct_range": 0, 2082 "num_eq": 8442, 2083 "num_range": 0, 2084 "upper_bound": "5" 2085 }, 2086 { 2087 "distinct_range": 0, 2088 "num_eq": 8946, 2089 "num_range": 0, 2090 "upper_bound": "6" 2091 }, 2092 { 2093 "distinct_range": 0, 2094 "num_eq": 8532, 2095 "num_range": 0, 2096 "upper_bound": "7" 2097 }, 2098 { 2099 "distinct_range": 0, 2100 "num_eq": 9135, 2101 "num_range": 0, 2102 "upper_bound": "8" 2103 }, 2104 { 2105 "distinct_range": 0, 2106 "num_eq": 8694, 2107 "num_range": 0, 2108 "upper_bound": "9" 2109 } 2110 ], 2111 "histo_col_type": "INT8", 2112 "name": "__auto__", 2113 "null_count": 0, 2114 "row_count": 90000 2115 }, 2116 { 2117 "columns": [ 2118 "no_o_id" 2119 ], 2120 "created_at": "2019-07-29 14:57:13.695475+00:00", 2121 "distinct_count": 900, 2122 "histo_col_type": "", 2123 "name": "__auto__", 2124 "null_count": 0, 2125 "row_count": 90000 2126 }, 2127 { 2128 "columns": [ 2129 "no_d_id" 2130 ], 2131 "created_at": "2019-07-29 14:57:13.695475+00:00", 2132 "distinct_count": 10, 2133 "histo_col_type": "", 2134 "name": "__auto__", 2135 "null_count": 0, 2136 "row_count": 90000 2137 }, 2138 { 2139 "columns": [ 2140 "no_w_id", 2141 "no_d_id" 2142 ], 2143 "created_at": "2019-07-29 14:57:13.695475+00:00", 2144 "distinct_count": 100, 2145 "histo_col_type": "", 2146 "name": "__auto__", 2147 "null_count": 0, 2148 "row_count": 90000 2149 }, 2150 { 2151 "columns": [ 2152 "no_w_id", 2153 "no_d_id", 2154 "no_o_id" 2155 ], 2156 "created_at": "2019-07-29 14:57:13.695475+00:00", 2157 "distinct_count": 91157, 2158 "histo_col_type": "", 2159 "name": "__auto__", 2160 "null_count": 0, 2161 "row_count": 90000 2162 } 2163 ]'; 2164 ---- 2165 2166 exec-ddl 2167 ALTER TABLE "order" INJECT STATISTICS '[ 2168 { 2169 "columns": [ 2170 "o_w_id" 2171 ], 2172 "created_at": "2019-07-29 14:57:13.540867+00:00", 2173 "distinct_count": 10, 2174 "histo_buckets": [ 2175 { 2176 "distinct_range": 0, 2177 "num_eq": 29280, 2178 "num_range": 0, 2179 "upper_bound": "0" 2180 }, 2181 { 2182 "distinct_range": 0, 2183 "num_eq": 29310, 2184 "num_range": 0, 2185 "upper_bound": "1" 2186 }, 2187 { 2188 "distinct_range": 0, 2189 "num_eq": 31560, 2190 "num_range": 0, 2191 "upper_bound": "2" 2192 }, 2193 { 2194 "distinct_range": 0, 2195 "num_eq": 30000, 2196 "num_range": 0, 2197 "upper_bound": "3" 2198 }, 2199 { 2200 "distinct_range": 0, 2201 "num_eq": 29220, 2202 "num_range": 0, 2203 "upper_bound": "4" 2204 }, 2205 { 2206 "distinct_range": 0, 2207 "num_eq": 30720, 2208 "num_range": 0, 2209 "upper_bound": "5" 2210 }, 2211 { 2212 "distinct_range": 0, 2213 "num_eq": 31110, 2214 "num_range": 0, 2215 "upper_bound": "6" 2216 }, 2217 { 2218 "distinct_range": 0, 2219 "num_eq": 30510, 2220 "num_range": 0, 2221 "upper_bound": "7" 2222 }, 2223 { 2224 "distinct_range": 0, 2225 "num_eq": 29070, 2226 "num_range": 0, 2227 "upper_bound": "8" 2228 }, 2229 { 2230 "distinct_range": 0, 2231 "num_eq": 29220, 2232 "num_range": 0, 2233 "upper_bound": "9" 2234 } 2235 ], 2236 "histo_col_type": "INT8", 2237 "name": "__auto__", 2238 "null_count": 0, 2239 "row_count": 300000 2240 }, 2241 { 2242 "columns": [ 2243 "o_id" 2244 ], 2245 "created_at": "2019-07-29 14:57:13.540867+00:00", 2246 "distinct_count": 2999, 2247 "histo_col_type": "", 2248 "name": "__auto__", 2249 "null_count": 0, 2250 "row_count": 300000 2251 }, 2252 { 2253 "columns": [ 2254 "o_d_id" 2255 ], 2256 "created_at": "2019-07-29 14:57:13.540867+00:00", 2257 "distinct_count": 10, 2258 "histo_col_type": "", 2259 "name": "__auto__", 2260 "null_count": 0, 2261 "row_count": 300000 2262 }, 2263 { 2264 "columns": [ 2265 "o_c_id" 2266 ], 2267 "created_at": "2019-07-29 14:57:13.540867+00:00", 2268 "distinct_count": 2999, 2269 "histo_col_type": "", 2270 "name": "__auto__", 2271 "null_count": 0, 2272 "row_count": 300000 2273 }, 2274 { 2275 "columns": [ 2276 "o_entry_d" 2277 ], 2278 "created_at": "2019-07-29 14:57:13.540867+00:00", 2279 "distinct_count": 1, 2280 "histo_col_type": "", 2281 "name": "__auto__", 2282 "null_count": 0, 2283 "row_count": 300000 2284 }, 2285 { 2286 "columns": [ 2287 "o_carrier_id" 2288 ], 2289 "created_at": "2019-07-29 14:57:13.540867+00:00", 2290 "distinct_count": 11, 2291 "histo_col_type": "", 2292 "name": "__auto__", 2293 "null_count": 90000, 2294 "row_count": 300000 2295 }, 2296 { 2297 "columns": [ 2298 "o_ol_cnt" 2299 ], 2300 "created_at": "2019-07-29 14:57:13.540867+00:00", 2301 "distinct_count": 11, 2302 "histo_col_type": "", 2303 "name": "__auto__", 2304 "null_count": 0, 2305 "row_count": 300000 2306 }, 2307 { 2308 "columns": [ 2309 "o_all_local" 2310 ], 2311 "created_at": "2019-07-29 14:57:13.540867+00:00", 2312 "distinct_count": 1, 2313 "histo_col_type": "", 2314 "name": "__auto__", 2315 "null_count": 0, 2316 "row_count": 300000 2317 }, 2318 { 2319 "columns": [ 2320 "o_w_id", 2321 "o_d_id" 2322 ], 2323 "created_at": "2019-07-29 14:57:13.540867+00:00", 2324 "distinct_count": 100, 2325 "histo_col_type": "", 2326 "name": "__auto__", 2327 "null_count": 0, 2328 "row_count": 300000 2329 }, 2330 { 2331 "columns": [ 2332 "o_w_id", 2333 "o_d_id", 2334 "o_id" 2335 ], 2336 "created_at": "2019-07-29 14:57:13.540867+00:00", 2337 "distinct_count": 295745, 2338 "histo_col_type": "", 2339 "name": "__auto__", 2340 "null_count": 0, 2341 "row_count": 300000 2342 }, 2343 { 2344 "columns": [ 2345 "o_w_id", 2346 "o_d_id", 2347 "o_c_id" 2348 ], 2349 "created_at": "2019-07-29 14:57:13.540867+00:00", 2350 "distinct_count": 295745, 2351 "histo_col_type": "", 2352 "name": "__auto__", 2353 "null_count": 0, 2354 "row_count": 300000 2355 }, 2356 { 2357 "columns": [ 2358 "o_w_id", 2359 "o_d_id", 2360 "o_c_id", 2361 "o_id" 2362 ], 2363 "created_at": "2019-07-29 14:57:13.540867+00:00", 2364 "distinct_count": 298416, 2365 "histo_col_type": "", 2366 "name": "__auto__", 2367 "null_count": 0, 2368 "row_count": 300000 2369 } 2370 ]'; 2371 ---- 2372 2373 exec-ddl 2374 ALTER TABLE order_line INJECT STATISTICS '[ 2375 { 2376 "columns": [ 2377 "ol_w_id" 2378 ], 2379 "created_at": "2019-07-29 14:57:02.922665+00:00", 2380 "distinct_count": 10, 2381 "histo_buckets": [ 2382 { 2383 "distinct_range": 0, 2384 "num_eq": 312127, 2385 "num_range": 0, 2386 "upper_bound": "0" 2387 }, 2388 { 2389 "distinct_range": 0, 2390 "num_eq": 278513, 2391 "num_range": 0, 2392 "upper_bound": "1" 2393 }, 2394 { 2395 "distinct_range": 0, 2396 "num_eq": 298921, 2397 "num_range": 0, 2398 "upper_bound": "2" 2399 }, 2400 { 2401 "distinct_range": 0, 2402 "num_eq": 307325, 2403 "num_range": 0, 2404 "upper_bound": "3" 2405 }, 2406 { 2407 "distinct_range": 0, 2408 "num_eq": 298921, 2409 "num_range": 0, 2410 "upper_bound": "4" 2411 }, 2412 { 2413 "distinct_range": 0, 2414 "num_eq": 296220, 2415 "num_range": 0, 2416 "upper_bound": "5" 2417 }, 2418 { 2419 "distinct_range": 0, 2420 "num_eq": 313627, 2421 "num_range": 0, 2422 "upper_bound": "6" 2423 }, 2424 { 2425 "distinct_range": 0, 2426 "num_eq": 283915, 2427 "num_range": 0, 2428 "upper_bound": "7" 2429 }, 2430 { 2431 "distinct_range": 0, 2432 "num_eq": 298921, 2433 "num_range": 0, 2434 "upper_bound": "8" 2435 }, 2436 { 2437 "distinct_range": 0, 2438 "num_eq": 312727, 2439 "num_range": 0, 2440 "upper_bound": "9" 2441 } 2442 ], 2443 "histo_col_type": "INT8", 2444 "name": "__auto__", 2445 "null_count": 0, 2446 "row_count": 3001222 2447 }, 2448 { 2449 "columns": [ 2450 "ol_supply_w_id" 2451 ], 2452 "created_at": "2019-07-29 14:57:02.922665+00:00", 2453 "distinct_count": 10, 2454 "histo_buckets": [ 2455 { 2456 "distinct_range": 0, 2457 "num_eq": 312127, 2458 "num_range": 0, 2459 "upper_bound": "0" 2460 }, 2461 { 2462 "distinct_range": 0, 2463 "num_eq": 278513, 2464 "num_range": 0, 2465 "upper_bound": "1" 2466 }, 2467 { 2468 "distinct_range": 0, 2469 "num_eq": 298921, 2470 "num_range": 0, 2471 "upper_bound": "2" 2472 }, 2473 { 2474 "distinct_range": 0, 2475 "num_eq": 307325, 2476 "num_range": 0, 2477 "upper_bound": "3" 2478 }, 2479 { 2480 "distinct_range": 0, 2481 "num_eq": 298921, 2482 "num_range": 0, 2483 "upper_bound": "4" 2484 }, 2485 { 2486 "distinct_range": 0, 2487 "num_eq": 296220, 2488 "num_range": 0, 2489 "upper_bound": "5" 2490 }, 2491 { 2492 "distinct_range": 0, 2493 "num_eq": 313627, 2494 "num_range": 0, 2495 "upper_bound": "6" 2496 }, 2497 { 2498 "distinct_range": 0, 2499 "num_eq": 283915, 2500 "num_range": 0, 2501 "upper_bound": "7" 2502 }, 2503 { 2504 "distinct_range": 0, 2505 "num_eq": 298921, 2506 "num_range": 0, 2507 "upper_bound": "8" 2508 }, 2509 { 2510 "distinct_range": 0, 2511 "num_eq": 312727, 2512 "num_range": 0, 2513 "upper_bound": "9" 2514 } 2515 ], 2516 "histo_col_type": "INT8", 2517 "name": "__auto__", 2518 "null_count": 0, 2519 "row_count": 3001222 2520 }, 2521 { 2522 "columns": [ 2523 "ol_o_id" 2524 ], 2525 "created_at": "2019-07-29 14:57:02.922665+00:00", 2526 "distinct_count": 2999, 2527 "histo_col_type": "", 2528 "name": "__auto__", 2529 "null_count": 0, 2530 "row_count": 3001222 2531 }, 2532 { 2533 "columns": [ 2534 "ol_d_id" 2535 ], 2536 "created_at": "2019-07-29 14:57:02.922665+00:00", 2537 "distinct_count": 10, 2538 "histo_col_type": "", 2539 "name": "__auto__", 2540 "null_count": 0, 2541 "row_count": 3001222 2542 }, 2543 { 2544 "columns": [ 2545 "ol_number" 2546 ], 2547 "created_at": "2019-07-29 14:57:02.922665+00:00", 2548 "distinct_count": 15, 2549 "histo_col_type": "", 2550 "name": "__auto__", 2551 "null_count": 0, 2552 "row_count": 3001222 2553 }, 2554 { 2555 "columns": [ 2556 "ol_i_id" 2557 ], 2558 "created_at": "2019-07-29 14:57:02.922665+00:00", 2559 "distinct_count": 99658, 2560 "histo_col_type": "", 2561 "name": "__auto__", 2562 "null_count": 0, 2563 "row_count": 3001222 2564 }, 2565 { 2566 "columns": [ 2567 "ol_delivery_d" 2568 ], 2569 "created_at": "2019-07-29 14:57:02.922665+00:00", 2570 "distinct_count": 2, 2571 "histo_col_type": "", 2572 "name": "__auto__", 2573 "null_count": 899134, 2574 "row_count": 3001222 2575 }, 2576 { 2577 "columns": [ 2578 "ol_quantity" 2579 ], 2580 "created_at": "2019-07-29 14:57:02.922665+00:00", 2581 "distinct_count": 1, 2582 "histo_col_type": "", 2583 "name": "__auto__", 2584 "null_count": 0, 2585 "row_count": 3001222 2586 }, 2587 { 2588 "columns": [ 2589 "ol_amount" 2590 ], 2591 "created_at": "2019-07-29 14:57:02.922665+00:00", 2592 "distinct_count": 588894, 2593 "histo_col_type": "", 2594 "name": "__auto__", 2595 "null_count": 0, 2596 "row_count": 3001222 2597 }, 2598 { 2599 "columns": [ 2600 "ol_dist_info" 2601 ], 2602 "created_at": "2019-07-29 14:57:02.922665+00:00", 2603 "distinct_count": 398, 2604 "histo_col_type": "", 2605 "name": "__auto__", 2606 "null_count": 0, 2607 "row_count": 3001222 2608 }, 2609 { 2610 "columns": [ 2611 "ol_w_id", 2612 "ol_d_id" 2613 ], 2614 "created_at": "2019-07-29 14:57:02.922665+00:00", 2615 "distinct_count": 100, 2616 "histo_col_type": "", 2617 "name": "__auto__", 2618 "null_count": 0, 2619 "row_count": 3001222}, 2620 { 2621 "columns": [ 2622 "ol_w_id", 2623 "ol_d_id", 2624 "ol_o_id" 2625 ], 2626 "created_at": "2019-07-29 14:57:02.922665+00:00", 2627 "distinct_count": 295745, 2628 "histo_col_type": "", 2629 "name": "__auto__", 2630 "null_count": 0, 2631 "row_count": 3001222 2632 }, 2633 { 2634 "columns": [ 2635 "ol_w_id", 2636 "ol_d_id", 2637 "ol_o_id", 2638 "ol_number" 2639 ], 2640 "created_at": "2019-07-29 14:57:02.922665+00:00", 2641 "distinct_count": 2986292, 2642 "histo_col_type": "", 2643 "name": "__auto__", 2644 "null_count": 0, 2645 "row_count": 3001222 2646 }, 2647 { 2648 "columns": [ 2649 "ol_supply_w_id", 2650 "ol_i_id" 2651 ], 2652 "created_at": "2019-07-29 14:57:02.922665+00:00", 2653 "distinct_count": 946191, 2654 "histo_col_type": "", 2655 "name": "__auto__", 2656 "null_count": 0, 2657 "row_count": 3001222 2658 } 2659 ]'; 2660 ---- 2661 2662 exec-ddl 2663 ALTER TABLE stock INJECT STATISTICS '[ 2664 { 2665 "columns": [ 2666 "s_w_id" 2667 ], 2668 "created_at": "2019-07-29 14:57:08.255234+00:00", 2669 "distinct_count": 10, 2670 "histo_buckets": [ 2671 { 2672 "distinct_range": 0, 2673 "num_eq": 96500, 2674 "num_range": 0, 2675 "upper_bound": "0" 2676 }, 2677 { 2678 "distinct_range": 0, 2679 "num_eq": 102200, 2680 "num_range": 0, 2681 "upper_bound": "1" 2682 }, 2683 { 2684 "distinct_range": 0, 2685 "num_eq": 102800, 2686 "num_range": 0, 2687 "upper_bound": "2" 2688 }, 2689 { 2690 "distinct_range": 0, 2691 "num_eq": 100800, 2692 "num_range": 0, 2693 "upper_bound": "3" 2694 }, 2695 { 2696 "distinct_range": 0, 2697 "num_eq": 99400, 2698 "num_range": 0, 2699 "upper_bound": "4" 2700 }, 2701 { 2702 "distinct_range": 0, 2703 "num_eq": 99500, 2704 "num_range": 0, 2705 "upper_bound": "5" 2706 }, 2707 { 2708 "distinct_range": 0, 2709 "num_eq": 106100, 2710 "num_range": 0, 2711 "upper_bound": "6" 2712 }, 2713 { 2714 "distinct_range": 0, 2715 "num_eq": 97500, 2716 "num_range": 0, 2717 "upper_bound": "7" 2718 }, 2719 { 2720 "distinct_range": 0, 2721 "num_eq": 97600, 2722 "num_range": 0, 2723 "upper_bound": "8" 2724 }, 2725 { 2726 "distinct_range": 0, 2727 "num_eq": 97600, 2728 "num_range": 0, 2729 "upper_bound": "9" 2730 } 2731 ], 2732 "histo_col_type": "INT8", 2733 "name": "__auto__", 2734 "null_count": 0, 2735 "row_count": 1000000 2736 }, 2737 { 2738 "columns": [ 2739 "s_i_id" 2740 ], 2741 "created_at": "2019-07-29 14:57:08.255234+00:00", 2742 "distinct_count": 99658, 2743 "histo_buckets": [ 2744 { 2745 "distinct_range": 0, 2746 "num_eq": 100, 2747 "num_range": 0, 2748 "upper_bound": "17" 2749 }, 2750 { 2751 "distinct_range": 531.3330979531265, 2752 "num_eq": 100, 2753 "num_range": 4900, 2754 "upper_bound": "551" 2755 }, 2756 { 2757 "distinct_range": 650.6668279794195, 2758 "num_eq": 100, 2759 "num_range": 4900, 2760 "upper_bound": "1205" 2761 }, 2762 { 2763 "distinct_range": 597.020772831218, 2764 "num_eq": 100, 2765 "num_range": 4900, 2766 "upper_bound": "1805" 2767 }, 2768 { 2769 "distinct_range": 457.6002235756087, 2770 "num_eq": 100, 2771 "num_range": 4900, 2772 "upper_bound": "2265" 2773 }, 2774 { 2775 "distinct_range": 477.5330891461755, 2776 "num_eq": 100, 2777 "num_range": 4900, 2778 "upper_bound": "2745" 2779 }, 2780 { 2781 "distinct_range": 479.52208543455083, 2782 "num_eq": 200, 2783 "num_range": 4800, 2784 "upper_bound": "3227" 2785 }, 2786 { 2787 "distinct_range": 449.6263957070526, 2788 "num_eq": 200, 2789 "num_range": 4900, 2790 "upper_bound": "3679" 2791 }, 2792 { 2793 "distinct_range": 547.2660638646482, 2794 "num_eq": 100, 2795 "num_range": 4900, 2796 "upper_bound": "4229" 2797 }, 2798 { 2799 "distinct_range": 682.3951447003885, 2800 "num_eq": 100, 2801 "num_range": 4900, 2802 "upper_bound": "4915" 2803 }, 2804 { 2805 "distinct_range": 483.5123804655008, 2806 "num_eq": 100, 2807 "num_range": 4900, 2808 "upper_bound": "5401" 2809 }, 2810 { 2811 "distinct_range": 464.5770263047814, 2812 "num_eq": 100, 2813 "num_range": 4900, 2814 "upper_bound": "5868" 2815 }, 2816 { 2817 "distinct_range": 537.3084824102377, 2818 "num_eq": 100, 2819 "num_range": 4900, 2820 "upper_bound": "6408" 2821 }, 2822 { 2823 "distinct_range": 351.9311981795064, 2824 "num_eq": 100, 2825 "num_range": 4900, 2826 "upper_bound": "6762" 2827 }, 2828 { 2829 "distinct_range": 392.80588516082537, 2830 "num_eq": 100, 2831 "num_range": 4900, 2832 "upper_bound": "7157" 2833 }, 2834 { 2835 "distinct_range": 564.1894417792679, 2836 "num_eq": 100, 2837 "num_range": 4900, 2838 "upper_bound": "7724" 2839 }, 2840 { 2841 "distinct_range": 460.59031789774747, 2842 "num_eq": 100, 2843 "num_range": 4900, 2844 "upper_bound": "8187" 2845 }, 2846 { 2847 "distinct_range": 561.2034119824956, 2848 "num_eq": 100, 2849 "num_range": 4900, 2850 "upper_bound": "8751" 2851 }, 2852 { 2853 "distinct_range": 476.53651256934967, 2854 "num_eq": 100, 2855 "num_range": 4900, 2856 "upper_bound": "9230" 2857 }, 2858 { 2859 "distinct_range": 398.7873801300924, 2860 "num_eq": 100, 2861 "num_range": 4900, 2862 "upper_bound": "9631" 2863 }, 2864 { 2865 "distinct_range": 461.5870042000114, 2866 "num_eq": 100, 2867 "num_range": 4900, 2868 "upper_bound": "10095" 2869 }, 2870 { 2871 "distinct_range": 416.73144367494075, 2872 "num_eq": 100, 2873 "num_range": 4900, 2874 "upper_bound": "10514" 2875 }, 2876 { 2877 "distinct_range": 503.4409714444658, 2878 "num_eq": 100, 2879 "num_range": 4900, 2880 "upper_bound": "11020" 2881 }, 2882 { 2883 "distinct_range": 527.3491857771224, 2884 "num_eq": 100, 2885 "num_range": 4900, 2886 "upper_bound": "11550" 2887 }, 2888 { 2889 "distinct_range": 527.3491857771224, 2890 "num_eq": 200, 2891 "num_range": 4900, 2892 "upper_bound": "12080" 2893 }, 2894 { 2895 "distinct_range": 383.83354120723993, 2896 "num_eq": 100, 2897 "num_range": 4900, 2898 "upper_bound": "12466" 2899 }, 2900 { 2901 "distinct_range": 478.5296579160968, 2902 "num_eq": 100, 2903 "num_range": 4900, 2904 "upper_bound": "12947" 2905 }, 2906 { 2907 "distinct_range": 544.2789812073521, 2908 "num_eq": 100, 2909 "num_range": 4900, 2910 "upper_bound": "13494" 2911 }, 2912 { 2913 "distinct_range": 573.1247322318404, 2914 "num_eq": 200, 2915 "num_range": 4800, 2916 "upper_bound": "14070" 2917 }, 2918 { 2919 "distinct_range": 575.1364101836199, 2920 "num_eq": 100, 2921 "num_range": 4900, 2922 "upper_bound": "14648" 2923 }, 2924 { 2925 "distinct_range": 464.5770263047814, 2926 "num_eq": 100, 2927 "num_range": 4900, 2928 "upper_bound": "15115" 2929 }, 2930 { 2931 "distinct_range": 468.5636327598505, 2932 "num_eq": 100, 2933 "num_range": 4900, 2934 "upper_bound": "15586" 2935 }, 2936 { 2937 "distinct_range": 431.6841871603638, 2938 "num_eq": 100, 2939 "num_range": 4900, 2940 "upper_bound": "16020" 2941 }, 2942 { 2943 "distinct_range": 487.49840555203673, 2944 "num_eq": 100, 2945 "num_range": 4900, 2946 "upper_bound": "16510" 2947 }, 2948 { 2949 "distinct_range": 391.8089637311044, 2950 "num_eq": 100, 2951 "num_range": 4900, 2952 "upper_bound": "16904" 2953 }, 2954 { 2955 "distinct_range": 452.61662073094146, 2956 "num_eq": 100, 2957 "num_range": 4900, 2958 "upper_bound": "17359" 2959 }, 2960 { 2961 "distinct_range": 468.5636327598505, 2962 "num_eq": 100, 2963 "num_range": 4900, 2964 "upper_bound": "17830" 2965 }, 2966 { 2967 "distinct_range": 392.80588516082537, 2968 "num_eq": 100, 2969 "num_range": 4900, 2970 "upper_bound": "18225" 2971 }, 2972 { 2973 "distinct_range": 560.2080240700179, 2974 "num_eq": 100, 2975 "num_range": 4900, 2976 "upper_bound": "18788" 2977 }, 2978 { 2979 "distinct_range": 485.5054105898268, 2980 "num_eq": 100, 2981 "num_range": 4900, 2982 "upper_bound": "19276" 2983 }, 2984 { 2985 "distinct_range": 433.6778305929043, 2986 "num_eq": 100, 2987 "num_range": 4900, 2988 "upper_bound": "19712" 2989 }, 2990 { 2991 "distinct_range": 534.3208647260996, 2992 "num_eq": 100, 2993 "num_range": 4900, 2994 "upper_bound": "20249" 2995 }, 2996 { 2997 "distinct_range": 554.2352434470833, 2998 "num_eq": 100, 2999 "num_range": 4900, 3000 "upper_bound": "20806" 3001 }, 3002 { 3003 "distinct_range": 614.9150851192078, 3004 "num_eq": 100, 3005 "num_range": 4900, 3006 "upper_bound": "21424" 3007 }, 3008 { 3009 "distinct_range": 596.0263342955915, 3010 "num_eq": 100, 3011 "num_range": 4900, 3012 "upper_bound": "22023" 3013 }, 3014 { 3015 "distinct_range": 435.6714592366999, 3016 "num_eq": 100, 3017 "num_range": 4900, 3018 "upper_bound": "22461" 3019 }, 3020 { 3021 "distinct_range": 559.2126142092391, 3022 "num_eq": 100, 3023 "num_range": 4900, 3024 "upper_bound": "23023" 3025 }, 3026 { 3027 "distinct_range": 486.5019125302282, 3028 "num_eq": 100, 3029 "num_range": 4900, 3030 "upper_bound": "23512" 3031 }, 3032 { 3033 "distinct_range": 490.48782980384203, 3034 "num_eq": 100, 3035 "num_range": 4900, 3036 "upper_bound": "24005" 3037 }, 3038 { 3039 "distinct_range": 452.61662073094146, 3040 "num_eq": 100, 3041 "num_range": 4900, 3042 "upper_bound": "24460" 3043 }, 3044 { 3045 "distinct_range": 458.5969274881696, 3046 "num_eq": 100, 3047 "num_range": 4900, 3048 "upper_bound": "24921" 3049 }, 3050 { 3051 "distinct_range": 476.53651256934967, 3052 "num_eq": 100, 3053 "num_range": 4900, 3054 "upper_bound": "25400" 3055 }, 3056 { 3057 "distinct_range": 507.41898051442877, 3058 "num_eq": 200, 3059 "num_range": 4800, 3060 "upper_bound": "25910" 3061 }, 3062 { 3063 "distinct_range": 528.3451871745114, 3064 "num_eq": 100, 3065 "num_range": 4900, 3066 "upper_bound": "26441" 3067 }, 3068 { 3069 "distinct_range": 501.4482965869506, 3070 "num_eq": 100, 3071 "num_range": 4900, 3072 "upper_bound": "26945" 3073 }, 3074 { 3075 "distinct_range": 492.4807323034401, 3076 "num_eq": 100, 3077 "num_range": 4900, 3078 "upper_bound": "27440" 3079 }, 3080 { 3081 "distinct_range": 460.59031789774747, 3082 "num_eq": 100, 3083 "num_range": 4900, 3084 "upper_bound": "27903" 3085 }, 3086 { 3087 "distinct_range": 530.337143446228, 3088 "num_eq": 100, 3089 "num_range": 4900, 3090 "upper_bound": "28436" 3091 }, 3092 { 3093 "distinct_range": 559.2126142092391, 3094 "num_eq": 100, 3095 "num_range": 4900, 3096 "upper_bound": "28998" 3097 }, 3098 { 3099 "distinct_range": 561.2034119824956, 3100 "num_eq": 100, 3101 "num_range": 4900, 3102 "upper_bound": "29562" 3103 }, 3104 { 3105 "distinct_range": 504.4372920122093, 3106 "num_eq": 100, 3107 "num_range": 4900, 3108 "upper_bound": "30069" 3109 }, 3110 { 3111 "distinct_range": 429.6905294947952, 3112 "num_eq": 100, 3113 "num_range": 4900, 3114 "upper_bound": "30501" 3115 }, 3116 { 3117 "distinct_range": 591.0536847293354, 3118 "num_eq": 100, 3119 "num_range": 4900, 3120 "upper_bound": "31095" 3121 }, 3122 { 3123 "distinct_range": 433.6778305929043, 3124 "num_eq": 100, 3125 "num_range": 4900, 3126 "upper_bound": "31531" 3127 }, 3128 { 3129 "distinct_range": 562.1987777222237, 3130 "num_eq": 100, 3131 "num_range": 4900, 3132 "upper_bound": "32096" 3133 }, 3134 { 3135 "distinct_range": 565.1847396413228, 3136 "num_eq": 100, 3137 "num_range": 4900, 3138 "upper_bound": "32664" 3139 }, 3140 { 3141 "distinct_range": 575.1364101836199, 3142 "num_eq": 100, 3143 "num_range": 4900, 3144 "upper_bound": "33242" 3145 }, 3146 { 3147 "distinct_range": 377.85192162448334, 3148 "num_eq": 100, 3149 "num_range": 4900, 3150 "upper_bound": "33622" 3151 }, 3152 { 3153 "distinct_range": 560.2080240700179, 3154 "num_eq": 100, 3155 "num_range": 4900, 3156 "upper_bound": "34185" 3157 }, 3158 { 3159 "distinct_range": 593.0428348690202, 3160 "num_eq": 100, 3161 "num_range": 4900, 3162 "upper_bound": "34781" 3163 }, 3164 { 3165 "distinct_range": 467.56699106752535, 3166 "num_eq": 100, 3167 "num_range": 4900, 3168 "upper_bound": "35251" 3169 }, 3170 { 3171 "distinct_range": 459.59362562782314, 3172 "num_eq": 100, 3173 "num_range": 4900, 3174 "upper_bound": "35713" 3175 }, 3176 { 3177 "distinct_range": 514.3998428951757, 3178 "num_eq": 100, 3179 "num_range": 4900, 3180 "upper_bound": "36230" 3181 }, 3182 { 3183 "distinct_range": 305.07375038484014, 3184 "num_eq": 100, 3185 "num_range": 4900, 3186 "upper_bound": "36537" 3187 }, 3188 { 3189 "distinct_range": 409.75328173969405, 3190 "num_eq": 100, 3191 "num_range": 4900, 3192 "upper_bound": "36949" 3193 }, 3194 { 3195 "distinct_range": 471.5535166532493, 3196 "num_eq": 100, 3197 "num_range": 4900, 3198 "upper_bound": "37423" 3199 }, 3200 { 3201 "distinct_range": 519.3806400570277, 3202 "num_eq": 100, 3203 "num_range": 4900, 3204 "upper_bound": "37945" 3205 }, 3206 { 3207 "distinct_range": 485.5054105898268, 3208 "num_eq": 100, 3209 "num_range": 4900, 3210 "upper_bound": "38433" 3211 }, 3212 { 3213 "distinct_range": 597.020772831218, 3214 "num_eq": 100, 3215 "num_range": 4900, 3216 "upper_bound": "39033" 3217 }, 3218 { 3219 "distinct_range": 491.484285843069, 3220 "num_eq": 100, 3221 "num_range": 4900, 3222 "upper_bound": "39527" 3223 }, 3224 { 3225 "distinct_range": 556.2262551624232, 3226 "num_eq": 100, 3227 "num_range": 4900, 3228 "upper_bound": "40086" 3229 }, 3230 { 3231 "distinct_range": 482.51585253465703, 3232 "num_eq": 100, 3233 "num_range": 4900, 3234 "upper_bound": "40571" 3235 }, 3236 { 3237 "distinct_range": 538.3043209470151, 3238 "num_eq": 100, 3239 "num_range": 4900, 3240 "upper_bound": "41112" 3241 }, 3242 { 3243 "distinct_range": 516.3922019821044, 3244 "num_eq": 100, 3245 "num_range": 4900, 3246 "upper_bound": "41631" 3247 }, 3248 { 3249 "distinct_range": 514.3998428951757, 3250 "num_eq": 100, 3251 "num_range": 4900, 3252 "upper_bound": "42148" 3253 }, 3254 { 3255 "distinct_range": 591.0536847293354, 3256 "num_eq": 100, 3257 "num_range": 4900, 3258 "upper_bound": "42742" 3259 }, 3260 { 3261 "distinct_range": 647.6896494995074, 3262 "num_eq": 100, 3263 "num_range": 4900, 3264 "upper_bound": "43393" 3265 }, 3266 { 3267 "distinct_range": 572.1511653309326, 3268 "num_eq": 100, 3269 "num_range": 4900, 3270 "upper_bound": "43968" 3271 }, 3272 { 3273 "distinct_range": 487.49840555203673, 3274 "num_eq": 100, 3275 "num_range": 4900, 3276 "upper_bound": "44458" 3277 }, 3278 { 3279 "distinct_range": 466.57034269053884, 3280 "num_eq": 100, 3281 "num_range": 4900, 3282 "upper_bound": "44927" 3283 }, 3284 { 3285 "distinct_range": 493.47716904919713, 3286 "num_eq": 100, 3287 "num_range": 4900, 3288 "upper_bound": "45423" 3289 }, 3290 { 3291 "distinct_range": 501.4482965869506, 3292 "num_eq": 100, 3293 "num_range": 4900, 3294 "upper_bound": "45927" 3295 }, 3296 { 3297 "distinct_range": 508.4224583420318, 3298 "num_eq": 100, 3299 "num_range": 4900, 3300 "upper_bound": "46438" 3301 }, 3302 { 3303 "distinct_range": 493.47716904919713, 3304 "num_eq": 100, 3305 "num_range": 4900, 3306 "upper_bound": "46934" 3307 }, 3308 { 3309 "distinct_range": 521.372863100691, 3310 "num_eq": 100, 3311 "num_range": 4900, 3312 "upper_bound": "47458" 3313 }, 3314 { 3315 "distinct_range": 494.47359594333955, 3316 "num_eq": 100, 3317 "num_range": 4900, 3318 "upper_bound": "47955" 3319 }, 3320 { 3321 "distinct_range": 518.38450766322, 3322 "num_eq": 100, 3323 "num_range": 4900, 3324 "upper_bound": "48476" 3325 }, 3326 { 3327 "distinct_range": 532.3290364602652, 3328 "num_eq": 200, 3329 "num_range": 4900, 3330 "upper_bound": "49011" 3331 }, 3332 { 3333 "distinct_range": 406.7626058734695, 3334 "num_eq": 100, 3335 "num_range": 4900, 3336 "upper_bound": "49420" 3337 }, 3338 { 3339 "distinct_range": 387.82126336203174, 3340 "num_eq": 100, 3341 "num_range": 4900, 3342 "upper_bound": "49810" 3343 }, 3344 { 3345 "distinct_range": 549.2573569088854, 3346 "num_eq": 100, 3347 "num_range": 4900, 3348 "upper_bound": "50362" 3349 }, 3350 { 3351 "distinct_range": 509.41124206838856, 3352 "num_eq": 200, 3353 "num_range": 4800, 3354 "upper_bound": "50874" 3355 }, 3356 { 3357 "distinct_range": 479.526218760407, 3358 "num_eq": 100, 3359 "num_range": 4900, 3360 "upper_bound": "51356" 3361 }, 3362 { 3363 "distinct_range": 544.2789812073521, 3364 "num_eq": 100, 3365 "num_range": 4900, 3366 "upper_bound": "51903" 3367 }, 3368 { 3369 "distinct_range": 541.2917317567831, 3370 "num_eq": 100, 3371 "num_range": 4900, 3372 "upper_bound": "52447" 3373 }, 3374 { 3375 "distinct_range": 460.59031789774747, 3376 "num_eq": 100, 3377 "num_range": 4900, 3378 "upper_bound": "52910" 3379 }, 3380 { 3381 "distinct_range": 448.62964401482515, 3382 "num_eq": 100, 3383 "num_range": 4900, 3384 "upper_bound": "53361" 3385 }, 3386 { 3387 "distinct_range": 560.2080240700179, 3388 "num_eq": 100, 3389 "num_range": 4900, 3390 "upper_bound": "53924" 3391 }, 3392 { 3393 "distinct_range": 429.6905294947952, 3394 "num_eq": 100, 3395 "num_range": 4900, 3396 "upper_bound": "54356" 3397 }, 3398 { 3399 "distinct_range": 481.51931619138855, 3400 "num_eq": 100, 3401 "num_range": 4900, 3402 "upper_bound": "54840" 3403 }, 3404 { 3405 "distinct_range": 548.2470475602479, 3406 "num_eq": 200, 3407 "num_range": 4800, 3408 "upper_bound": "55391" 3409 }, 3410 { 3411 "distinct_range": 485.5054105898268, 3412 "num_eq": 100, 3413 "num_range": 4900, 3414 "upper_bound": "55879" 3415 }, 3416 { 3417 "distinct_range": 489.4913643202781, 3418 "num_eq": 100, 3419 "num_range": 4900, 3420 "upper_bound": "56371" 3421 }, 3422 { 3423 "distinct_range": 522.3594865143865, 3424 "num_eq": 200, 3425 "num_range": 4800, 3426 "upper_bound": "56896" 3427 }, 3428 { 3429 "distinct_range": 455.60679881353497, 3430 "num_eq": 100, 3431 "num_range": 4900, 3432 "upper_bound": "57354" 3433 }, 3434 { 3435 "distinct_range": 467.56699106752535, 3436 "num_eq": 100, 3437 "num_range": 4900, 3438 "upper_bound": "57824" 3439 }, 3440 { 3441 "distinct_range": 464.5770263047814, 3442 "num_eq": 100, 3443 "num_range": 4900, 3444 "upper_bound": "58291" 3445 }, 3446 { 3447 "distinct_range": 546.2703885178953, 3448 "num_eq": 100, 3449 "num_range": 4900, 3450 "upper_bound": "58840" 3451 }, 3452 { 3453 "distinct_range": 545.2746942304125, 3454 "num_eq": 100, 3455 "num_range": 4900, 3456 "upper_bound": "59388" 3457 }, 3458 { 3459 "distinct_range": 583.0959253978468, 3460 "num_eq": 100, 3461 "num_range": 4900, 3462 "upper_bound": "59974" 3463 }, 3464 { 3465 "distinct_range": 422.7126232509678, 3466 "num_eq": 100, 3467 "num_range": 4900, 3468 "upper_bound": "60399" 3469 }, 3470 { 3471 "distinct_range": 455.60679881353497, 3472 "num_eq": 100, 3473 "num_range": 4900, 3474 "upper_bound": "60857" 3475 }, 3476 { 3477 "distinct_range": 495.4700128476221, 3478 "num_eq": 100, 3479 "num_range": 4900, 3480 "upper_bound": "61355" 3481 }, 3482 { 3483 "distinct_range": 462.58368443556935, 3484 "num_eq": 100, 3485 "num_range": 4900, 3486 "upper_bound": "61820" 3487 }, 3488 { 3489 "distinct_range": 563.1941210634794, 3490 "num_eq": 100, 3491 "num_range": 4900, 3492 "upper_bound": "62386" 3493 }, 3494 { 3495 "distinct_range": 461.5870042000114, 3496 "num_eq": 100, 3497 "num_range": 4900, 3498 "upper_bound": "62850" 3499 }, 3500 { 3501 "distinct_range": 495.4700128476221, 3502 "num_eq": 100, 3503 "num_range": 4900, 3504 "upper_bound": "63348" 3505 }, 3506 { 3507 "distinct_range": 512.4074317269889, 3508 "num_eq": 100, 3509 "num_range": 4900, 3510 "upper_bound": "63863" 3511 }, 3512 { 3513 "distinct_range": 546.2703885178953, 3514 "num_eq": 100, 3515 "num_range": 4900, 3516 "upper_bound": "64412" 3517 }, 3518 { 3519 "distinct_range": 345.94943274573734, 3520 "num_eq": 100, 3521 "num_range": 4900, 3522 "upper_bound": "64760" 3523 }, 3524 { 3525 "distinct_range": 548.2617200642252, 3526 "num_eq": 100, 3527 "num_range": 4900, 3528 "upper_bound": "65311" 3529 }, 3530 { 3531 "distinct_range": 456.6035139858577, 3532 "num_eq": 100, 3533 "num_range": 4900, 3534 "upper_bound": "65770" 3535 }, 3536 { 3537 "distinct_range": 566.1800144201098, 3538 "num_eq": 100, 3539 "num_range": 4900, 3540 "upper_bound": "66339" 3541 }, 3542 { 3543 "distinct_range": 529.3411731252347, 3544 "num_eq": 100, 3545 "num_range": 4900, 3546 "upper_bound": "66871" 3547 }, 3548 { 3549 "distinct_range": 411.7452725297453, 3550 "num_eq": 300, 3551 "num_range": 4700, 3552 "upper_bound": "67285" 3553 }, 3554 { 3555 "distinct_range": 545.2746942304125, 3556 "num_eq": 100, 3557 "num_range": 4900, 3558 "upper_bound": "67833" 3559 }, 3560 { 3561 "distinct_range": 529.3411731252347, 3562 "num_eq": 100, 3563 "num_range": 4900, 3564 "upper_bound": "68365" 3565 }, 3566 { 3567 "distinct_range": 488.4948895256598, 3568 "num_eq": 100, 3569 "num_range": 4900, 3570 "upper_bound": "68856" 3571 }, 3572 { 3573 "distinct_range": 540.2959458170056, 3574 "num_eq": 100, 3575 "num_range": 4900, 3576 "upper_bound": "69399" 3577 }, 3578 { 3579 "distinct_range": 471.5535166532493, 3580 "num_eq": 100, 3581 "num_range": 4900, 3582 "upper_bound": "69873" 3583 }, 3584 { 3585 "distinct_range": 456.6035139858577, 3586 "num_eq": 100, 3587 "num_range": 4900, 3588 "upper_bound": "70332" 3589 }, 3590 { 3591 "distinct_range": 401.77810423952087, 3592 "num_eq": 100, 3593 "num_range": 4900, 3594 "upper_bound": "70736" 3595 }, 3596 { 3597 "distinct_range": 477.52912649591633, 3598 "num_eq": 200, 3599 "num_range": 4800, 3600 "upper_bound": "71216" 3601 }, 3602 { 3603 "distinct_range": 417.7283138487272, 3604 "num_eq": 100, 3605 "num_range": 4900, 3606 "upper_bound": "71636" 3607 }, 3608 { 3609 "distinct_range": 478.5296579160968, 3610 "num_eq": 200, 3611 "num_range": 4900, 3612 "upper_bound": "72117" 3613 }, 3614 { 3615 "distinct_range": 569.1656979425295, 3616 "num_eq": 100, 3617 "num_range": 4900, 3618 "upper_bound": "72689" 3619 }, 3620 { 3621 "distinct_range": 503.4409714444658, 3622 "num_eq": 100, 3623 "num_range": 4900, 3624 "upper_bound": "73195" 3625 }, 3626 { 3627 "distinct_range": 442.64903464331536, 3628 "num_eq": 100, 3629 "num_range": 4900, 3630 "upper_bound": "73640" 3631 }, 3632 { 3633 "distinct_range": 487.49840555203673, 3634 "num_eq": 100, 3635 "num_range": 4900, 3636 "upper_bound": "74130" 3637 }, 3638 { 3639 "distinct_range": 482.51585253465703, 3640 "num_eq": 100, 3641 "num_range": 4900, 3642 "upper_bound": "74615" 3643 }, 3644 { 3645 "distinct_range": 467.56699106752535, 3646 "num_eq": 100, 3647 "num_range": 4900, 3648 "upper_bound": "75085" 3649 }, 3650 { 3651 "distinct_range": 537.3084824102377, 3652 "num_eq": 100, 3653 "num_range": 4900, 3654 "upper_bound": "75625" 3655 }, 3656 { 3657 "distinct_range": 496.46641962255137, 3658 "num_eq": 100, 3659 "num_range": 4900, 3660 "upper_bound": "76124" 3661 }, 3662 { 3663 "distinct_range": 413.7408175738507, 3664 "num_eq": 100, 3665 "num_range": 4900, 3666 "upper_bound": "76540" 3667 }, 3668 { 3669 "distinct_range": 479.526218760407, 3670 "num_eq": 100, 3671 "num_range": 4900, 3672 "upper_bound": "77022" 3673 }, 3674 { 3675 "distinct_range": 547.2780959270588, 3676 "num_eq": 100, 3677 "num_range": 5000, 3678 "upper_bound": "77572" 3679 }, 3680 { 3681 "distinct_range": 534.3305303920398, 3682 "num_eq": 100, 3683 "num_range": 5000, 3684 "upper_bound": "78109" 3685 }, 3686 { 3687 "distinct_range": 491.48859982531155, 3688 "num_eq": 100, 3689 "num_range": 5000, 3690 "upper_bound": "78603" 3691 }, 3692 { 3693 "distinct_range": 410.75076636763674, 3694 "num_eq": 200, 3695 "num_range": 5000, 3696 "upper_bound": "79016" 3697 }, 3698 { 3699 "distinct_range": 463.58035850425586, 3700 "num_eq": 100, 3701 "num_range": 4900, 3702 "upper_bound": "79482" 3703 }, 3704 { 3705 "distinct_range": 496.4711919288098, 3706 "num_eq": 100, 3707 "num_range": 5000, 3708 "upper_bound": "79981" 3709 }, 3710 { 3711 "distinct_range": 400.781640660362, 3712 "num_eq": 100, 3713 "num_range": 5000, 3714 "upper_bound": "80384" 3715 }, 3716 { 3717 "distinct_range": 507.43210229818044, 3718 "num_eq": 100, 3719 "num_range": 5000, 3720 "upper_bound": "80894" 3721 }, 3722 { 3723 "distinct_range": 526.3615709457474, 3724 "num_eq": 100, 3725 "num_range": 5000, 3726 "upper_bound": "81423" 3727 }, 3728 { 3729 "distinct_range": 498.46416840088375, 3730 "num_eq": 100, 3731 "num_range": 5000, 3732 "upper_bound": "81924" 3733 }, 3734 { 3735 "distinct_range": 362.89784052643785, 3736 "num_eq": 100, 3737 "num_range": 5000, 3738 "upper_bound": "82289" 3739 }, 3740 { 3741 "distinct_range": 613.9533710018293, 3742 "num_eq": 100, 3743 "num_range": 5000, 3744 "upper_bound": "82906" 3745 }, 3746 { 3747 "distinct_range": 583.1168974320403, 3748 "num_eq": 100, 3749 "num_range": 5000, 3750 "upper_bound": "83492" 3751 }, 3752 { 3753 "distinct_range": 444.64408425451427, 3754 "num_eq": 200, 3755 "num_range": 5000, 3756 "upper_bound": "83939" 3757 }, 3758 { 3759 "distinct_range": 459.59362562782314, 3760 "num_eq": 100, 3761 "num_range": 4900, 3762 "upper_bound": "84401" 3763 }, 3764 { 3765 "distinct_range": 576.1503680110648, 3766 "num_eq": 100, 3767 "num_range": 5000, 3768 "upper_bound": "84980" 3769 }, 3770 { 3771 "distinct_range": 536.3226304915322, 3772 "num_eq": 100, 3773 "num_range": 5000, 3774 "upper_bound": "85519" 3775 }, 3776 { 3777 "distinct_range": 336.97680008871856, 3778 "num_eq": 100, 3779 "num_range": 5000, 3780 "upper_bound": "85858" 3781 }, 3782 { 3783 "distinct_range": 412.74457009065026, 3784 "num_eq": 100, 3785 "num_range": 5000, 3786 "upper_bound": "86273" 3787 }, 3788 { 3789 "distinct_range": 601.025220587484, 3790 "num_eq": 100, 3791 "num_range": 5000, 3792 "upper_bound": "86877" 3793 }, 3794 { 3795 "distinct_range": 524.3691978995308, 3796 "num_eq": 100, 3797 "num_range": 5000, 3798 "upper_bound": "87404" 3799 }, 3800 { 3801 "distinct_range": 555.2444578162108, 3802 "num_eq": 100, 3803 "num_range": 5000, 3804 "upper_bound": "87962" 3805 }, 3806 { 3807 "distinct_range": 552.2572028307412, 3808 "num_eq": 100, 3809 "num_range": 5000, 3810 "upper_bound": "88517" 3811 }, 3812 { 3813 "distinct_range": 517.3955010272375, 3814 "num_eq": 100, 3815 "num_range": 5000, 3816 "upper_bound": "89037" 3817 }, 3818 { 3819 "distinct_range": 505.4392959179938, 3820 "num_eq": 100, 3821 "num_range": 5000, 3822 "upper_bound": "89545" 3823 }, 3824 { 3825 "distinct_range": 582.1217493380398, 3826 "num_eq": 100, 3827 "num_range": 5000, 3828 "upper_bound": "90130" 3829 }, 3830 { 3831 "distinct_range": 463.582712882156, 3832 "num_eq": 100, 3833 "num_range": 5000, 3834 "upper_bound": "90596" 3835 }, 3836 { 3837 "distinct_range": 501.45356531483213, 3838 "num_eq": 100, 3839 "num_range": 5000, 3840 "upper_bound": "91100" 3841 }, 3842 { 3843 "distinct_range": 546.2822239571285, 3844 "num_eq": 100, 3845 "num_range": 5000, 3846 "upper_bound": "91649" 3847 }, 3848 { 3849 "distinct_range": 674.5345195105587, 3850 "num_eq": 100, 3851 "num_range": 5000, 3852 "upper_bound": "92327" 3853 }, 3854 { 3855 "distinct_range": 510.4212351725323, 3856 "num_eq": 100, 3857 "num_range": 5000, 3858 "upper_bound": "92840" 3859 }, 3860 { 3861 "distinct_range": 605.0036496044263, 3862 "num_eq": 100, 3863 "num_range": 5000, 3864 "upper_bound": "93448" 3865 }, 3866 { 3867 "distinct_range": 588.0922722606455, 3868 "num_eq": 100, 3869 "num_range": 5000, 3870 "upper_bound": "94039" 3871 }, 3872 { 3873 "distinct_range": 489.4913643202781, 3874 "num_eq": 200, 3875 "num_range": 4900, 3876 "upper_bound": "94531" 3877 }, 3878 { 3879 "distinct_range": 404.7693110916549, 3880 "num_eq": 100, 3881 "num_range": 5000, 3882 "upper_bound": "94938" 3883 }, 3884 { 3885 "distinct_range": 516.3992109822059, 3886 "num_eq": 100, 3887 "num_range": 5000, 3888 "upper_bound": "95457" 3889 }, 3890 { 3891 "distinct_range": 577.1456557717619, 3892 "num_eq": 100, 3893 "num_range": 5000, 3894 "upper_bound": "96037" 3895 }, 3896 { 3897 "distinct_range": 392.8062296927917, 3898 "num_eq": 200, 3899 "num_range": 5000, 3900 "upper_bound": "96432" 3901 }, 3902 { 3903 "distinct_range": 511.411207020709, 3904 "num_eq": 100, 3905 "num_range": 4900, 3906 "upper_bound": "96946" 3907 }, 3908 { 3909 "distinct_range": 470.55965340984085, 3910 "num_eq": 100, 3911 "num_range": 5000, 3912 "upper_bound": "97419" 3913 }, 3914 { 3915 "distinct_range": 521.372863100691, 3916 "num_eq": 200, 3917 "num_range": 4900, 3918 "upper_bound": "97943" 3919 }, 3920 { 3921 "distinct_range": 446.6376969982989, 3922 "num_eq": 100, 3923 "num_range": 5000, 3924 "upper_bound": "98392" 3925 }, 3926 { 3927 "distinct_range": 507.43210229818044, 3928 "num_eq": 100, 3929 "num_range": 5000, 3930 "upper_bound": "98902" 3931 }, 3932 { 3933 "distinct_range": 523.3729922813708, 3934 "num_eq": 200, 3935 "num_range": 5000, 3936 "upper_bound": "99428" 3937 }, 3938 { 3939 "distinct_range": 555.2307597273716, 3940 "num_eq": 100, 3941 "num_range": 4900, 3942 "upper_bound": "99986" 3943 } 3944 ], 3945 "histo_col_type": "INT8", 3946 "name": "__auto__", 3947 "null_count": 0, 3948 "row_count": 1000000 3949 }, 3950 { 3951 "columns": [ 3952 "s_quantity" 3953 ], 3954 "created_at": "2019-07-29 14:57:08.255234+00:00", 3955 "distinct_count": 91, 3956 "histo_col_type": "", 3957 "name": "__auto__", 3958 "null_count": 0, 3959 "row_count": 1000000 3960 }, 3961 { 3962 "columns": [ 3963 "s_dist_01" 3964 ], 3965 "created_at": "2019-07-29 14:57:08.255234+00:00", 3966 "distinct_count": 62, 3967 "histo_col_type": "", 3968 "name": "__auto__", 3969 "null_count": 0, 3970 "row_count": 1000000 3971 }, 3972 { 3973 "columns": [ 3974 "s_dist_02" 3975 ], 3976 "created_at": "2019-07-29 14:57:08.255234+00:00", 3977 "distinct_count": 62, 3978 "histo_col_type": "", 3979 "name": "__auto__", 3980 "null_count": 0, 3981 "row_count": 1000000 3982 }, 3983 { 3984 "columns": [ 3985 "s_dist_03" 3986 ], 3987 "created_at": "2019-07-29 14:57:08.255234+00:00", 3988 "distinct_count": 62, 3989 "histo_col_type": "", 3990 "name": "__auto__", 3991 "null_count": 0, 3992 "row_count": 1000000 3993 }, 3994 { 3995 "columns": [ 3996 "s_dist_04" 3997 ], 3998 "created_at": "2019-07-29 14:57:08.255234+00:00", 3999 "distinct_count": 62, 4000 "histo_col_type": "", 4001 "name": "__auto__", 4002 "null_count": 0, 4003 "row_count": 1000000 4004 }, 4005 { 4006 "columns": [ 4007 "s_dist_05" 4008 ], 4009 "created_at": "2019-07-29 14:57:08.255234+00:00", 4010 "distinct_count": 62, 4011 "histo_col_type": "", 4012 "name": "__auto__", 4013 "null_count": 0, 4014 "row_count": 1000000 4015 }, 4016 { 4017 "columns": [ 4018 "s_dist_06" 4019 ], 4020 "created_at": "2019-07-29 14:57:08.255234+00:00", 4021 "distinct_count": 62, 4022 "histo_col_type": "", 4023 "name": "__auto__", 4024 "null_count": 0, 4025 "row_count": 1000000 4026 }, 4027 { 4028 "columns": [ 4029 "s_dist_07" 4030 ], 4031 "created_at": "2019-07-29 14:57:08.255234+00:00", 4032 "distinct_count": 62, 4033 "histo_col_type": "", 4034 "name": "__auto__", 4035 "null_count": 0, 4036 "row_count": 1000000 4037 }, 4038 { 4039 "columns": [ 4040 "s_dist_08" 4041 ], 4042 "created_at": "2019-07-29 14:57:08.255234+00:00", 4043 "distinct_count": 62, 4044 "histo_col_type": "", 4045 "name": "__auto__", 4046 "null_count": 0, 4047 "row_count": 1000000 4048 }, 4049 { 4050 "columns": [ 4051 "s_dist_09" 4052 ], 4053 "created_at": "2019-07-29 14:57:08.255234+00:00", 4054 "distinct_count": 62, 4055 "histo_col_type": "", 4056 "name": "__auto__", 4057 "null_count": 0, 4058 "row_count": 1000000 4059 }, 4060 { 4061 "columns": [ 4062 "s_dist_10" 4063 ], 4064 "created_at": "2019-07-29 14:57:08.255234+00:00", 4065 "distinct_count": 62, 4066 "histo_col_type": "", 4067 "name": "__auto__", 4068 "null_count": 0, 4069 "row_count": 1000000 4070 }, 4071 { 4072 "columns": [ 4073 "s_ytd" 4074 ], 4075 "created_at": "2019-07-29 14:57:08.255234+00:00", 4076 "distinct_count": 1, 4077 "histo_col_type": "", 4078 "name": "__auto__", 4079 "null_count": 0, 4080 "row_count": 1000000 4081 }, 4082 { 4083 "columns": [ 4084 "s_order_cnt" 4085 ], 4086 "created_at": "2019-07-29 14:57:08.255234+00:00", 4087 "distinct_count": 1, 4088 "histo_col_type": "", 4089 "name": "__auto__", 4090 "null_count": 0, 4091 "row_count": 1000000 4092 }, 4093 { 4094 "columns": [ 4095 "s_remote_cnt" 4096 ], 4097 "created_at": "2019-07-29 14:57:08.255234+00:00", 4098 "distinct_count": 1, 4099 "histo_col_type": "", 4100 "name": "__auto__", 4101 "null_count": 0, 4102 "row_count": 1000000 4103 }, 4104 { 4105 "columns": [ 4106 "s_data" 4107 ], 4108 "created_at": "2019-07-29 14:57:08.255234+00:00", 4109 "distinct_count": 44179, 4110 "histo_col_type": "", 4111 "name": "__auto__", 4112 "null_count": 0, 4113 "row_count": 1000000 4114 }, 4115 { 4116 "columns": [ 4117 "s_w_id", 4118 "s_i_id" 4119 ], 4120 "created_at": "2019-07-29 14:57:08.255234+00:00", 4121 "distinct_count": 1000240, 4122 "histo_col_type": "", 4123 "name": "__auto__", 4124 "null_count": 0, 4125 "row_count": 1000000 4126 } 4127 ]'; 4128 ---- 4129 4130 exec-ddl 4131 ALTER TABLE warehouse INJECT STATISTICS '[ 4132 { 4133 "columns": [ 4134 "w_id" 4135 ], 4136 "created_at": "2019-07-29 14:57:02.990989+00:00", 4137 "distinct_count": 10, 4138 "histo_buckets": [ 4139 { 4140 "distinct_range": 0, 4141 "num_eq": 1, 4142 "num_range": 0, 4143 "upper_bound": "0" 4144 }, 4145 { 4146 "distinct_range": 0, 4147 "num_eq": 1, 4148 "num_range": 0, 4149 "upper_bound": "1" 4150 }, 4151 { 4152 "distinct_range": 0, 4153 "num_eq": 1, 4154 "num_range": 0, 4155 "upper_bound": "2" 4156 }, 4157 { 4158 "distinct_range": 0, 4159 "num_eq": 1, 4160 "num_range": 0, 4161 "upper_bound": "3" 4162 }, 4163 { 4164 "distinct_range": 0, 4165 "num_eq": 1, 4166 "num_range": 0, 4167 "upper_bound": "4" 4168 }, 4169 { 4170 "distinct_range": 0, 4171 "num_eq": 1, 4172 "num_range": 0, 4173 "upper_bound": "5" 4174 }, 4175 { 4176 "distinct_range": 0, 4177 "num_eq": 1, 4178 "num_range": 0, 4179 "upper_bound": "6" 4180 }, 4181 { 4182 "distinct_range": 0, 4183 "num_eq": 1, 4184 "num_range": 0, 4185 "upper_bound": "7" 4186 }, 4187 { 4188 "distinct_range": 0, 4189 "num_eq": 1, 4190 "num_range": 0, 4191 "upper_bound": "8" 4192 }, 4193 { 4194 "distinct_range": 0, 4195 "num_eq": 1, 4196 "num_range": 0, 4197 "upper_bound": "9" 4198 } 4199 ], 4200 "histo_col_type": "INT8", 4201 "name": "__auto__", 4202 "null_count": 0, 4203 "row_count": 10 4204 }, 4205 { 4206 "columns": [ 4207 "w_name" 4208 ], 4209 "created_at": "2019-07-29 14:57:02.990989+00:00", 4210 "distinct_count": 5, 4211 "histo_col_type": "", 4212 "name": "__auto__", 4213 "null_count": 0, 4214 "row_count": 10 4215 }, 4216 { 4217 "columns": [ 4218 "w_street_1" 4219 ], 4220 "created_at": "2019-07-29 14:57:02.990989+00:00", 4221 "distinct_count": 7, 4222 "histo_col_type": "", 4223 "name": "__auto__", 4224 "null_count": 0, 4225 "row_count": 10 4226 }, 4227 { 4228 "columns": [ 4229 "w_street_2" 4230 ], 4231 "created_at": "2019-07-29 14:57:02.990989+00:00", 4232 "distinct_count": 6, 4233 "histo_col_type": "", 4234 "name": "__auto__", 4235 "null_count": 0, 4236 "row_count": 10 4237 }, 4238 { 4239 "columns": [ 4240 "w_city" 4241 ], 4242 "created_at": "2019-07-29 14:57:02.990989+00:00", 4243 "distinct_count": 8, 4244 "histo_col_type": "", 4245 "name": "__auto__", 4246 "null_count": 0, 4247 "row_count": 10 4248 }, 4249 { 4250 "columns": [ 4251 "w_state" 4252 ], 4253 "created_at": "2019-07-29 14:57:02.990989+00:00", 4254 "distinct_count": 9, 4255 "histo_col_type": "", 4256 "name": "__auto__", 4257 "null_count": 0, 4258 "row_count": 10 4259 }, 4260 { 4261 "columns": [ 4262 "w_zip" 4263 ], 4264 "created_at": "2019-07-29 14:57:02.990989+00:00", 4265 "distinct_count": 6, 4266 "histo_col_type": "", 4267 "name": "__auto__", 4268 "null_count": 0, 4269 "row_count": 10 4270 }, 4271 { 4272 "columns": [ 4273 "w_tax" 4274 ], 4275 "created_at": "2019-07-29 14:57:02.990989+00:00", 4276 "distinct_count": 10, 4277 "histo_col_type": "", 4278 "name": "__auto__", 4279 "null_count": 0, 4280 "row_count": 10 4281 }, 4282 { 4283 "columns": [ 4284 "w_ytd" 4285 ], 4286 "created_at": "2019-07-29 14:57:02.990989+00:00", 4287 "distinct_count": 1, 4288 "histo_col_type": "", 4289 "name": "__auto__", 4290 "null_count": 0, 4291 "row_count": 10 4292 } 4293 ]'; 4294 ----