| quantile(float64, 0.5) | 50M | 38.7x | ≥3x | 4.6111.626 CPU-ms | 179.3 6.7c | 178.5 6.8c | 368.9 1.0c | — | 366.5 1.0c |
| count by int32 key (10000000 groups) | 50M | 25.7x | ≥3x | 16.72.015 CPU-ms | 429.1 9.5c | 427.2 9.3c | 1,067 3.0c | 1,065 3.0c | 772.7 1.0c |
| partition_nth_indices (n/2) | 50M | 24.5x | ≥3x | 12.23.838 CPU-ms | — | — | 297.8 1.0c | — | 349.4 numpy 1.0c |
| take (n/2 random indices) | 50M | 24.2x | ≥3x | 5.9040.786 CPU-ms | 171.8 1.0c | 172.0 1.0c | 142.6 1.0c | — | 171.4 1.0c |
| lexsort (2 int32 keys) | 50M | 24.0x | ≥3x | 37.62.416 CPU-ms | 920.1 10.9c | 902.9 11.0c | 7,774 1.0c | — | 29,655 numpy 1.0c |
| dictionary_encode (utf8) | 10M | 20.1x | ≥3x | 5.6494.025 CPU-ms | 113.8 1.0c | 113.4 1.0c | 131.3 1.0c | — | 137.3 1.0c |
| take (n/2 random indices) | 10M | 18.0x | ≥3x | 1.2780.638 CPU-ms | 28.9 1.0c | 28.6 1.0c | 23.0 1.0c | — | 28.3 1.0c |
| count by int32 key (10000000 groups) | 10M | 17.3x | ≥3x | 5.0721.664 CPU-ms | 87.8 8.8c | 90.6 8.8c | 266.8 2.1c | 270.7 2.2c | 229.2 1.0c |
| argsort utf8 | 10M | 16.6x | ≥3x | 13.73.327 CPU-ms | 232.7 13.7c | 227.5 13.8c | 1,601 1.0c | — | 1,601 1.0c |
| lexsort (2 int32 keys) | 10M | 15.3x | ≥3x | 7.2912.299 CPU-ms | 111.4 10.9c | 114.6 10.6c | 1,123 1.0c | — | 3,371 numpy 1.0c |
| sum by two int32 keys (~10004569 groups) | 50M | 12.1x | ≥3x | 47.93.208 CPU-ms | 580.1 13.7c | 619.4 12.6c | 1,363 2.8c | 1,363 2.8c | 1,610 1.0c |
| list by key (1000 groups) | 50M | 10.9x | ≥3x | 28.43.945 CPU-ms | 319.0 3.2c | 308.4 3.3c | 400.6 1.6c | 394.1 1.5c | 8,179 1.0c |
| argsort float64 | 50M | 10.5x | ≥3x | 39.90.825 CPU-ms | 420.1 13.2c | 422.7 13.1c | 5,885 1.0c | — | 5,472 numpy 1.0c |
| dense_rank | 50M | 10.3x | ≥3x | 67.83.070 CPU-ms | 699.2 5.6c | 716.1 5.5c | 5,552 1.0c | — | 21,375 1.0c |
| rank (min) | 50M | 10.3x | ≥3x | 68.03.078 CPU-ms | 700.1 5.6c | 708.8 5.6c | 5,553 1.0c | — | 21,473 1.0c |
| compare + filter + take | 50M | 10.1x | ≥3x | 4.5451.132 CPU-ms | 45.7 1.0c | 46.5 1.0c | 124.4 1.0c | — | 202.0 numpy 1.0c |
| rolling_sum (window 64) | 50M | 10.0x | ≥3x | 23.32.088 CPU-ms | 430.9 1.0c | 427.7 1.0c | — | — | 234.1 1.0c |
| list by key (1000 groups) | 10M | 9.8x | ≥3x | 5.9142.878 CPU-ms | 58.6 3.5c | 58.1 3.5c | 73.5 1.5c | 74.5 1.6c | 1,621 1.0c |
| list by key (100000 groups) | 50M | 9.7x | ≥3x | 35.44.417 CPU-ms | 343.9 3.7c | 344.7 3.6c | 487.6 1.7c | 489.7 1.8c | 9,555 1.0c |
| argsort float64 | 10M | 9.7x | ≥3x | 8.1070.851 CPU-ms | 78.6 12.8c | 80.3 12.6c | 984.1 1.0c | — | 841.9 numpy 1.0c |
| quantile(float64, 0.5) | 10M | 9.7x | ≥3x | 3.6261.773 CPU-ms | 35.0 6.6c | 35.0 6.6c | 61.9 1.0c | — | 62.3 1.0c |
| strptime (%Y-%m-%d %H:%M:%S) | 50M | 9.2x | ≥3x | 15.52.054 CPU-ms | 2,167 1.0c | 157.0 15.6c | 1,728 1.0c | 142.6 14.8c | 4,887 1.0c |
| top_k (k=100, int64) | 50M | 9.0x | ≥3x | 2.6741.380 CPU-ms | 65.5 1.0c | 65.1 1.0c | 24.0 1.0c | — | 328.4 numpy 1.0c |
| strptime (%Y-%m-%d %H:%M:%S) | 10M | 8.9x | ≥3x | 3.3700.775 CPU-ms | 418.4 1.0c | 32.5 14.8c | 344.8 1.0c | 30.0 13.9c | 967.5 1.0c |
| rolling_sum (window 64) | 10M | 8.9x | ≥3x | 5.3481.734 CPU-ms | 86.7 1.0c | 85.7 1.0c | — | — | 47.3 1.0c |
| partition_nth_indices (n/2) | 10M | 8.6x | ≥3x | 5.8233.631 CPU-ms | — | — | 49.9 1.0c | — | 54.6 numpy 1.0c |
| dense_rank | 10M | 8.5x | ≥3x | 12.01.801 CPU-ms | 110.7 6.3c | 102.7 6.8c | 883.7 1.0c | — | 2,223 1.0c |
| rolling_mean (window 64) | 50M | 8.4x | ≥3x | 25.32.084 CPU-ms | 416.9 1.0c | 415.0 1.0c | — | — | 213.3 1.0c |
| sum by int32 key (100000 groups) | 10M | 8.4x | ≥3x | 1.9511.082 CPU-ms | 22.7 12.1c | 24.8 11.6c | 16.4 6.0c | 21.6 6.4c | 67.5 1.0c |
| list by key (100000 groups) | 10M | 8.4x | ≥3x | 8.8273.447 CPU-ms | 74.5 3.4c | 74.1 3.4c | 88.8 1.7c | 92.4 2.0c | 2,533 1.0c |
| sum by two int32 keys (~10004569 groups) | 10M | 8.4x | ≥3x | 12.43.705 CPU-ms | 103.9 12.5c | 104.4 13.0c | 337.3 2.0c | 352.6 2.1c | 442.8 1.0c |
| rank (min) | 10M | 8.2x | ≥3x | 12.41.896 CPU-ms | 101.9 6.8c | 111.6 6.3c | 889.8 1.0c | — | 2,260 1.0c |
| cumulative_prod (float64) | 50M | 8.1x | ≥3x | 12.40.409 CPU-ms | 134.4 1.0c | 135.7 1.0c | 100.0 1.0c | — | 123.4 1.0c |
| first by key (1000 groups) | 50M | 8.0x | ≥3x | 6.8233.401 CPU-ms | 54.2 14.3c | 55.8 14.0c | 210.8 1.0c | — | 196.6 1.0c |
| count by int32 key (100000 groups) | 50M | 7.8x | ≥3x | 4.9241.258 CPU-ms | 120.7 8.8c | 121.9 8.8c | 39.7 11.0c | 38.3 11.0c | 170.9 1.0c |
| argsort int64 | 50M | 7.7x | ≥3x | 39.10.855 CPU-ms | 302.0 11.8c | 304.5 11.7c | 5,197 1.0c | — | 4,545 numpy 1.0c |
| sum by two int32 keys (~100489 groups) | 10M | 7.7x | ≥3x | 2.4891.888 CPU-ms | 38.0 11.8c | 38.2 11.9c | 19.1 6.1c | 25.6 6.3c | 107.7 1.0c |
| cumulative_sum (float64) | 50M | 7.6x | ≥3x | 13.00.405 CPU-ms | 132.1 1.0c | 135.5 1.0c | 99.5 1.0c | — | 120.2 1.0c |
| compare + filter + take | 10M | 7.6x | ≥3x | 0.9790.994 CPU-ms | 7.550 1.0c | 7.392 1.0c | 23.9 1.0c | — | 40.3 numpy 1.0c |
| cumulative_prod (float64) | 10M | 7.5x | ≥3x | 2.6970.401 CPU-ms | 26.4 1.0c | 26.4 1.0c | 20.2 1.0c | — | 25.2 1.0c |
| sum by two int32 keys (~100489 groups) | 50M | 7.4x | ≥3x | 8.2702.212 CPU-ms | 213.8 12.2c | 213.0 12.7c | 66.5 10.6c | 61.2 10.7c | 573.3 1.0c |
| argsort int64 | 10M | 7.4x | ≥3x | 7.8110.826 CPU-ms | 57.6 11.4c | 57.8 11.3c | 841.2 1.0c | — | 699.0 numpy 1.0c |
| is_in (int64, 100-value set)re-measured in place after the full run flagged it (same build, quieter machine) | 50M | 7.4x | ≥3x | 2.1681.507 CPU-ms | 269.7 1.0c | 16.0 15.0c | 383.7 1.0c | 33.2 14.6c | 406.6 1.0c |
| sum by int32 key (10000000 groups) | 10M | 7.4x | ≥3x | 9.4571.643 CPU-ms | 72.0 12.8c | 69.5 13.6c | 312.4 2.0c | 319.2 2.1c | 321.0 1.0c |
| rolling_mean (window 64) | 10M | 7.3x | ≥3x | 5.8721.761 CPU-ms | 85.5 1.0c | 85.6 1.0c | — | — | 43.0 1.0c |
| count_distinct by key (10000000 groups) | 10M | 7.2x | ≥3x | 11.42.727 CPU-ms | 82.8 13.8c | 83.9 13.9c | 645.6 2.0c | 668.2 2.1c | 1,033 1.0c |
| cumulative_sum (float64) | 10M | 7.0x | ≥3x | 2.8330.427 CPU-ms | 26.9 1.0c | 26.0 1.0c | 19.9 1.0c | — | 24.5 1.0c |
| contains("north") | 10M | 7.0x | ≥3x | 1.6400.394 CPU-ms | 141.8 1.0c | 11.5 15.0c | 118.8 1.0c | 13.8 11.1c | 119.3 1.0c |
| top_k (k=10000, int64) | 50M | 7.0x | ≥3x | 4.9601.887 CPU-ms | 66.2 1.0c | 65.5 1.0c | 34.7 1.0c | — | 327.6 numpy 1.0c |
| sum by int32 key (10000000 groups) | 50M | 7.0x | ≥3x | 46.12.157 CPU-ms | 327.0 14.1c | 321.7 14.3c | 1,309 2.9c | 1,303 2.8c | 1,294 1.0c |
| mean by int32 key (10000000 groups) | 10M | 7.0x | ≥3x | 11.61.727 CPU-ms | 80.9 13.6c | 82.2 13.9c | 304.7 2.1c | 315.2 2.2c | 326.3 1.0c |
| max by key, float64 (100000 groups) | 10M | 7.0x | ≥3x | 2.5571.390 CPU-ms | 22.7 12.1c | 23.1 11.9c | 17.8 5.8c | 24.5 5.8c | 64.9 1.0c |
| pairwise_diff (float64) | 50M | 6.9x | ≥3x | 3.5730.889 CPU-ms | 25.5 1.0c | 25.6 1.0c | 102.5 1.0c | — | 24.7 1.0c |
| min by key, float64 (100000 groups) | 10M | 6.8x | ≥3x | 2.5781.381 CPU-ms | 22.6 12.3c | 22.3 12.4c | 17.6 5.8c | 24.3 6.0c | 64.6 1.0c |
| mean by int32 key (10000000 groups) | 50M | 6.8x | ≥3x | 49.62.233 CPU-ms | 343.4 14.1c | 336.7 14.0c | 1,294 2.8c | 1,285 2.8c | 1,350 1.0c |
| count_distinct by key (10000000 groups) | 50M | 6.7x | ≥3x | 60.73.087 CPU-ms | 407.5 14.8c | 410.6 14.7c | 3,210 2.5c | 3,195 2.5c | 5,238 1.0c |
| max by key, float64 (100000 groups) | 50M | 6.7x | ≥3x | 9.6741.661 CPU-ms | 120.8 14.7c | 95.6 14.5c | 73.5 10.6c | 64.9 10.2c | 310.3 1.0c |
| min by key, float64 (100000 groups) | 50M | 6.6x | ≥3x | 9.7001.680 CPU-ms | 123.0 14.9c | 95.4 14.6c | 84.8 10.6c | 64.3 10.5c | 311.0 1.0c |
| count by int32 key (100000 groups) | 10M | 6.6x | ≥3x | 1.9581.132 CPU-ms | 28.2 7.2c | 27.4 7.6c | 13.0 6.3c | 17.1 6.4c | 32.2 1.0c |
| mean by int32 key (100000 groups) | 10M | 6.6x | ≥3x | 2.4781.167 CPU-ms | 23.5 12.0c | 23.3 12.2c | 16.2 6.0c | 20.8 6.6c | 85.6 1.0c |
| min by int32 key (100000 groups) | 10M | 6.5x | ≥3x | 2.7871.433 CPU-ms | 23.6 11.9c | 23.3 12.0c | 18.1 5.8c | 24.5 5.9c | 68.6 1.0c |
| max by int32 key (100000 groups) | 10M | 6.5x | ≥3x | 2.7781.432 CPU-ms | 23.5 11.6c | 24.5 11.5c | 17.9 5.8c | 25.0 5.8c | 68.7 1.0c |
| first by key (10000000 groups) | 10M | 6.4x | ≥3x | 14.62.630 CPU-ms | 94.0 8.3c | 98.2 8.2c | 307.9 1.0c | — | 300.1 1.0c |
| assume_timezone (America/New_York) | 10M | 6.4x | ≥3x | 3.3630.708 CPU-ms | 540.3 1.0c | 41.0 15.4c | 215.3 1.0c | 21.7 12.1c | 669.1 1.0c |
| last(int64) | 50M | 6.4x | ≥3x | 0.0020.003 CPU-ms | 24.5 1.0c | 0.010 1.0c | 0.150 1.0c | — | 35.2 1.0c |
| mean by int32 key (100000 groups) | 50M | 6.4x | ≥3x | 7.3891.207 CPU-ms | 101.2 14.8c | 99.2 14.7c | 47.3 11.4c | 47.0 11.5c | 429.6 1.0c |
| first(int64) | 10M | 6.3x | ≥3x | 0.0020.002 CPU-ms | 4.782 1.0c | 0.009 1.1c | 0.033 1.0c | — | 4.883 1.0c |
| sum by int32 key (100000 groups) | 50M | 6.3x | ≥3x | 7.4111.253 CPU-ms | 102.4 14.2c | 99.4 14.7c | 48.1 11.3c | 46.4 11.7c | 334.8 1.0c |
| fill_null_forward (int64) | 50M | 6.2x | ≥3x | 9.6271.742 CPU-ms | 137.3 1.0c | 138.0 1.0c | 59.2 1.0c | — | 59.7 1.0c |
| sum by utf8 key (100000 distinct) | 50M | 6.1x | ≥3x | 23.83.816 CPU-ms | 178.0 12.9c | 184.1 13.5c | 144.6 12.3c | 144.6 12.0c | 782.8 1.0c |
| first by key (100000 groups) | 10M | 6.1x | ≥3x | 2.9421.967 CPU-ms | 17.9 11.2c | 18.0 11.2c | 54.4 1.0c | — | 49.3 1.0c |
| last(int64) | 10M | 5.9x | ≥3x | 0.0020.003 CPU-ms | 4.823 1.0c | 0.009 1.0c | 0.037 1.0c | — | 6.940 1.0c |
| assume_timezone (America/New_York) | 50M | 5.8x | ≥3x | 15.81.831 CPU-ms | 2,697 1.0c | 204.8 15.4c | 1,069 1.0c | 92.5 14.4c | 3,119 1.0c |
| first by key (100000 groups) | 50M | 5.8x | ≥3x | 11.33.384 CPU-ms | 65.6 14.6c | 69.2 13.6c | 260.6 1.0c | — | 241.6 1.0c |
| sort utf8 | 10M | 5.8x | ≥3x | 23.07.129 CPU-ms | 133.1 10.0c | 134.7 9.5c | 1,865 1.0c | 2,486 1.0c | 1,867 1.0c |
| list by key (10000000 groups) | 50M | 5.7x | ≥3x | 139.35.772 CPU-ms | 797.3 5.5c | 794.4 5.4c | 1,487 2.4c | 1,433 2.5c | 85,183 1.0c |
| first(int64) | 50M | 5.6x | ≥3x | 0.0020.002 CPU-ms | 24.4 1.0c | 0.010 1.1c | 0.149 1.0c | — | 23.4 1.0c |
| sum by utf8 key (100000 distinct) | 10M | 5.4x | ≥3x | 6.6053.701 CPU-ms | 35.8 11.4c | 35.8 12.1c | 39.9 6.1c | 47.8 7.6c | 157.9 1.0c |
| indices_nonzero (bool) | 50M | 5.4x | ≥3x | 3.1680.826 CPU-ms | 129.6 1.0c | 130.3 1.0c | 117.6 1.0c | — | 17.0 numpy 1.0c |
| max by key, float64 (10000000 groups) | 10M | 5.3x | ≥3x | 14.41.729 CPU-ms | 77.1 13.4c | 80.9 13.3c | 300.7 2.1c | 311.5 2.0c | 321.5 1.0c |
| mean(int64, 10% nulls) | 50M | 5.3x | ≥3x | 1.1450.428 CPU-ms | 13.2 1.0c | 13.3 1.0c | 64.6 1.0c | 6.115 13.3c | 64.2 1.0c |
| max by int32 key (100000 groups) | 50M | 5.3x | ≥3x | 10.61.529 CPU-ms | 115.8 12.6c | 106.1 13.8c | 59.6 10.2c | 56.3 10.9c | 334.9 1.0c |
| min by key, float64 (10000000 groups) | 10M | 5.2x | ≥3x | 14.41.701 CPU-ms | 75.4 14.0c | 79.3 13.6c | 298.8 2.1c | 312.6 2.1c | 318.4 1.0c |
| mean(int64, 10% nulls) | 10M | 5.2x | ≥3x | 0.2860.321 CPU-ms | 2.385 1.0c | 2.426 1.0c | 11.6 1.0c | 1.497 10.9c | 11.5 1.0c |
| max by key, float64 (10000000 groups) | 50M | 5.2x | ≥3x | 63.01.935 CPU-ms | 327.4 14.2c | 328.8 14.2c | 1,241 3.1c | 1,228 3.1c | 1,343 1.0c |
| first by key (10000000 groups) | 50M | 5.1x | ≥3x | 65.63.870 CPU-ms | 336.1 11.6c | 344.8 11.5c | 1,146 1.0c | — | 1,047 1.0c |
| min by key, float64 (10000000 groups) | 50M | 5.1x | ≥3x | 63.01.930 CPU-ms | 321.5 14.3c | 325.2 14.5c | 1,259 3.0c | 1,234 3.1c | 1,326 1.0c |
| decimal sum | 50M | 5.1x | ≥3x | 1.8140.443 CPU-ms | 92.1 1.0c | 11.4 9.5c | 95.0 1.0c | 9.211 12.8c | 93.9 1.0c |
match_like("cust_1%") [_ wildcard]_ is LIKE's single-character wildcard, so this is not a pure prefix and takes the ICU host path | 10M | 5.1x | ≥3x | 1.6950.422 CPU-ms | 100.0 1.0c | 8.559 14.6c | 183.6 1.0c | 18.3 12.1c | 203.1 1.0c |
| max by int32 key (10000000 groups) | 10M | 5.0x | ≥3x | 15.01.817 CPU-ms | 75.5 13.8c | 79.6 13.4c | 309.1 2.0c | 321.4 2.2c | 324.8 1.0c |
| min by key, float64 (1000 groups) | 50M | 5.0x | ≥3x | 6.1111.720 CPU-ms | 139.0 14.5c | 88.9 13.2c | 41.8 12.0c | 30.5 12.7c | 224.8 1.0c |
| min by int32 key (100000 groups) | 50M | 4.9x | ≥3x | 10.61.505 CPU-ms | 100.4 14.5c | 103.4 14.3c | 52.7 11.1c | 52.1 11.2c | 335.0 1.0c |
| min by int32 key (10000000 groups) | 10M | 4.9x | ≥3x | 14.91.684 CPU-ms | 72.6 14.4c | 78.2 13.7c | 310.7 2.0c | 320.8 2.1c | 324.5 1.0c |
| pairwise_diff (float64) | 10M | 4.8x | ≥3x | 0.9370.582 CPU-ms | 4.516 1.0c | 4.666 1.0c | 21.0 1.0c | — | 4.976 1.0c |
| replace_substring("cust" -> "cx") | 10M | 4.8x | ≥3x | 3.0491.259 CPU-ms | 300.4 1.0c | 23.4 15.1c | 140.9 1.0c | 14.7 11.7c | 141.4 1.0c |
| top_k (k=10000, int64) | 10M | 4.8x | ≥3x | 2.4741.856 CPU-ms | 11.8 1.0c | 11.9 1.0c | 12.0 1.0c | — | 45.6 numpy 1.0c |
| sum by utf8 key (10000000 distinct) | 50M | 4.8x | ≥3x | 126.16.389 CPU-ms | 602.8 12.3c | 685.0 11.5c | 2,944 2.1c | 2,928 2.1c | 4,288 1.0c |
| fill_null_forward (int64) | 10M | 4.7x | ≥3x | 2.3411.361 CPU-ms | 27.2 1.0c | 27.6 1.0c | 11.5 1.0c | — | 11.1 1.0c |
| max by key, float64 (1000 groups) | 50M | 4.7x | ≥3x | 6.0861.724 CPU-ms | 142.2 14.3c | 89.6 12.9c | 41.3 12.1c | 28.7 12.5c | 234.4 1.0c |
| concat (a + '-' + b) | 10M | 4.7x | ≥3x | 4.1571.496 CPU-ms | 312.3 1.0c | 20.2 14.3c | 201.2 1.0c | 19.5 12.7c | 363.6 1.0c |
| index_in (int64, 100-value set) | 50M | 4.7x | ≥3x | 5.9283.510 CPU-ms | — | — | 332.4 1.0c | 27.7 14.2c | 163.0 numpy 1.0c |
| min by int32 key (10000000 groups) | 50M | 4.6x | ≥3x | 72.01.950 CPU-ms | 328.9 14.3c | 347.1 13.5c | 1,356 2.8c | 1,314 2.8c | 1,423 1.0c |
| max by int32 key (10000000 groups) | 50M | 4.5x | ≥3x | 72.12.009 CPU-ms | 334.0 14.2c | 326.5 14.2c | 1,346 2.8c | 1,346 2.8c | 1,402 1.0c |
| dictionary_encode (int32) | 50M | 4.4x | ≥3x | 19.17.095 CPU-ms | — | — | 342.0 1.0c | — | 84.2 1.0c |
| count_distinct by key (100000 groups) | 10M | 4.3x | ≥3x | 7.2772.330 CPU-ms | 31.6 13.0c | 31.0 13.3c | 363.8 2.1c | 375.6 2.4c | 869.5 1.0c |
| pad_left (width 20) | 10M | 4.2x | ≥3x | 3.1471.307 CPU-ms | 173.7 1.0c | 13.2 14.2c | 181.8 1.0c | 17.2 12.5c | 182.3 1.0c |
| sort float64 | 50M | 4.1x | ≥3x | 32.11.253 CPU-ms | 132.9 9.7c | 133.1 9.7c | 6,044 1.0c | 7,498 1.0c | 1,759 numpy 1.0c |
| count by int32 key (1000 groups) | 50M | 4.1x | ≥3x | 4.2291.232 CPU-ms | 89.0 9.1c | 89.6 9.1c | 17.5 13.5c | 17.4 13.5c | 138.5 1.0c |
| is_dst (America/New_York) | 10M | 4.1x | ≥3x | 3.0830.418 CPU-ms | 388.0 1.0c | 29.5 15.1c | 110.1 1.0c | 12.6 10.7c | — |
| variance by key (10000000 groups) | 50M | 4.1x | ≥3x | 79.43.063 CPU-ms | 323.0 14.4c | 322.9 14.7c | 2,444 4.8c | 2,438 4.8c | 1,368 1.0c |
| sum by utf8 key (10000000 distinct) | 10M | 4.1x | ≥3x | 27.55.817 CPU-ms | 111.9 11.9c | 112.7 11.8c | 572.0 1.8c | 581.4 2.0c | 801.9 1.0c |
| match_substring_regex (literal) | 10M | 4.0x | ≥3x | 2.8580.414 CPU-ms | 144.8 1.0c | 11.6 14.9c | 256.6 1.0c | 24.6 12.1c | 248.4 1.0c |
| sum by two int32 keys (~1024 groups) | 50M | 4.0x | ≥3x | 5.9132.115 CPU-ms | 164.2 13.5c | 177.1 12.7c | 23.9 13.5c | 24.0 13.5c | 448.4 1.0c |
| first by key (1000 groups) | 10M | 4.0x | ≥3x | 3.8212.240 CPU-ms | 15.2 10.6c | 15.1 10.8c | 42.4 1.0c | — | 39.4 1.0c |
| char_length | 10M | 3.8x | ≥3x | 1.0960.387 CPU-ms | 52.6 1.0c | 4.217 14.8c | 52.3 1.0c | 5.447 11.6c | 52.5 1.0c |
| sort float64 | 10M | 3.8x | ≥3x | 6.8541.168 CPU-ms | 26.2 9.6c | 26.3 9.5c | 1,006 1.0c | 1,159 1.0c | 303.1 numpy 1.0c |
| mean by int32 key (1000 groups) | 50M | 3.8x | ≥3x | 4.9141.240 CPU-ms | 81.5 14.5c | 82.1 14.4c | 18.7 13.6c | 18.6 13.5c | 264.6 1.0c |
| sum by int32 key (1000 groups) | 50M | 3.8x | ≥3x | 4.8881.227 CPU-ms | 82.4 14.5c | 81.9 14.5c | 18.5 13.5c | 18.5 13.6c | 247.9 1.0c |
| count_distinct by key (1000 groups) | 50M | 3.8x | ≥3x | 41.82.640 CPU-ms | 307.9 13.0c | 156.8 14.0c | 1,886 2.2c | 1,859 2.3c | 4,773 1.0c |
| match_substring_regex (literal) | 1M | 3.7x | ≥3x | 0.5130.354 CPU-ms | 14.5 1.0c | 1.921 9.3c | 25.2 1.0c | 2.726 11.3c | 25.4 1.0c |
| count_distinct by key (1000 groups) | 10M | 3.7x | ≥3x | 7.1272.332 CPU-ms | 26.6 13.1c | 26.7 13.1c | 327.0 2.0c | 323.1 2.1c | 854.6 1.0c |
| hash join indices (10000000 x 200000 on int64)the join kernel alone (am_join): the matching index pairs, no payload gather | 10M | 3.7x | ≥3x | 2.8360.788 CPU-ms | 22.0 9.5c | 22.6 9.2c | 10.4 14.1c | 10.4 14.3c | 102.9 1.0c |
| local_timestamp (America/New_York) | 10M | 3.6x | ≥3x | 3.2780.686 CPU-ms | 493.8 1.0c | 37.2 15.1c | 100.9 1.0c | 12.0 10.7c | 224.5 1.0c |
| product(int64) | 50M | 3.6x | ≥3x | 1.3630.428 CPU-ms | 48.5 1.0c | 48.4 1.0c | 50.6 1.0c | 4.960 13.8c | 50.8 1.0c |
| variance by key (10000000 groups) | 10M | 3.6x | ≥3x | 20.42.834 CPU-ms | 73.4 13.9c | 78.8 13.5c | 460.1 2.4c | 462.4 2.4c | 347.6 1.0c |
| shift_left (int64 << 2) | 50M | 3.6x | ≥3x | 1.8940.393 CPU-ms | — | — | 53.6 1.0c | 6.812 11.8c | 6.729 numpy 1.0c |
| stddev by key (10000000 groups) | 50M | 3.5x | ≥3x | 93.215.7 CPU-ms | 328.9 14.1c | 326.8 14.6c | 2,443 4.8c | 2,453 4.8c | 1,370 1.0c |
| is_dst (America/New_York) | 50M | 3.5x | ≥3x | 14.20.443 CPU-ms | 1,938 1.0c | 144.1 15.4c | 544.6 1.0c | 49.4 13.7c | — |
| hash join indices (50000000 x 1000000 on int64)the join kernel alone (am_join): the matching index pairs, no payload gather | 50M | 3.5x | ≥3x | 18.30.805 CPU-ms | 107.1 9.7c | 110.4 9.6c | 63.3 15.1c | 64.7 15.0c | 589.3 0.9c |
| count_distinct by key (100000 groups) | 50M | 3.4x | ≥3x | 42.32.672 CPU-ms | 161.8 14.6c | 142.5 15.3c | 2,028 2.4c | 2,029 2.4c | 4,674 1.0c |
| tdigest(float64, q=0.5) | 10M | 3.3x | ≥3x | 7.0501.703 CPU-ms | — | — | 195.2 1.0c | 23.6 9.9c | — |
| struct_field | 10M | 3.3x | ≥3x | 0.0010.003 CPU-ms | 0.013 1.1c | 0.210 3.9c | 0.003 1.3c | 0.590 10.7c | 0.014 1.1c |
| min by int32 key (1000 groups) | 50M | 3.3x | ≥3x | 5.9151.545 CPU-ms | 82.5 14.2c | 80.6 14.8c | 19.7 13.8c | 19.6 13.9c | 270.6 1.0c |
| max by int32 key (1000 groups) | 50M | 3.3x | ≥3x | 5.9111.593 CPU-ms | 83.4 14.4c | 83.2 14.4c | 19.8 13.6c | 19.5 13.7c | 273.5 1.0c |
| list_flatten | 10M | 3.1x | ≥3x | 0.0010.002 CPU-ms | 19.8 1.0c | 19.3 1.0c | 0.002 0.9c | — | 15.6 1.0c |
| decimal sum | 10M | 3.1x | ≥3x | 0.6050.374 CPU-ms | 18.4 1.0c | 2.340 10.0c | 19.8 1.0c | 1.880 12.7c | 19.7 1.0c |
| list by key (10000000 groups) | 10M | 3.1x | ≥3x | 60.04.482 CPU-ms | 186.0 4.6c | 190.6 4.7c | 306.3 1.9c | 317.8 1.9c | 49,627 1.0c |
| product(int64) | 10M | 3.1x | ≥3x | 0.4300.370 CPU-ms | 9.388 1.0c | 8.954 1.0c | 9.878 1.0c | 1.327 10.6c | 9.750 1.0c |
| mode(int64) | 50M | 3.1x | ≥3x | 33.68.560 CPU-ms | 142.8 13.4c | 132.2 14.6c | 103.7 1.0c | — | 342.3 1.0c |
| left outer hash join (10000000 x 200000 on int64)am_join join_type 1: index pairs with a null right index for an unmatched left row | 10M | 3.1x | ≥3x | 3.0451.026 CPU-ms | 57.9 5.2c | 57.7 5.2c | 9.390 14.0c | 9.517 14.0c | 252.8 1.0c |
| left outer hash join (50000000 x 1000000 on int64)am_join join_type 1: index pairs with a null right index for an unmatched left row | 50M | 3.0x | ≥3x | 19.11.331 CPU-ms | 285.0 5.0c | 286.3 4.9c | 58.0 14.8c | 58.1 14.8c | 1,690 1.0c |
| all(bool, 10% nulls)host short-circuit: any/all stop at the first set bit; no GPU dispatch, so this is a CPU scan and the ratio is data-dependent | 10M | 19.2x | ≥3x | 0.0020.002 CPU-ms | 0.105 1.0c | 0.114 1.0c | 0.029 1.0c | 0.361 9.7c | 0.033 1.0c |
| all(bool, 10% nulls)host short-circuit: any/all stop at the first set bit; no GPU dispatch, so this is a CPU scan and the ratio is data-dependent | 50M | 106.4x | ≥3x | 0.0010.003 CPU-ms | 0.773 1.0c | 0.591 1.0c | 0.149 1.0c | 1.436 14.1c | 0.154 1.0c |
| any(bool, 10% nulls)host short-circuit: any/all stop at the first set bit; no GPU dispatch, so this is a CPU scan and the ratio is data-dependent | 10M | 23.8x | ≥3x | 0.0010.003 CPU-ms | 0.098 1.0c | 0.108 1.0c | 0.029 1.0c | 0.360 9.7c | 0.033 1.0c |
| any(bool, 10% nulls)host short-circuit: any/all stop at the first set bit; no GPU dispatch, so this is a CPU scan and the ratio is data-dependent | 50M | 106.4x | ≥3x | 0.0010.002 CPU-ms | 0.544 1.0c | 0.555 1.0c | 0.149 1.0c | 1.414 13.9c | 0.154 1.0c |
| inner hash join (50000000 x 1000000 on int64)am.join index pairs, then one take per output column | 50M | 2.9x | 1–3x | 21.81.567 CPU-ms | 105.8 10.0c | 106.6 10.0c | 63.9 15.0c | 64.7 14.9c | 542.9 1.0c |
| count by int32 key (1000 groups) | 10M | 2.9x | 1–3x | 1.5161.026 CPU-ms | 21.8 7.5c | 21.2 7.8c | 4.562 9.2c | 4.425 10.9c | 27.5 1.0c |
| lower | 10M | 2.9x | 1–3x | 5.3501.344 CPU-ms | 373.1 1.0c | 29.3 14.5c | 172.2 1.0c | 15.6 12.7c | 172.0 1.0c |
| upperre-measured in place after the full run flagged it (same build, quieter machine) | 10M | 2.9x | 1–3x | 5.3231.378 CPU-ms | 295.6 1.0c | 25.1 14.2c | 168.2 1.0c | 15.3 12.9c | 168.6 1.0c |
| min by key, float64 (1000 groups) | 10M | 2.8x | 1–3x | 1.7441.407 CPU-ms | 19.8 12.0c | 20.2 12.0c | 5.055 9.2c | 4.863 11.0c | 49.3 1.0c |
| exp (float32) | 50M | 2.7x | 1–3x | 1.9270.450 CPU-ms | 63.3 1.0c | 5.294 13.4c | 55.9 1.0c | 6.422 12.6c | 61.9 numpy 1.0c |
| contains("north") | 1M | 2.7x | 1–3x | 0.5090.349 CPU-ms | 14.4 1.0c | 1.923 9.2c | 12.3 1.0c | 1.394 11.0c | 11.6 1.0c |
| local_timestamp (America/New_York) | 50M | 2.7x | 1–3x | 15.51.839 CPU-ms | 2,461 1.0c | 183.6 15.5c | 508.1 1.0c | 42.5 15.3c | 1,122 1.0c |
| char_length | 1M | 2.7x | 1–3x | 0.2290.273 CPU-ms | 5.089 1.0c | 0.802 8.3c | 5.202 1.0c | 0.621 10.2c | 5.277 1.0c |
| decimal multiply (by scalar) | 50M | 2.7x | 1–3x | 3.5880.405 CPU-ms | 458.6 1.0c | 35.5 15.1c | 74.1 1.0c | 9.638 12.4c | 75.5 1.0c |
| inner hash join (10000000 x 200000 on int64)am.join index pairs, then one take per output column | 10M | 2.7x | 1–3x | 3.8831.536 CPU-ms | 22.1 9.5c | 22.5 9.4c | 10.4 14.1c | 10.6 14.1c | 96.2 1.0c |
| sum by int32 key (1000 groups) | 10M | 2.7x | 1–3x | 1.7341.034 CPU-ms | 20.3 11.4c | 20.2 12.0c | 4.803 9.2c | 4.613 11.0c | 45.5 1.0c |
| top_k (k=100, int64) | 10M | 2.6x | 1–3x | 1.8341.328 CPU-ms | 11.7 1.0c | 11.9 1.0c | 4.845 1.0c | — | 45.2 numpy 1.0c |
| stddev by key (100000 groups) | 50M | 2.5x | 1–3x | 38.12.896 CPU-ms | 123.6 14.6c | 95.8 14.6c | 235.0 11.7c | 167.1 11.6c | 424.5 1.0c |
| variance by key (100000 groups) | 50M | 2.5x | 1–3x | 37.72.470 CPU-ms | 98.1 14.8c | 94.9 14.7c | 239.9 11.8c | 161.6 11.5c | 421.5 1.0c |
| sum by two int32 keys (~1024 groups) | 10M | 2.5x | 1–3x | 2.1901.769 CPU-ms | 34.0 11.3c | 35.1 11.3c | 5.652 9.2c | 5.497 11.0c | 84.1 1.0c |
| slice_codeunits [5:10] | 10M | 2.5x | 1–3x | 2.7901.213 CPU-ms | 86.7 1.0c | 6.964 14.4c | 70.5 1.0c | 7.441 11.6c | 70.4 1.0c |
| split_pattern("_") | 10M | 2.4x | 1–3x | 8.4672.563 CPU-ms | 263.3 1.0c | 25.4 12.9c | 224.2 1.0c | 20.7 13.0c | 223.1 1.0c |
| strftime (%Y-%m-%d) | 10M | 2.4x | 1–3x | 30.81.390 CPU-ms | 941.1 1.0c | 75.0 14.9c | 2,158 1.0c | 174.8 15.0c | 935.6 1.0c |
| variance by key (100000 groups) | 10M | 2.4x | 1–3x | 9.4662.186 CPU-ms | 23.0 12.2c | 23.5 12.2c | 39.4 6.6c | 46.5 7.8c | 84.3 1.0c |
| tdigest(float64, q=0.5) | 50M | 2.4x | 1–3x | 33.22.025 CPU-ms | — | — | 1,061 1.0c | 80.0 15.3c | — |
| strftime (%Y-%m-%d) | 50M | 2.4x | 1–3x | 151.12.095 CPU-ms | 4,709 1.0c | 361.5 15.5c | 10,645 1.0c | 839.0 15.4c | 4,629 1.0c |
| dictionary_encode (int32) | 10M | 2.4x | 1–3x | 7.0825.724 CPU-ms | — | — | 71.2 1.0c | — | 16.9 1.0c |
| stddev by key (100000 groups) | 10M | 2.4x | 1–3x | 9.6562.390 CPU-ms | 23.7 12.1c | 23.0 12.4c | 39.1 6.7c | 46.8 7.6c | 84.8 1.0c |
| sum by utf8 key (1000 distinct) | 50M | 2.2x | 1–3x | 18.23.460 CPU-ms | 144.0 13.4c | 142.4 13.7c | 40.5 13.9c | 40.1 14.1c | 554.5 1.0c |
| is_alpha | 10M | 2.2x | 1–3x | 2.0860.542 CPU-ms | 85.6 1.0c | 7.267 14.1c | 46.2 1.0c | 4.580 11.8c | 47.7 1.0c |
| kurtosis(float64) | 10M | 2.2x | 1–3x | 2.5160.784 CPU-ms | 10.7 1.0c | 24.5 1.0c | 48.2 1.0c | 5.502 11.5c | 17.6 1.0c |
| variance(float64, ddof=1) | 50M | 2.2x | 1–3x | 5.4460.788 CPU-ms | 52.6 1.0c | 52.0 1.0c | 127.9 1.0c | 11.9 13.3c | 127.9 1.0c |
| stddev(float64, ddof=1) | 50M | 2.2x | 1–3x | 5.4910.826 CPU-ms | 52.7 1.0c | 52.2 1.0c | 128.0 1.0c | 11.9 13.2c | 128.1 1.0c |
| indices_nonzero (bool) | 10M | 2.1x | 1–3x | 1.5900.784 CPU-ms | 24.0 1.0c | 24.0 1.0c | 22.6 1.0c | — | 3.402 numpy 1.0c |
| trim (whitespace) | 10M | 2.1x | 1–3x | 5.0661.319 CPU-ms | 144.2 1.0c | 10.8 14.8c | 139.0 1.0c | 13.6 12.0c | 139.0 1.0c |
| kurtosis(float64) | 50M | 2.1x | 1–3x | 10.90.846 CPU-ms | 58.7 1.0c | 132.5 1.0c | 258.7 1.0c | 22.9 13.7c | 92.4 1.0c |
| mean by int32 key (1000 groups) | 10M | 2.1x | 1–3x | 2.2071.171 CPU-ms | 20.3 11.4c | 20.4 11.5c | 4.808 9.2c | 4.633 11.0c | 49.7 1.0c |
| sum(int64, 10% nulls) | 50M | 2.1x | 1–3x | 1.1110.405 CPU-ms | 15.9 1.0c | 2.304 11.1c | 52.1 1.0c | 5.091 13.0c | 51.5 1.0c |
| stddev by key (10000000 groups) | 10M | 2.1x | 1–3x | 37.018.8 CPU-ms | 76.6 13.5c | 79.8 13.8c | 460.6 2.4c | 463.7 2.3c | 351.8 1.0c |
| decimal add (128-bit) | 50M | 2.0x | 1–3x | 5.4180.407 CPU-ms | 275.7 1.0c | 21.6 14.1c | 74.1 1.0c | 11.0 12.8c | 74.4 1.0c |
| fill_null (int64) | 50M | 2.0x | 1–3x | 2.1070.421 CPU-ms | 24.3 1.0c | 4.165 12.9c | 41.8 1.0c | 6.439 11.9c | 42.0 1.0c |
| count_distinct(int64) | 50M | 2.0x | 1–3x | 9.6072.322 CPU-ms | 251.1 2.4c | 251.9 2.4c | 200.4 1.0c | 18.9 13.1c | 204.5 1.0c |
| multiply scalar (int64) | 50M | 2.0x | 1–3x | 2.1020.400 CPU-ms | 24.8 1.0c | 4.132 12.6c | 13.0 1.0c | 4.264 11.5c | 54.9 1.0c |
| mode(int64) | 10M | 2.0x | 1–3x | 10.0007.463 CPU-ms | 28.7 13.4c | 32.2 11.7c | 19.5 1.0c | — | 66.8 1.0c |
| add_checked (int64 + int64) | 50M | 1.9x | 1–3x | 4.4970.642 CPU-ms | — | — | 75.7 1.0c | 8.631 12.1c | — |
| sum(int64, 10% nulls) | 10M | 1.9x | 1–3x | 0.3030.337 CPU-ms | 3.035 1.0c | 0.575 10.5c | 9.342 1.0c | 1.294 10.7c | 9.155 1.0c |
| max(int64, 10% nulls) | 50M | 1.9x | 1–3x | 1.1720.497 CPU-ms | 13.7 1.0c | 2.218 10.1c | 50.5 1.0c | 5.083 13.4c | 50.6 1.0c |
| week | 10M | 1.9x | 1–3x | 5.0280.707 CPU-ms | 111.6 1.0c | 9.496 14.4c | 126.1 1.0c | 13.9 10.7c | 284.6 1.0c |
| week | 50M | 1.9x | 1–3x | 24.21.841 CPU-ms | 557.3 1.0c | 45.0 15.3c | 587.4 1.0c | 56.0 13.4c | 1,391 1.0c |
| list_value_length | 10M | 1.8x | 1–3x | 0.3610.372 CPU-ms | 5.468 1.0c | 0.733 10.2c | 0.730 1.0c | 0.659 9.6c | 0.788 1.0c |
| multiply scalar (int64)re-measured in place after the full run flagged it (same build, quieter machine) | 10M | 1.8x | 1–3x | 0.4820.356 CPU-ms | 4.589 1.0c | 0.875 11.8c | 2.616 1.0c | 1.049 9.4c | 10.3 1.0c |
| match_like("cust%") [pure prefix]a pure prefix pattern, which Regex.likePredicate maps onto the GPU starts_with kernel | 10M | 1.8x | 1–3x | 1.1490.422 CPU-ms | 23.0 1.0c | 2.065 12.8c | 18.9 1.0c | 2.115 11.1c | 185.8 1.0c |
| coalesce (2 int64 columns) | 50M | 1.8x | 1–3x | 3.3150.413 CPU-ms | 55.3 1.0c | 5.887 14.0c | 74.5 1.0c | 8.480 12.5c | 146.5 1.0c |
| decimal add (128-bit) | 10M | 1.8x | 1–3x | 1.4360.394 CPU-ms | 55.3 1.0c | 4.356 13.7c | 15.0 1.0c | 2.538 10.1c | 15.0 1.0c |
| add_checked (int64 + int64) | 10M | 1.7x | 1–3x | 1.1670.504 CPU-ms | — | — | 15.2 1.0c | 2.037 10.1c | — |
| concat (a + '-' + b) | 1M | 1.7x | 1–3x | 1.2461.157 CPU-ms | 30.4 1.0c | 2.611 11.0c | 20.1 1.0c | 2.138 10.9c | 37.1 1.0c |
| min(int64, 10% nulls)re-measured in place after the full run flagged it (same build, quieter machine) | 50M | 1.7x | 1–3x | 1.1830.554 CPU-ms | 13.4 1.0c | 2.015 10.1c | 47.2 1.0c | 5.054 13.3c | 47.7 1.0c |
| count_distinct(int64) | 10M | 1.7x | 1–3x | 2.8722.054 CPU-ms | 48.9 2.6c | 49.1 2.5c | 37.1 1.0c | 4.830 10.4c | 38.7 1.0c |
match_like("cust_1%") [_ wildcard]_ is LIKE's single-character wildcard, so this is not a pure prefix and takes the ICU host path | 1M | 1.7x | 1–3x | 0.9460.419 CPU-ms | 10.1 1.0c | 1.582 8.4c | 18.3 1.0c | 2.024 11.1c | 20.5 1.0c |
| index_in (int64, 100-value set) | 10M | 1.7x | 1–3x | 4.0312.629 CPU-ms | — | — | 62.5 1.0c | 6.696 11.7c | 32.9 numpy 1.0c |
| sum by utf8 key (1000 distinct) | 10M | 1.7x | 1–3x | 5.6613.371 CPU-ms | 30.9 10.7c | 32.7 12.2c | 9.396 9.3c | 9.480 10.7c | 104.5 1.0c |
| is_in (int64, 100-value set)re-measured in place after the full run flagged it (same build, quieter machine) | 10M | 1.7x | 1–3x | 2.2081.620 CPU-ms | 43.7 1.0c | 3.646 12.3c | 74.3 1.0c | 8.145 11.9c | 78.5 1.0c |
| skew(float64) | 50M | 1.6x | 1–3x | 10.80.796 CPU-ms | 50.2 1.0c | 127.7 1.0c | 193.1 1.0c | 17.6 13.2c | 95.9 1.0c |
| skew(float64) | 10M | 1.6x | 1–3x | 2.4820.771 CPU-ms | 9.476 1.0c | 24.5 1.0c | 36.0 1.0c | 4.039 11.7c | 18.4 1.0c |
| multiply array (int64 * int64) | 10M | 1.6x | 1–3x | 0.7130.419 CPU-ms | 5.214 1.0c | 1.137 11.3c | 3.102 1.0c | 1.211 10.3c | 28.3 1.0c |
| add array (int64 + int64) | 10M | 1.6x | 1–3x | 0.6840.406 CPU-ms | 5.133 1.0c | 1.085 11.4c | 2.904 1.0c | 1.228 10.8c | 28.3 1.0c |
| is_nan (float64) | 50M | 1.6x | 1–3x | 1.2100.379 CPU-ms | 4.872 1.0c | 1.916 13.0c | 9.664 1.0c | 3.497 11.0c | 4.938 numpy 1.0c |
| starts_with("cust_1") | 10M | 1.6x | 1–3x | 1.8120.406 CPU-ms | 35.3 1.0c | 2.841 14.6c | 31.0 1.0c | 3.392 11.1c | 31.0 1.0c |
| add_duration (+1h) | 50M | 1.6x | 1–3x | 2.0890.383 CPU-ms | 25.3 1.0c | 3.260 12.7c | 13.2 1.0c | 4.367 12.0c | 182.7 1.0c |
| decimal compare (> scalar) | 50M | 1.6x | 1–3x | 2.1970.405 CPU-ms | 14.9 1.0c | 3.411 14.0c | 41.9 1.0c | 5.506 12.8c | 42.1 1.0c |
| add scalar (int64) | 50M | 1.5x | 1–3x | 1.9470.414 CPU-ms | 23.3 1.0c | 2.997 12.1c | 13.3 1.0c | 4.444 11.3c | 51.9 1.0c |
| round (float64) | 50M | 1.5x | 1–3x | 3.1790.406 CPU-ms | 51.1 1.0c | 4.725 9.6c | 112.1 1.0c | 11.5 12.3c | 110.1 1.0c |
| is_in (utf8, 100-value set) | 10M | 1.5x | 1–3x | 3.8152.000 CPU-ms | 96.0 1.0c | 5.663 13.6c | 104.8 1.0c | 10.6 11.7c | 109.4 1.0c |
| add_duration (+1h) | 10M | 1.5x | 1–3x | 0.5410.373 CPU-ms | 4.710 1.0c | 0.800 9.8c | 2.663 1.0c | 1.005 9.8c | 37.6 1.0c |
| pad_left (width 20) | 1M | 1.5x | 1–3x | 1.2981.070 CPU-ms | 16.9 1.0c | 2.051 9.6c | 18.3 1.0c | 1.895 11.6c | 18.4 1.0c |
| bit_wise_and (int64) | 50M | 1.5x | 1–3x | 2.9660.626 CPU-ms | 28.0 1.0c | 4.321 13.3c | 86.6 1.0c | 9.372 12.5c | 10.1 numpy 1.0c |
| multiply array (int64 * int64) | 50M | 1.5x | 1–3x | 2.9640.619 CPU-ms | 27.8 1.0c | 4.318 13.8c | 15.1 1.0c | 5.909 11.4c | 147.5 1.0c |
| variance(float64, ddof=1) | 10M | 1.4x | 1–3x | 1.9310.797 CPU-ms | 9.603 1.0c | 9.816 1.0c | 23.7 1.0c | 2.797 11.4c | 23.8 1.0c |
| negate (int64) | 50M | 1.4x | 1–3x | 2.1440.403 CPU-ms | 23.4 1.0c | 3.095 13.0c | 13.3 1.0c | 3.975 10.8c | 52.5 1.0c |
| hash64 (int64) | 50M | 1.4x | 1–3x | 3.2000.418 CPU-ms | 55.4 1.0c | 4.537 13.2c | — | — | 79.8 1.0c |
| if_else (bool ? int64 : int64) | 50M | 1.4x | 1–3x | 3.7450.958 CPU-ms | 27.2 1.0c | 5.307 13.6c | 122.7 1.0c | 12.7 12.5c | 14.6 numpy 1.0c |
| add scalar (int64) | 10M | 1.4x | 1–3x | 0.5470.373 CPU-ms | 4.352 1.0c | 0.775 10.1c | 2.703 1.0c | 1.013 10.5c | 10.0 1.0c |
| stddev(float64, ddof=1) | 10M | 1.4x | 1–3x | 1.9230.778 CPU-ms | 9.767 1.0c | 9.531 1.0c | 23.4 1.0c | 2.704 11.8c | 23.9 1.0c |
| max by int32 key (1000 groups) | 10M | 1.4x | 1–3x | 3.5251.460 CPU-ms | 19.9 11.9c | 20.7 11.7c | 5.087 9.2c | 4.942 10.9c | 53.1 1.0c |
| add array (int64 + int64) | 50M | 1.4x | 1–3x | 3.1230.614 CPU-ms | 27.0 1.0c | 4.313 12.8c | 15.2 1.0c | 5.643 12.0c | 147.5 1.0c |
| min_max(int64) | 50M | 1.3x | 1–3x | 3.7651.598 CPU-ms | 27.4 1.0c | 14.1 2.7c | 50.6 1.0c | 5.074 13.3c | 101.4 1.0c |
| decimal multiply (by scalar) | 10M | 1.3x | 1–3x | 1.6040.399 CPU-ms | 91.0 1.0c | 7.410 14.4c | 14.9 1.0c | 2.161 10.4c | 15.2 1.0c |
| min by int32 key (1000 groups) | 10M | 1.3x | 1–3x | 3.7081.642 CPU-ms | 20.3 11.9c | 20.5 11.4c | 5.060 9.2c | 4.989 10.9c | 52.4 1.0c |
| compare scalar (int64 > 0) | 10M | 1.3x | 1–3x | 0.4710.381 CPU-ms | 0.875 1.0c | 0.610 8.0c | 1.200 1.0c | 0.843 9.7c | 1.283 1.0c |
| max by key, float64 (1000 groups) | 10M | 1.3x | 1–3x | 3.7651.626 CPU-ms | 19.6 11.9c | 20.1 11.7c | 4.998 9.2c | 4.834 11.0c | 51.0 1.0c |
| bit_wise_and (int64) | 10M | 1.3x | 1–3x | 0.8560.432 CPU-ms | 5.053 1.0c | 1.098 11.2c | 16.5 1.0c | 2.137 10.3c | 1.856 numpy 1.0c |
| filter int64 (30% kept)re-measured in place after the full run flagged it (same build, quieter machine) | 50M | 1.3x | 1–3x | 2.2290.673 CPU-ms | 17.5 1.0c | 2.845 12.6c | 122.7 1.0c | 22.6 13.2c | 157.0 1.0c |
| starts_with("cust_1") | 1M | 1.3x | 1–3x | 0.3410.352 CPU-ms | |