github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/testutils/opttester/testfixtures/tpcc_stats_w100 (about)

     1  # Stats for TPC-C with 100 warehouses, collected soon after the initial data
     2  # import.
     3  
     4  exec-ddl
     5  ALTER TABLE warehouse INJECT STATISTICS '[
     6    {
     7      "columns": ["w_id"],
     8      "distinct_count": 100,
     9      "null_count": 0,
    10      "row_count": 100,
    11      "created_at": "2018-01-01 1:00:00.00000+00:00"
    12    },
    13    {
    14      "columns": ["w_name"],
    15      "distinct_count": 5,
    16      "null_count": 0,
    17      "row_count": 100,
    18      "created_at": "2018-01-01 1:00:00.00000+00:00"
    19    },
    20    {
    21      "columns": ["w_street_1"],
    22      "distinct_count": 11,
    23      "null_count": 0,
    24      "row_count": 100,
    25      "created_at": "2018-01-01 1:00:00.00000+00:00"
    26    },
    27    {
    28      "columns": ["w_street_2"],
    29      "distinct_count": 11,
    30      "null_count": 0,
    31      "row_count": 100,
    32      "created_at": "2018-01-01 1:00:00.00000+00:00"
    33    },
    34    {
    35      "columns": ["w_city"],
    36      "distinct_count": 11,
    37      "null_count": 0,
    38      "row_count": 100,
    39      "created_at": "2018-01-01 1:00:00.00000+00:00"
    40    },
    41    {
    42      "columns": ["w_state"],
    43      "distinct_count": 92,
    44      "null_count": 0,
    45      "row_count": 100,
    46      "created_at": "2018-01-01 1:00:00.00000+00:00"
    47    },
    48    {
    49      "columns": ["w_zip"],
    50      "distinct_count": 100,
    51      "null_count": 0,
    52      "row_count": 100,
    53      "created_at": "2018-01-01 1:00:00.00000+00:00"
    54    },
    55    {
    56      "columns": ["w_tax"],
    57      "distinct_count": 100,
    58      "null_count": 0,
    59      "row_count": 100,
    60      "created_at": "2018-01-01 1:00:00.00000+00:00"
    61    },
    62    {
    63      "columns": ["w_ytd"],
    64      "distinct_count": 1,
    65      "null_count": 0,
    66      "row_count": 100,
    67      "created_at": "2018-01-01 1:00:00.00000+00:00"
    68    }
    69  ]'
    70  ----
    71  
    72  exec-ddl
    73  ALTER TABLE district INJECT STATISTICS '[
    74    {
    75      "columns": ["d_id"],
    76      "distinct_count": 10,
    77      "null_count": 0,
    78      "row_count": 1000,
    79      "created_at": "2018-01-01 1:00:00.00000+00:00"
    80    },
    81    {
    82      "columns": ["d_w_id"],
    83      "distinct_count": 100,
    84      "null_count": 0,
    85      "row_count": 1000,
    86      "created_at": "2018-01-01 1:00:00.00000+00:00"
    87    },
    88    {
    89      "columns": ["d_name"],
    90      "distinct_count": 1000,
    91      "null_count": 0,
    92      "row_count": 1000,
    93      "created_at": "2018-01-01 1:00:00.00000+00:00"
    94    },
    95    {
    96      "columns": ["d_street_1"],
    97      "distinct_count": 1000,
    98      "null_count": 0,
    99      "row_count": 1000,
   100      "created_at": "2018-01-01 1:00:00.00000+00:00"
   101    },
   102    {
   103      "columns": ["d_street_2"],
   104      "distinct_count": 1000,
   105      "null_count": 0,
   106      "row_count": 1000,
   107      "created_at": "2018-01-01 1:00:00.00000+00:00"
   108    },
   109    {
   110      "columns": ["d_city"],
   111      "distinct_count": 1000,
   112      "null_count": 0,
   113      "row_count": 1000,
   114      "created_at": "2018-01-01 1:00:00.00000+00:00"
   115    },
   116    {
   117      "columns": ["d_state"],
   118      "distinct_count": 506,
   119      "null_count": 0,
   120      "row_count": 1000,
   121      "created_at": "2018-01-01 1:00:00.00000+00:00"
   122    },
   123    {
   124      "columns": ["d_zip"],
   125      "distinct_count": 951,
   126      "null_count": 0,
   127      "row_count": 1000,
   128      "created_at": "2018-01-01 1:00:00.00000+00:00"
   129    },
   130    {
   131      "columns": ["d_tax"],
   132      "distinct_count": 780,
   133      "null_count": 0,
   134      "row_count": 1000,
   135      "created_at": "2018-01-01 1:00:00.00000+00:00"
   136    },
   137    {
   138      "columns": ["d_ytd"],
   139      "distinct_count": 1,
   140      "null_count": 0,
   141      "row_count": 1000,
   142      "created_at": "2018-01-01 1:00:00.00000+00:00"
   143    },
   144    {
   145      "columns": ["d_next_o_id"],
   146      "distinct_count": 1,
   147      "null_count": 0,
   148      "row_count": 1000,
   149      "created_at": "2018-01-01 1:00:00.00000+00:00"
   150    }
   151  ]'
   152  ----
   153  
   154  exec-ddl
   155  ALTER TABLE customer INJECT STATISTICS '[
   156    {
   157      "columns": ["c_id"],
   158      "distinct_count": 3000,
   159      "null_count": 0,
   160      "row_count": 3000000,
   161      "created_at": "2018-01-01 1:00:00.00000+00:00"
   162    },
   163    {
   164      "columns": ["c_d_id"],
   165      "distinct_count": 10,
   166      "null_count": 0,
   167      "row_count": 3000000,
   168      "created_at": "2018-01-01 1:00:00.00000+00:00"
   169    },
   170    {
   171      "columns": ["c_w_id"],
   172      "distinct_count": 100,
   173      "null_count": 0,
   174      "row_count": 3000000,
   175      "created_at": "2018-01-01 1:00:00.00000+00:00"
   176    },
   177    {
   178      "columns": ["c_first"],
   179      "distinct_count": 3024712,
   180      "null_count": 0,
   181      "row_count": 3000000,
   182      "created_at": "2018-01-01 1:00:00.00000+00:00"
   183    },
   184    {
   185      "columns": ["c_middle"],
   186      "distinct_count": 1,
   187      "null_count": 0,
   188      "row_count": 3000000,
   189      "created_at": "2018-01-01 1:00:00.00000+00:00"
   190    },
   191    {
   192      "columns": ["c_last"],
   193      "distinct_count": 1000,
   194      "null_count": 0,
   195      "row_count": 3000000,
   196      "created_at": "2018-01-01 1:00:00.00000+00:00"
   197    },
   198    {
   199      "columns": ["c_street_1"],
   200      "distinct_count": 3007563,
   201      "null_count": 0,
   202      "row_count": 3000000,
   203      "created_at": "2018-01-01 1:00:00.00000+00:00"
   204    },
   205    {
   206      "columns": ["c_street_2"],
   207      "distinct_count": 3000445,
   208      "null_count": 0,
   209      "row_count": 3000000,
   210      "created_at": "2018-01-01 1:00:00.00000+00:00"
   211    },
   212    {
   213      "columns": ["c_city"],
   214      "distinct_count": 2994387,
   215      "null_count": 0,
   216      "row_count": 3000000,
   217      "created_at": "2018-01-01 1:00:00.00000+00:00"
   218    },
   219    {
   220      "columns": ["c_state"],
   221      "distinct_count": 676,
   222      "null_count": 0,
   223      "row_count": 3000000,
   224      "created_at": "2018-01-01 1:00:00.00000+00:00"
   225    },
   226    {
   227      "columns": ["c_zip"],
   228      "distinct_count": 10018,
   229      "null_count": 0,
   230      "row_count": 3000000,
   231      "created_at": "2018-01-01 1:00:00.00000+00:00"
   232    },
   233    {
   234      "columns": ["c_phone"],
   235      "distinct_count": 2972913,
   236      "null_count": 0,
   237      "row_count": 3000000,
   238      "created_at": "2018-01-01 1:00:00.00000+00:00"
   239    },
   240    {
   241      "columns": ["c_since"],
   242      "distinct_count": 1,
   243      "null_count": 0,
   244      "row_count": 3000000,
   245      "created_at": "2018-01-01 1:00:00.00000+00:00"
   246    },
   247    {
   248      "columns": ["c_credit"],
   249      "distinct_count": 2,
   250      "null_count": 0,
   251      "row_count": 3000000,
   252      "created_at": "2018-01-01 1:00:00.00000+00:00"
   253    },
   254    {
   255      "columns": ["c_credit_lim"],
   256      "distinct_count": 1,
   257      "null_count": 0,
   258      "row_count": 3000000,
   259      "created_at": "2018-01-01 1:00:00.00000+00:00"
   260    },
   261    {
   262      "columns": ["c_discount"],
   263      "distinct_count": 5000,
   264      "null_count": 0,
   265      "row_count": 3000000,
   266      "created_at": "2018-01-01 1:00:00.00000+00:00"
   267    },
   268    {
   269      "columns": ["c_balance"],
   270      "distinct_count": 1,
   271      "null_count": 0,
   272      "row_count": 3000000,
   273      "created_at": "2018-01-01 1:00:00.00000+00:00"
   274    },
   275    {
   276      "columns": ["c_ytd_payment"],
   277      "distinct_count": 1,
   278      "null_count": 0,
   279      "row_count": 3000000,
   280      "created_at": "2018-01-01 1:00:00.00000+00:00"
   281    },
   282    {
   283      "columns": ["c_payment_cnt"],
   284      "distinct_count": 1,
   285      "null_count": 0,
   286      "row_count": 3000000,
   287      "created_at": "2018-01-01 1:00:00.00000+00:00"
   288    },
   289    {
   290      "columns": ["c_delivery_cnt"],
   291      "distinct_count": 1,
   292      "null_count": 0,
   293      "row_count": 3000000,
   294      "created_at": "2018-01-01 1:00:00.00000+00:00"
   295    },
   296    {
   297      "columns": ["c_data"],
   298      "distinct_count": 2967420,
   299      "null_count": 0,
   300      "row_count": 3000000,
   301      "created_at": "2018-01-01 1:00:00.00000+00:00"
   302    }
   303  ]'
   304  ----
   305  
   306  exec-ddl
   307  ALTER TABLE history INJECT STATISTICS '[
   308    {
   309      "columns": ["rowid"],
   310      "distinct_count": 2985531,
   311      "null_count": 0,
   312      "row_count": 3000000,
   313      "created_at": "2018-01-01 1:00:00.00000+00:00"
   314    },
   315    {
   316      "columns": ["h_c_id"],
   317      "distinct_count": 3000,
   318      "null_count": 0,
   319      "row_count": 3000000,
   320      "created_at": "2018-01-01 1:00:00.00000+00:00"
   321    },
   322    {
   323      "columns": ["h_c_d_id"],
   324      "distinct_count": 10,
   325      "null_count": 0,
   326      "row_count": 3000000,
   327      "created_at": "2018-01-01 1:00:00.00000+00:00"
   328    },
   329    {
   330      "columns": ["h_c_w_id"],
   331      "distinct_count": 100,
   332      "null_count": 0,
   333      "row_count": 3000000,
   334      "created_at": "2018-01-01 1:00:00.00000+00:00"
   335    },
   336    {
   337      "columns": ["h_d_id"],
   338      "distinct_count": 10,
   339      "null_count": 0,
   340      "row_count": 3000000,
   341      "created_at": "2018-01-01 1:00:00.00000+00:00"
   342    },
   343    {
   344      "columns": ["h_w_id"],
   345      "distinct_count": 100,
   346      "null_count": 0,
   347      "row_count": 3000000,
   348      "created_at": "2018-01-01 1:00:00.00000+00:00"
   349    },
   350    {
   351      "columns": ["h_date"],
   352      "distinct_count": 1,
   353      "null_count": 0,
   354      "row_count": 3000000,
   355      "created_at": "2018-01-01 1:00:00.00000+00:00"
   356    },
   357    {
   358      "columns": ["h_amount"],
   359      "distinct_count": 1,
   360      "null_count": 0,
   361      "row_count": 3000000,
   362      "created_at": "2018-01-01 1:00:00.00000+00:00"
   363    },
   364    {
   365      "columns": ["h_data"],
   366      "distinct_count": 2979454,
   367      "null_count": 0,
   368      "row_count": 3000000,
   369      "created_at": "2018-01-01 1:00:00.00000+00:00"
   370    }
   371  ]'
   372  ----
   373  
   374  exec-ddl
   375  ALTER TABLE "order" INJECT STATISTICS '[
   376    {
   377      "columns": ["o_id"],
   378      "distinct_count": 3000,
   379      "null_count": 0,
   380      "row_count": 3000000,
   381      "created_at": "2018-01-01 1:00:00.00000+00:00"
   382    },
   383    {
   384      "columns": ["o_d_id"],
   385      "distinct_count": 10,
   386      "null_count": 0,
   387      "row_count": 3000000,
   388      "created_at": "2018-01-01 1:00:00.00000+00:00"
   389    },
   390    {
   391      "columns": ["o_w_id"],
   392      "distinct_count": 100,
   393      "null_count": 0,
   394      "row_count": 3000000,
   395      "created_at": "2018-01-01 1:00:00.00000+00:00"
   396    },
   397    {
   398      "columns": ["o_c_id"],
   399      "distinct_count": 3000,
   400      "null_count": 0,
   401      "row_count": 3000000,
   402      "created_at": "2018-01-01 1:00:00.00000+00:00"
   403    },
   404    {
   405      "columns": ["o_entry_d"],
   406      "distinct_count": 1,
   407      "null_count": 0,
   408      "row_count": 3000000,
   409      "created_at": "2018-01-01 1:00:00.00000+00:00"
   410    },
   411    {
   412      "columns": ["o_carrier_id"],
   413      "distinct_count": 10,
   414      "null_count": 900000,
   415      "row_count": 3000000,
   416      "created_at": "2018-01-01 1:00:00.00000+00:00"
   417    },
   418    {
   419      "columns": ["o_ol_cnt"],
   420      "distinct_count": 11,
   421      "null_count": 0,
   422      "row_count": 3000000,
   423      "created_at": "2018-01-01 1:00:00.00000+00:00"
   424    },
   425    {
   426      "columns": ["o_all_local"],
   427      "distinct_count": 1,
   428      "null_count": 0,
   429      "row_count": 3000000,
   430      "created_at": "2018-01-01 1:00:00.00000+00:00"
   431    }
   432  ]'
   433  ----
   434  
   435  exec-ddl
   436  ALTER TABLE new_order INJECT STATISTICS '[
   437      {
   438      "columns": ["no_o_id"],
   439      "distinct_count": 900,
   440      "null_count": 0,
   441      "row_count": 900000,
   442      "created_at": "2018-01-01 1:00:00.00000+00:00"
   443    },
   444    {
   445      "columns": ["no_d_id"],
   446      "distinct_count": 10,
   447      "null_count": 0,
   448      "row_count": 900000,
   449      "created_at": "2018-01-01 1:00:00.00000+00:00"
   450    },
   451    {
   452      "columns": ["no_w_id"],
   453      "distinct_count": 100,
   454      "null_count": 0,
   455      "row_count": 900000,
   456      "created_at": "2018-01-01 1:00:00.00000+00:00"
   457    }
   458  ]'
   459  ----
   460  
   461  exec-ddl
   462  ALTER TABLE item INJECT STATISTICS '[
   463    {
   464      "columns": ["i_id"],
   465      "distinct_count": 101273,
   466      "null_count": 0,
   467      "row_count": 100000,
   468      "created_at": "2018-01-01 1:00:00.00000+00:00"
   469    },
   470    {
   471      "columns": ["i_im_id"],
   472      "distinct_count": 10032,
   473      "null_count": 0,
   474      "row_count": 100000,
   475      "created_at": "2018-01-01 1:00:00.00000+00:00"
   476    },
   477    {
   478      "columns": ["i_name"],
   479      "distinct_count": 98749,
   480      "null_count": 0,
   481      "row_count": 100000,
   482      "created_at": "2018-01-01 1:00:00.00000+00:00"
   483    },
   484    {
   485      "columns": ["i_price"],
   486      "distinct_count": 9855,
   487      "null_count": 0,
   488      "row_count": 100000,
   489      "created_at": "2018-01-01 1:00:00.00000+00:00"
   490    },
   491    {
   492      "columns": ["i_data"],
   493      "distinct_count": 98582,
   494      "null_count": 0,
   495      "row_count": 100000,
   496      "created_at": "2018-01-01 1:00:00.00000+00:00"
   497    }
   498  ]'
   499  ----
   500  
   501  exec-ddl
   502  ALTER TABLE stock INJECT STATISTICS '[
   503    {
   504      "columns": ["s_i_id"],
   505      "distinct_count": 101273,
   506      "null_count": 0,
   507      "row_count": 10000000,
   508      "created_at": "2018-01-01 1:00:00.00000+00:00"
   509    },
   510    {
   511      "columns": ["s_w_id"],
   512      "distinct_count": 100,
   513      "null_count": 0,
   514      "row_count": 10000000,
   515      "created_at": "2018-01-01 1:00:00.00000+00:00"
   516    },
   517    {
   518      "columns": ["s_quantity"],
   519      "distinct_count": 91,
   520      "null_count": 0,
   521      "row_count": 10000000,
   522      "created_at": "2018-01-01 1:00:00.00000+00:00"
   523    },
   524    {
   525      "columns": ["s_dist_01"],
   526      "distinct_count": 10147435,
   527      "null_count": 0,
   528      "row_count": 10000000,
   529      "created_at": "2018-01-01 1:00:00.00000+00:00"
   530    },
   531    {
   532      "columns": ["s_dist_02"],
   533      "distinct_count": 9896785,
   534      "null_count": 0,
   535      "row_count": 10000000,
   536      "created_at": "2018-01-01 1:00:00.00000+00:00"
   537    },
   538    {
   539      "columns": ["s_dist_03"],
   540      "distinct_count": 9932517,
   541      "null_count": 0,
   542      "row_count": 10000000,
   543      "created_at": "2018-01-01 1:00:00.00000+00:00"
   544    },
   545    {
   546      "columns": ["s_dist_04"],
   547      "distinct_count": 10048131,
   548      "null_count": 0,
   549      "row_count": 10000000,
   550      "created_at": "2018-01-01 1:00:00.00000+00:00"
   551    },
   552    {
   553      "columns": ["s_dist_05"],
   554      "distinct_count": 10045535,
   555      "null_count": 0,
   556      "row_count": 10000000,
   557      "created_at": "2018-01-01 1:00:00.00000+00:00"
   558    },
   559    {
   560      "columns": ["s_dist_06"],
   561      "distinct_count": 9801428,
   562      "null_count": 0,
   563      "row_count": 10000000,
   564      "created_at": "2018-01-01 1:00:00.00000+00:00"
   565    },
   566    {
   567      "columns": ["s_dist_07"],
   568      "distinct_count": 10074492,
   569      "null_count": 0,
   570      "row_count": 10000000,
   571      "created_at": "2018-01-01 1:00:00.00000+00:00"
   572    },
   573    {
   574      "columns": ["s_dist_08"],
   575      "distinct_count": 9943047,
   576      "null_count": 0,
   577      "row_count": 10000000,
   578      "created_at": "2018-01-01 1:00:00.00000+00:00"
   579    },
   580    {
   581      "columns": ["s_dist_09"],
   582      "distinct_count": 10001651,
   583      "null_count": 0,
   584      "row_count": 10000000,
   585      "created_at": "2018-01-01 1:00:00.00000+00:00"
   586    },
   587    {
   588      "columns": ["s_dist_10"],
   589      "distinct_count": 10097341,
   590      "null_count": 0,
   591      "row_count": 10000000,
   592      "created_at": "2018-01-01 1:00:00.00000+00:00"
   593    },
   594    {
   595      "columns": ["s_ytd"],
   596      "distinct_count": 1,
   597      "null_count": 0,
   598      "row_count": 10000000,
   599      "created_at": "2018-01-01 1:00:00.00000+00:00"
   600    },
   601    {
   602      "columns": ["s_order_cnt"],
   603      "distinct_count": 1,
   604      "null_count": 0,
   605      "row_count": 10000000,
   606      "created_at": "2018-01-01 1:00:00.00000+00:00"
   607    },
   608    {
   609      "columns": ["s_remote_cnt"],
   610      "distinct_count": 1,
   611      "null_count": 0,
   612      "row_count": 10000000,
   613      "created_at": "2018-01-01 1:00:00.00000+00:00"
   614    },
   615    {
   616      "columns": ["s_data"],
   617      "distinct_count": 10151633,
   618      "null_count": 0,
   619      "row_count": 10000000,
   620      "created_at": "2018-01-01 1:00:00.00000+00:00"
   621    }
   622  ]'
   623  ----
   624  
   625  exec-ddl
   626  ALTER TABLE order_line INJECT STATISTICS '[
   627    {
   628      "columns": ["ol_o_id"],
   629      "distinct_count": 3000,
   630      "null_count": 0,
   631      "row_count": 30005985,
   632      "created_at": "2018-01-01 1:00:00.00000+00:00"
   633    },
   634    {
   635      "columns": ["ol_d_id"],
   636      "distinct_count": 10,
   637      "null_count": 0,
   638      "row_count": 30005985,
   639      "created_at": "2018-01-01 1:00:00.00000+00:00"
   640    },
   641    {
   642      "columns": ["ol_w_id"],
   643      "distinct_count": 100,
   644      "null_count": 0,
   645      "row_count": 30005985,
   646      "created_at": "2018-01-01 1:00:00.00000+00:00"
   647    },
   648    {
   649      "columns": ["ol_number"],
   650      "distinct_count": 15,
   651      "null_count": 0,
   652      "row_count": 30005985,
   653      "created_at": "2018-01-01 1:00:00.00000+00:00"
   654    },
   655    {
   656      "columns": ["ol_i_id"],
   657      "distinct_count": 101273,
   658      "null_count": 0,
   659      "row_count": 30005985,
   660      "created_at": "2018-01-01 1:00:00.00000+00:00"
   661    },
   662    {
   663      "columns": ["ol_supply_w_id"],
   664      "distinct_count": 100,
   665      "null_count": 0,
   666      "row_count": 30005985,
   667      "created_at": "2018-01-01 1:00:00.00000+00:00"
   668    },
   669    {
   670      "columns": ["ol_delivery_d"],
   671      "distinct_count": 1,
   672      "null_count": 9003667,
   673      "row_count": 30005985,
   674      "created_at": "2018-01-01 1:00:00.00000+00:00"
   675    },
   676    {
   677      "columns": ["ol_quantity"],
   678      "distinct_count": 1,
   679      "null_count": 0,
   680      "row_count": 30005985,
   681      "created_at": "2018-01-01 1:00:00.00000+00:00"
   682    },
   683    {
   684      "columns": ["ol_amount"],
   685      "distinct_count": 988202,
   686      "null_count": 0,
   687      "row_count": 30005985,
   688      "created_at": "2018-01-01 1:00:00.00000+00:00"
   689    },
   690    {
   691      "columns": ["ol_dist_info"],
   692      "distinct_count": 30179646,
   693      "null_count": 0,
   694      "row_count": 30005985,
   695      "created_at": "2018-01-01 1:00:00.00000+00:00"
   696    }
   697  ]'
   698  ----