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

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