QSV: PGO-optimized

gistfile1.txt

version,tstamp,name,mean,recs_per_sec,stddev,median,user,system,min,max
0.119.0,2023-11-21-00,apply_calcconv,1.552,644330,0.003,1.551,2.802,0.243,1.551,1.555
0.119.0,2023-11-21-00,apply_datefmt,1.62,617284,0.008,1.616,3.548,0.151,1.614,1.629
0.119.0,2023-11-21-00,apply_datefmt_multi,2.069,483325,0.002,2.069,6.756,0.158,2.066,2.071
0.119.0,2023-11-21-00,apply_dynfmt,1.671,598444,0.035,1.654,3.503,0.257,1.648,1.711
0.119.0,2023-11-21-00,apply_emptyreplace,1.424,702247,0.016,1.428,2.038,0.148,1.406,1.437
0.119.0,2023-11-21-00,apply_op_eudex,1.387,720981,0.002,1.387,1.618,0.311,1.385,1.388
0.119.0,2023-11-21-00,apply_op_similarity,1.447,691085,0.015,1.439,1.923,0.266,1.437,1.464
0.119.0,2023-11-21-00,apply_op_string,1.405,711744,0.001,1.405,2.043,0.147,1.405,1.406
0.119.0,2023-11-21-00,behead,0.961,1040583,0.01,0.961,0.907,0.047,0.951,0.97
0.119.0,2023-11-21-00,behead_flexible,0.954,1048218,0.001,0.954,0.905,0.046,0.954,0.955
0.119.0,2023-11-21-00,cat_columns,2.892,345781,0.004,2.891,2.79,0.096,2.89,2.896
0.119.0,2023-11-21-00,cat_rows,1.906,524659,0.005,1.904,1.808,0.092,1.903,1.912
0.119.0,2023-11-21-00,cat_rows_flexible,1.902,525762,0.001,1.901,1.805,0.092,1.901,1.902
0.119.0,2023-11-21-00,cat_rowskey,3.195,312989,0.02,3.19,3.085,0.099,3.178,3.217
0.119.0,2023-11-21-00,count,0.513,1949318,0.001,0.513,0.467,0.044,0.513,0.514
0.119.0,2023-11-21-00,count_flexible,0.514,1945525,0.001,0.514,0.467,0.044,0.514,0.515
0.119.0,2023-11-21-00,count_index,0.006,166666667,0,0.006,0.003,0.002,0.006,0.006
0.119.0,2023-11-21-00,count_width,0.508,1968504,0,0.509,0.462,0.044,0.508,0.509
0.119.0,2023-11-21-00,count_width_index,0.513,1949318,0.003,0.512,0.465,0.043,0.511,0.517
0.119.0,2023-11-21-00,dedup,1.458,685871,0.009,1.455,2.083,0.177,1.451,1.468
0.119.0,2023-11-21-00,dedup_sorted,1.114,897666,0.01,1.11,1.004,0.178,1.107,1.126
0.119.0,2023-11-21-00,diff,2.543,393236,0.031,2.527,4.344,0.299,2.524,2.579
0.119.0,2023-11-21-00,enum,0.987,1013171,0.002,0.986,0.936,0.048,0.986,0.989
0.119.0,2023-11-21-00,excel,10.893,91802,0.475,10.631,10.455,1.12,10.608,11.441
0.119.0,2023-11-21-00,exclude,0.647,1545595,0.001,0.647,0.601,0.044,0.646,0.648
0.119.0,2023-11-21-00,exclude_index,0.659,1517451,0.005,0.657,0.608,0.046,0.656,0.664
0.119.0,2023-11-21-00,explode,1.596,626566,0.003,1.597,1.542,0.05,1.593,1.599
0.119.0,2023-11-21-00,extdedup,1.149,870322,0.006,1.146,1.037,0.106,1.145,1.156
0.119.0,2023-11-21-00,extsort,0.959,1042753,0.051,0.94,1.03,0.355,0.92,1.016
0.119.0,2023-11-21-00,fill,1.619,617665,0.003,1.618,1.565,0.05,1.617,1.622
0.119.0,2023-11-21-00,fixlengths,1.489,671592,0.001,1.489,1.397,0.088,1.487,1.49
0.119.0,2023-11-21-00,flatten,6.203,161212,0.029,6.187,6.1,0.075,6.185,6.236
0.119.0,2023-11-21-00,flatten_condensed,6.431,155497,0.004,6.43,6.347,0.073,6.427,6.435
0.119.0,2023-11-21-00,fmt,0.956,1046025,0.003,0.955,0.906,0.047,0.952,0.959
0.119.0,2023-11-21-00,frequency,3.605,277393,0.024,3.6,3.464,0.129,3.584,3.631
0.119.0,2023-11-21-00,frequency_ignorecase,8.137,122895,0.042,8.136,7.966,0.155,8.095,8.179
0.119.0,2023-11-21-00,frequency_ignorecase_index,2.122,471254,0.075,2.144,9.192,0.418,2.039,2.185
0.119.0,2023-11-21-00,frequency_index,1.457,686342,0.011,1.456,4.966,0.396,1.447,1.468
0.119.0,2023-11-21-00,frequency_j1,3.599,277855,0.02,3.588,3.464,0.127,3.587,3.623
0.119.0,2023-11-21-00,frequency_j1_ignorecase,8.14,122850,0.024,8.151,7.969,0.154,8.112,8.157
0.119.0,2023-11-21-00,frequency_selregex,0.917,1090513,0.005,0.916,0.861,0.052,0.913,0.923
0.119.0,2023-11-21-00,frequency_selregex_ignorecase,2.161,462749,0.008,2.164,2.099,0.058,2.153,2.168
0.119.0,2023-11-21-00,geocode_reverse,3.914,255493,0.005,3.915,3.326,7.62,3.908,3.917
0.119.0,2023-11-21-00,geocode_suggest,5.073,197122,0.036,5.066,18.922,1.849,5.042,5.112
0.119.0,2023-11-21-00,index,0.515,1941748,0.002,0.515,0.467,0.045,0.514,0.517
0.119.0,2023-11-21-00,input,1.632,612745,0.014,1.626,1.576,0.051,1.622,1.648
0.119.0,2023-11-21-00,join,2.055,486618,0.003,2.056,1.415,0.636,2.052,2.058
0.119.0,2023-11-21-00,joinp,3.581,279252,0.058,3.558,6.293,0.692,3.537,3.647
0.119.0,2023-11-21-00,jsonl,5.942,168294,0.048,5.938,5.706,0.22,5.896,5.991
0.119.0,2023-11-21-00,luau_filter,9.28,107759,0.019,9.272,8.553,0.707,9.267,9.301
0.119.0,2023-11-21-00,luau_filter_no_globals,6.653,150308,0.003,6.654,5.93,0.708,6.65,6.656
0.119.0,2023-11-21-00,luau_filter_no_globals_no_colidx,5.15,194175,0.036,5.146,4.436,0.703,5.116,5.188
0.119.0,2023-11-21-00,luau_multi,26.51,37722,0.063,26.495,25.611,0.855,26.455,26.579
0.119.0,2023-11-21-00,luau_multi_no_globals,24.358,41054,0.681,23.986,23.439,0.847,23.943,25.144
0.119.0,2023-11-21-00,luau_multi_no_globals_no_colidx,22.472,44500,0.037,22.457,21.584,0.842,22.443,22.514
0.119.0,2023-11-21-00,luau_script,37.803,26453,0.139,37.746,36.823,0.918,37.701,37.961
0.119.0,2023-11-21-00,luau_script_no_globals,35.603,28088,0.646,35.276,34.617,0.91,35.186,36.348
0.119.0,2023-11-21-00,luau_script_no_globals_nocolidx,33.826,29563,0.05,33.806,32.852,0.897,33.788,33.883
0.119.0,2023-11-21-00,partition,1.223,817661,0.02,1.213,0.958,0.19,1.21,1.246
0.119.0,2023-11-21-00,pseudo,1.77,564972,0.015,1.764,1.698,0.067,1.76,1.787
0.119.0,2023-11-21-00,rename,1.03,970874,0.002,1.029,0.98,0.047,1.028,1.033
0.119.0,2023-11-21-00,replace,2.041,489956,0.046,2.016,1.986,0.051,2.013,2.093
0.119.0,2023-11-21-00,reverse,1.151,868810,0.006,1.149,0.981,0.164,1.146,1.158
0.119.0,2023-11-21-00,safenames,1.03,970874,0.004,1.028,0.979,0.047,1.028,1.034
0.119.0,2023-11-21-00,sample_10,0.592,1689189,0.001,0.591,0.545,0.044,0.591,0.592
0.119.0,2023-11-21-00,sample_1000,0.589,1697793,0.001,0.588,0.542,0.044,0.588,0.59
0.119.0,2023-11-21-00,sample_100000,0.777,1287001,0.001,0.777,0.717,0.057,0.776,0.778
0.119.0,2023-11-21-00,sample_100000_index,1.325,754717,0.018,1.334,0.208,1.11,1.304,1.338
0.119.0,2023-11-21-00,sample_100000_seeded,0.779,1283697,0.005,0.779,0.716,0.056,0.774,0.785
0.119.0,2023-11-21-00,sample_100000_seeded_faster,0.76,1315789,0.002,0.76,0.699,0.058,0.759,0.762
0.119.0,2023-11-21-00,sample_100000_seeded_index,1.311,762777,0.026,1.305,0.205,1.095,1.288,1.339
0.119.0,2023-11-21-00,sample_100000_seeded_index_faster,1.266,789889,0.022,1.255,0.198,1.052,1.251,1.292
0.119.0,2023-11-21-00,sample_1000_index,0.034,29411765,0.001,0.034,0.018,0.014,0.033,0.035
0.119.0,2023-11-21-00,sample_10_index,0.022,45454545,0,0.022,0.016,0.004,0.021,0.022
0.119.0,2023-11-21-00,sample_25pct_index,3.223,310270,0.019,3.233,0.488,2.72,3.2,3.234
0.119.0,2023-11-21-00,sample_25pct_seeded_index,3.253,307409,0.115,3.253,0.487,2.723,3.138,3.369
0.119.0,2023-11-21-00,schema,17.403,57461,0.055,17.434,26.936,1.439,17.339,17.435
0.119.0,2023-11-21-00,schema_index,8.221,121640,0.034,8.217,13.202,0.599,8.189,8.258
0.119.0,2023-11-21-00,search,0.652,1533742,0.001,0.652,0.605,0.044,0.651,0.654
0.119.0,2023-11-21-00,search_unicode,0.654,1529052,0.003,0.652,0.606,0.045,0.652,0.658
0.119.0,2023-11-21-00,searchset,1.712,584112,0.001,1.712,1.619,0.089,1.711,1.712
0.119.0,2023-11-21-00,searchset_ignorecase,2,500000,0.007,1.998,1.904,0.091,1.994,2.007
0.119.0,2023-11-21-00,searchset_unicode,1.711,584454,0.005,1.713,1.616,0.089,1.705,1.715
0.119.0,2023-11-21-00,select,0.542,1845018,0.001,0.542,0.496,0.044,0.542,0.543
0.119.0,2023-11-21-00,select_regex,0.58,1724138,0.008,0.576,0.53,0.046,0.574,0.589
0.119.0,2023-11-21-00,slice_one_middle,0.29,3448276,0.001,0.29,0.265,0.023,0.29,0.292
0.119.0,2023-11-21-00,slice_one_middle_index,0.007,142857143,0,0.007,0.004,0.002,0.007,0.007
0.119.0,2023-11-21-00,snappy_compress,0.245,4081633,0.012,0.251,1.192,0.141,0.232,0.253
0.119.0,2023-11-21-00,snappy_decompress,0.557,1795332,0.044,0.531,0.508,0.021,0.53,0.608
0.119.0,2023-11-21-00,snappy_validate,0.517,1934236,0.004,0.517,0.495,0.02,0.513,0.522
0.119.0,2023-11-21-00,sort,1.445,692042,0.006,1.448,2.082,0.182,1.438,1.449
0.119.0,2023-11-21-00,sort_random_seeded,1.394,717360,0.027,1.392,1.214,0.171,1.368,1.422
0.119.0,2023-11-21-00,sortcheck_sorted,0.554,1805054,0.001,0.553,0.508,0.044,0.553,0.554
0.119.0,2023-11-21-00,sortcheck_unsorted,0.006,166666667,0,0.006,0.004,0.002,0.006,0.007
0.119.0,2023-11-21-00,sortcheck_unsorted_all,0.593,1686341,0.003,0.592,0.545,0.045,0.59,0.596
0.119.0,2023-11-21-00,split,1.192,838926,0.031,1.203,0.916,0.188,1.156,1.215
0.119.0,2023-11-21-00,split_index,0.324,3086420,0.019,0.319,1.075,0.382,0.308,0.345
0.119.0,2023-11-21-00,split_index_j1,1.235,809717,0.024,1.229,0.987,0.207,1.215,1.262
0.119.0,2023-11-21-00,sqlp,2.976,336022,0.014,2.978,4.027,0.289,2.961,2.988
0.119.0,2023-11-21-00,sqlp_format_arrow,2.983,335233,0.017,2.993,4.031,0.297,2.964,2.993
0.119.0,2023-11-21-00,sqlp_format_json,2.987,334784,0.01,2.986,4.01,0.299,2.977,2.997
0.119.0,2023-11-21-00,sqlp_format_parquet,3.068,325945,0.056,3.1,4.024,0.339,3.004,3.101
0.119.0,2023-11-21-00,sqlp_format_parquet_statistics,3.052,327654,0.025,3.063,3.997,0.3,3.023,3.069
0.119.0,2023-11-21-00,sqlp_lowmemory,3.171,315358,0.099,3.171,4.053,0.181,3.071,3.269
0.119.0,2023-11-21-00,sqlp_nooptimizations,3.045,328407,0.037,3.05,4.014,0.338,3.007,3.079
0.119.0,2023-11-21-00,sqlp_tryparsedates,48.874,20461,0.073,48.845,48.501,0.249,48.82,48.957
0.119.0,2023-11-21-00,sqlp_tryparsedates_inferlen,0.51,1960784,0.001,0.509,0.498,0.015,0.509,0.511
0.119.0,2023-11-21-00,stats,2.045,488998,0.01,2.045,1.947,0.093,2.035,2.055
0.119.0,2023-11-21-00,stats_create_cache,2.04,490196,0.002,2.039,1.944,0.093,2.038,2.043
0.119.0,2023-11-21-00,stats_everything,4.239,235905,0.081,4.197,10.55,0.576,4.188,4.333
0.119.0,2023-11-21-00,stats_everything_create_cache,4.153,240790,0.033,4.144,10.375,0.551,4.125,4.189
0.119.0,2023-11-21-00,stats_everything_index,2.094,477555,0.179,2.108,10.819,0.767,1.909,2.265
0.119.0,2023-11-21-00,stats_everything_index_j1,8.749,114299,0.135,8.703,8.619,0.38,8.644,8.902
0.119.0,2023-11-21-00,stats_everything_index_j1_with_cache,0.007,142857143,0,0.007,0.004,0.002,0.007,0.007
0.119.0,2023-11-21-00,stats_everything_index_with_cache,0.007,142857143,0,0.007,0.004,0.002,0.007,0.007
0.119.0,2023-11-21-00,stats_everything_infer_dates,7.988,125188,0.129,7.942,14.851,0.645,7.888,8.134
0.119.0,2023-11-21-00,stats_everything_infer_dates_index,2.832,353107,0.113,2.857,15.571,0.933,2.708,2.93
0.119.0,2023-11-21-00,stats_everything_infer_dates_index_with_cache,0.008,125000000,0.001,0.008,0.004,0.002,0.007,0.009
0.119.0,2023-11-21-00,stats_everything_j1,8.876,112663,0.501,8.971,8.67,0.449,8.335,9.323
0.119.0,2023-11-21-00,stats_index,0.286,3496503,0.005,0.288,1.773,0.062,0.281,0.289
0.119.0,2023-11-21-00,stats_index_j1,1.542,648508,0.003,1.543,1.494,0.044,1.539,1.544
0.119.0,2023-11-21-00,stats_index_j1_with_cache,0.007,142857143,0,0.007,0.004,0.002,0.007,0.007
0.119.0,2023-11-21-00,stats_index_with_cache,0.007,142857143,0.001,0.007,0.004,0.002,0.006,0.007
0.119.0,2023-11-21-00,table,8.502,117619,0.165,8.419,7.164,1.29,8.395,8.692
0.119.0,2023-11-21-00,to_datapackage,0.813,1230012,0.014,0.812,1.912,0.262,0.8,0.827
0.119.0,2023-11-21-00,to_parquet,0.007,142857143,0,0.007,0.004,0.002,0.007,0.007
0.119.0,2023-11-21-00,to_sqlite,0.808,1237624,0.004,0.811,1.924,0.263,0.803,0.811
0.119.0,2023-11-21-00,to_xlsx,37.351,26773,0.454,37.128,33.36,4.225,37.051,37.873
0.119.0,2023-11-21-00,tojsonl,17.297,57813,0.633,17.441,25.125,0.866,16.605,17.846
0.119.0,2023-11-21-00,tojsonl_index,13.324,75053,0.393,13.396,28.274,1.339,12.9,13.675
0.119.0,2023-11-21-00,tojsonl_index_j1,25.952,38533,0.12,25.988,24.983,0.882,25.818,26.049
0.119.0,2023-11-21-00,tojsonl_j1,24.599,40652,0.318,24.475,23.712,0.79,24.361,24.96
0.119.0,2023-11-21-00,transpose,2.748,363901,0.027,2.76,2.344,0.347,2.716,2.767
0.119.0,2023-11-21-00,transpose_multipass,24.167,41379,0.098,24.12,22.143,1.921,24.1,24.28
0.119.0,2023-11-21-00,validate,2.075,481928,0.019,2.069,7.441,0.122,2.059,2.097
0.119.0,2023-11-21-00,validate_index,1.963,509424,0.006,1.96,7.486,0.105,1.958,1.97
0.119.0,2023-11-21-00,validate_no_schema,0.619,1615509,0.007,0.619,0.566,0.048,0.612,0.625
0.119.0,2023-11-21-00,validate_no_schema_index,0.622,1607717,0.005,0.621,0.566,0.052,0.618,0.628