Skip to content

Instantly share code, notes, and snippets.

@zamazan4ik
Created November 21, 2023 18:56
Show Gist options
  • Save zamazan4ik/f166967f12ad27a2bf4253975c2e1907 to your computer and use it in GitHub Desktop.
Save zamazan4ik/f166967f12ad27a2bf4253975c2e1907 to your computer and use it in GitHub Desktop.
QSV: Release + LTO
version,tstamp,name,mean,recs_per_sec,stddev,median,user,system,min,max
0.119.0,2023-11-20-21,apply_calcconv,1.633,612370,0.007,1.63,2.775,0.242,1.628,1.64
0.119.0,2023-11-20-21,apply_datefmt,1.771,564653,0.012,1.764,3.917,0.156,1.764,1.785
0.119.0,2023-11-20-21,apply_datefmt_multi,2.321,430849,0.012,2.324,7.657,0.166,2.308,2.332
0.119.0,2023-11-20-21,apply_dynfmt,1.771,564653,0.07,1.734,3.435,0.269,1.727,1.851
0.119.0,2023-11-20-21,apply_emptyreplace,1.532,652742,0.013,1.533,2.208,0.153,1.518,1.544
0.119.0,2023-11-20-21,apply_op_eudex,1.497,668003,0.031,1.488,1.696,0.31,1.471,1.532
0.119.0,2023-11-20-21,apply_op_similarity,1.64,609756,0.087,1.685,2.013,0.284,1.54,1.696
0.119.0,2023-11-20-21,apply_op_string,1.552,644330,0.03,1.56,2.23,0.161,1.518,1.577
0.119.0,2023-11-20-21,behead,0.991,1009082,0.009,0.993,0.935,0.051,0.981,0.999
0.119.0,2023-11-20-21,behead_flexible,0.976,1024590,0.002,0.975,0.929,0.046,0.975,0.979
0.119.0,2023-11-20-21,cat_columns,3.152,317259,0.012,3.149,3.049,0.097,3.141,3.165
0.119.0,2023-11-20-21,cat_rows,1.989,502765,0.034,1.986,1.864,0.103,1.958,2.025
0.119.0,2023-11-20-21,cat_rows_flexible,2,500000,0.063,1.983,1.86,0.104,1.948,2.07
0.119.0,2023-11-20-21,cat_rowskey,3.32,301205,0.014,3.318,3.204,0.101,3.306,3.335
0.119.0,2023-11-20-21,count,0.512,1953125,0.001,0.511,0.468,0.043,0.511,0.513
0.119.0,2023-11-20-21,count_flexible,0.511,1956947,0.001,0.511,0.467,0.042,0.51,0.512
0.119.0,2023-11-20-21,count_index,0.006,166666667,0,0.006,0.004,0.002,0.006,0.007
0.119.0,2023-11-20-21,count_width,0.513,1949318,0.002,0.512,0.464,0.046,0.512,0.515
0.119.0,2023-11-20-21,count_width_index,0.537,1862197,0.024,0.526,0.473,0.047,0.52,0.564
0.119.0,2023-11-20-21,dedup,1.689,592066,0.04,1.709,3.252,0.184,1.643,1.715
0.119.0,2023-11-20-21,dedup_sorted,1.14,877193,0.001,1.141,1.035,0.165,1.14,1.141
0.119.0,2023-11-20-21,diff,3.414,292912,0.007,3.41,5.274,0.276,3.41,3.422
0.119.0,2023-11-20-21,enum,1.01,990099,0.001,1.01,0.96,0.048,1.009,1.01
0.119.0,2023-11-20-21,excel,14.064,71104,0.625,14.273,12.972,1.508,13.361,14.557
0.119.0,2023-11-20-21,exclude,0.66,1515152,0.001,0.659,0.613,0.045,0.659,0.661
0.119.0,2023-11-20-21,exclude_index,0.667,1499250,0.001,0.667,0.618,0.047,0.666,0.668
0.119.0,2023-11-20-21,explode,1.779,562114,0.002,1.78,1.725,0.05,1.776,1.78
0.119.0,2023-11-20-21,extdedup,1.183,845309,0.022,1.179,1.073,0.102,1.163,1.207
0.119.0,2023-11-20-21,extsort,0.995,1005025,0.038,1.008,1.142,0.349,0.952,1.024
0.119.0,2023-11-20-21,fill,1.806,553710,0.017,1.798,1.748,0.053,1.795,1.825
0.119.0,2023-11-20-21,fixlengths,1.514,660502,0.012,1.508,1.419,0.089,1.507,1.528
0.119.0,2023-11-20-21,flatten,6.155,162470,0.01,6.159,6.073,0.072,6.143,6.163
0.119.0,2023-11-20-21,flatten_condensed,6.653,150308,0.012,6.654,6.565,0.075,6.64,6.663
0.119.0,2023-11-20-21,fmt,0.973,1027749,0.002,0.974,0.925,0.046,0.971,0.974
0.119.0,2023-11-20-21,frequency,3.969,251953,0.063,3.935,3.836,0.125,3.93,4.041
0.119.0,2023-11-20-21,frequency_ignorecase,6.379,156764,0.054,6.351,6.222,0.142,6.345,6.441
0.119.0,2023-11-20-21,frequency_ignorecase_index,1.767,565931,0.12,1.713,7.238,0.375,1.684,1.904
0.119.0,2023-11-20-21,frequency_index,1.362,734214,0.144,1.294,4.904,0.362,1.265,1.527
0.119.0,2023-11-20-21,frequency_j1,4.022,248633,0.046,4.035,3.875,0.132,3.97,4.06
0.119.0,2023-11-20-21,frequency_j1_ignorecase,6.3,158730,0.105,6.292,6.141,0.142,6.2,6.409
0.119.0,2023-11-20-21,frequency_selregex,0.96,1041667,0.012,0.955,0.904,0.051,0.95,0.974
0.119.0,2023-11-20-21,frequency_selregex_ignorecase,1.625,615385,0.013,1.628,1.566,0.055,1.61,1.636
0.119.0,2023-11-20-21,geocode_reverse,4.016,249004,0.015,4.02,3.444,7.47,3.999,4.028
0.119.0,2023-11-20-21,geocode_suggest,5.287,189143,0.037,5.267,19.22,1.785,5.265,5.33
0.119.0,2023-11-20-21,index,0.516,1937984,0.001,0.516,0.467,0.046,0.515,0.516
0.119.0,2023-11-20-21,input,1.81,552486,0.006,1.812,1.753,0.052,1.804,1.816
0.119.0,2023-11-20-21,join,2.176,459559,0.002,2.176,1.529,0.641,2.174,2.178
0.119.0,2023-11-20-21,joinp,3.845,260078,0.042,3.835,6.644,0.706,3.81,3.892
0.119.0,2023-11-20-21,jsonl,6.9,144928,0.026,6.9,6.657,0.222,6.874,6.927
0.119.0,2023-11-20-21,luau_filter,10.34,96712,0.029,10.325,9.574,0.732,10.323,10.373
0.119.0,2023-11-20-21,luau_filter_no_globals,7.022,142410,0.011,7.026,6.283,0.726,7.01,7.03
0.119.0,2023-11-20-21,luau_filter_no_globals_no_colidx,5.374,186081,0.026,5.365,4.63,0.715,5.353,5.403
0.119.0,2023-11-20-21,luau_multi,28.165,35505,0.23,28.277,27.028,0.926,27.9,28.318
0.119.0,2023-11-20-21,luau_multi_no_globals,24.699,40487,0.202,24.599,23.719,0.872,24.566,24.932
0.119.0,2023-11-20-21,luau_multi_no_globals_no_colidx,22.899,43670,0.048,22.901,21.987,0.849,22.85,22.946
0.119.0,2023-11-20-21,luau_script,39.18,25523,0.088,39.138,38.108,0.947,39.12,39.281
0.119.0,2023-11-20-21,luau_script_no_globals,35.979,27794,0.102,35.923,34.963,0.934,35.916,36.097
0.119.0,2023-11-20-21,luau_script_no_globals_nocolidx,34.407,29064,0.065,34.384,33.391,0.914,34.357,34.48
0.119.0,2023-11-20-21,partition,1.279,781861,0.066,1.288,0.972,0.182,1.209,1.341
0.119.0,2023-11-20-21,pseudo,1.955,511509,0.01,1.95,1.881,0.069,1.948,1.967
0.119.0,2023-11-20-21,rename,1.123,890472,0.001,1.123,1.071,0.049,1.121,1.124
0.119.0,2023-11-20-21,replace,2.24,446429,0.015,2.232,2.177,0.054,2.231,2.258
0.119.0,2023-11-20-21,reverse,1.212,825083,0.07,1.172,1.012,0.18,1.171,1.292
0.119.0,2023-11-20-21,safenames,1.131,884173,0.004,1.133,1.074,0.049,1.126,1.134
0.119.0,2023-11-20-21,sample_10,0.593,1686341,0,0.593,0.546,0.045,0.593,0.593
0.119.0,2023-11-20-21,sample_1000,0.589,1697793,0.006,0.586,0.54,0.044,0.586,0.597
0.119.0,2023-11-20-21,sample_100000,0.774,1291990,0.002,0.773,0.713,0.057,0.772,0.776
0.119.0,2023-11-20-21,sample_100000_index,1.319,758150,0.024,1.305,0.208,1.106,1.304,1.347
0.119.0,2023-11-20-21,sample_100000_seeded,0.776,1288660,0.002,0.776,0.716,0.057,0.773,0.778
0.119.0,2023-11-20-21,sample_100000_seeded_faster,0.766,1305483,0.006,0.764,0.705,0.057,0.762,0.773
0.119.0,2023-11-20-21,sample_100000_seeded_index,1.346,742942,0.033,1.335,0.21,1.124,1.319,1.383
0.119.0,2023-11-20-21,sample_100000_seeded_index_faster,1.291,774593,0.044,1.304,0.2,1.078,1.241,1.327
0.119.0,2023-11-20-21,sample_1000_index,0.038,26315789,0.003,0.039,0.02,0.016,0.035,0.041
0.119.0,2023-11-20-21,sample_10_index,0.022,45454545,0,0.022,0.017,0.003,0.022,0.023
0.119.0,2023-11-20-21,sample_25pct_index,3.346,298864,0.099,3.333,0.501,2.824,3.254,3.451
0.119.0,2023-11-20-21,sample_25pct_seeded_index,3.242,308452,0.071,3.266,0.493,2.74,3.162,3.298
0.119.0,2023-11-20-21,schema,20.629,48475,0.301,20.608,29.572,1.778,20.339,20.939
0.119.0,2023-11-20-21,schema_index,8.858,112892,0.192,8.768,13.814,0.651,8.728,9.079
0.119.0,2023-11-20-21,search,0.662,1510574,0.003,0.662,0.614,0.045,0.659,0.664
0.119.0,2023-11-20-21,search_unicode,0.661,1512859,0.001,0.662,0.613,0.046,0.66,0.662
0.119.0,2023-11-20-21,searchset,1.928,518672,0.008,1.923,1.83,0.091,1.923,1.937
0.119.0,2023-11-20-21,searchset_ignorecase,2.158,463392,0.004,2.157,2.059,0.094,2.155,2.162
0.119.0,2023-11-20-21,searchset_unicode,1.932,517598,0.022,1.92,1.832,0.091,1.919,1.958
0.119.0,2023-11-20-21,select,0.546,1831502,0.001,0.546,0.5,0.044,0.545,0.547
0.119.0,2023-11-20-21,select_regex,0.59,1694915,0,0.59,0.543,0.045,0.59,0.59
0.119.0,2023-11-20-21,slice_one_middle,0.287,3484321,0.001,0.287,0.263,0.023,0.287,0.288
0.119.0,2023-11-20-21,slice_one_middle_index,0.006,166666667,0,0.006,0.004,0.002,0.006,0.006
0.119.0,2023-11-20-21,snappy_compress,0.254,3937008,0.022,0.243,1.2,0.137,0.239,0.279
0.119.0,2023-11-20-21,snappy_decompress,0.54,1851852,0.002,0.539,0.515,0.023,0.538,0.542
0.119.0,2023-11-20-21,snappy_validate,0.53,1886792,0.012,0.525,0.502,0.021,0.52,0.543
0.119.0,2023-11-20-21,sort,1.634,611995,0.068,1.601,2.859,0.212,1.589,1.713
0.119.0,2023-11-20-21,sort_random_seeded,1.447,691085,0.053,1.417,1.243,0.191,1.415,1.508
0.119.0,2023-11-20-21,sortcheck_sorted,0.581,1721170,0.018,0.576,0.521,0.047,0.565,0.601
0.119.0,2023-11-20-21,sortcheck_unsorted,0.007,142857143,0,0.007,0.004,0.002,0.006,0.007
0.119.0,2023-11-20-21,sortcheck_unsorted_all,0.596,1677852,0.002,0.596,0.549,0.045,0.595,0.598
0.119.0,2023-11-20-21,split,1.232,811688,0.025,1.228,0.947,0.172,1.21,1.259
0.119.0,2023-11-20-21,split_index,0.284,3521127,0.005,0.287,1.086,0.267,0.279,0.288
0.119.0,2023-11-20-21,split_index_j1,1.199,834028,0.008,1.2,1.006,0.163,1.19,1.207
0.119.0,2023-11-20-21,sqlp,3.231,309502,0.017,3.225,4.163,0.305,3.218,3.25
0.119.0,2023-11-20-21,sqlp_format_arrow,3.363,297354,0.09,3.348,4.188,0.36,3.281,3.459
0.119.0,2023-11-20-21,sqlp_format_json,3.345,298954,0.026,3.331,4.234,0.344,3.33,3.376
0.119.0,2023-11-20-21,sqlp_format_parquet,3.252,307503,0.031,3.264,4.181,0.311,3.216,3.275
0.119.0,2023-11-20-21,sqlp_format_parquet_statistics,3.248,307882,0.018,3.252,4.161,0.299,3.229,3.263
0.119.0,2023-11-20-21,sqlp_lowmemory,3.3,303030,0.022,3.3,4.164,0.186,3.278,3.322
0.119.0,2023-11-20-21,sqlp_nooptimizations,3.222,310366,0.022,3.213,4.166,0.302,3.204,3.247
0.119.0,2023-11-20-21,sqlp_tryparsedates,65.93,15168,0.362,65.836,65.269,0.333,65.624,66.33
0.119.0,2023-11-20-21,sqlp_tryparsedates_inferlen,0.678,1474926,0.001,0.677,0.667,0.013,0.677,0.679
0.119.0,2023-11-20-21,stats,2.263,441891,0.002,2.263,2.162,0.097,2.261,2.266
0.119.0,2023-11-20-21,stats_create_cache,2.261,442282,0.003,2.261,2.162,0.096,2.258,2.263
0.119.0,2023-11-20-21,stats_everything,4.408,226860,0.031,4.393,10.59,0.549,4.387,4.444
0.119.0,2023-11-20-21,stats_everything_create_cache,4.597,217533,0.19,4.505,10.714,0.709,4.47,4.815
0.119.0,2023-11-20-21,stats_everything_index,2.302,434405,0.108,2.348,10.777,1.082,2.179,2.38
0.119.0,2023-11-20-21,stats_everything_index_j1,8.749,114299,0.311,8.865,8.489,0.535,8.397,8.985
0.119.0,2023-11-20-21,stats_everything_index_j1_with_cache,0.006,166666667,0,0.006,0.004,0.002,0.006,0.007
0.119.0,2023-11-20-21,stats_everything_index_with_cache,0.006,166666667,0,0.006,0.004,0.002,0.006,0.007
0.119.0,2023-11-20-21,stats_everything_infer_dates,8.939,111869,0.082,8.966,15.521,0.667,8.847,9.003
0.119.0,2023-11-20-21,stats_everything_infer_dates_index,3.399,294204,0.204,3.4,16.666,1.291,3.193,3.602
0.119.0,2023-11-20-21,stats_everything_infer_dates_index_with_cache,0.006,166666667,0,0.006,0.004,0.002,0.006,0.006
0.119.0,2023-11-20-21,stats_everything_j1,9.197,108731,0.526,9.285,9.083,0.453,8.633,9.674
0.119.0,2023-11-20-21,stats_index,0.327,3058104,0.001,0.326,1.982,0.063,0.326,0.328
0.119.0,2023-11-20-21,stats_index_j1,1.768,565611,0.003,1.767,1.717,0.047,1.766,1.771
0.119.0,2023-11-20-21,stats_index_j1_with_cache,0.006,166666667,0,0.006,0.004,0.002,0.006,0.007
0.119.0,2023-11-20-21,stats_index_with_cache,0.007,142857143,0,0.007,0.004,0.002,0.006,0.007
0.119.0,2023-11-20-21,table,8.208,121832,0.218,8.101,6.796,1.333,8.064,8.459
0.119.0,2023-11-20-21,to_datapackage,0.933,1071811,0.016,0.938,2.151,0.279,0.915,0.946
0.119.0,2023-11-20-21,to_parquet,0.008,125000000,0.001,0.007,0.004,0.002,0.007,0.009
0.119.0,2023-11-20-21,to_sqlite,0.875,1142857,0.038,0.883,2.097,0.262,0.834,0.909
0.119.0,2023-11-20-21,to_xlsx,36.755,27207,0.215,36.65,33.722,3.789,36.612,37.002
0.119.0,2023-11-20-21,tojsonl,16.22,61652,0.272,16.321,24.302,1.021,15.912,16.426
0.119.0,2023-11-20-21,tojsonl_index,14.06,71124,0.29,14.165,27.607,1.533,13.732,14.282
0.119.0,2023-11-20-21,tojsonl_index_j1,25.818,38733,0.131,25.885,24.669,0.997,25.667,25.902
0.119.0,2023-11-20-21,tojsonl_j1,25.409,39356,0.45,25.229,23.629,1.257,25.076,25.921
0.119.0,2023-11-20-21,transpose,2.835,352734,0.01,2.83,2.484,0.332,2.828,2.847
0.119.0,2023-11-20-21,transpose_multipass,24.547,40738,0.178,24.601,22.34,1.985,24.349,24.692
0.119.0,2023-11-20-21,validate,2.53,395257,0.133,2.607,8.866,0.151,2.376,2.608
0.119.0,2023-11-20-21,validate_index,2.278,438982,0.01,2.272,8.952,0.114,2.272,2.29
0.119.0,2023-11-20-21,validate_no_schema,0.626,1597444,0.003,0.625,0.571,0.05,0.624,0.63
0.119.0,2023-11-20-21,validate_no_schema_index,0.61,1639344,0.001,0.61,0.563,0.044,0.609,0.61
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment