================================================================================================
aggregate without grouping
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
agg w/o group:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
agg w/o group wholestage off                      43452          45977        3571         48.3          20.7       1.0X
agg w/o group wholestage on                        2959           2964           4        708.7           1.4      14.7X


================================================================================================
stat functions
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
stddev:                                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
stddev wholestage off                              4555           4573          26         23.0          43.4       1.0X
stddev wholestage on                                849            856           6        123.5           8.1       5.4X

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
kurtosis:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
kurtosis wholestage off                           27341          27358          24          3.8         260.7       1.0X
kurtosis wholestage on                              947            951           6        110.8           9.0      28.9X


================================================================================================
aggregate with linear keys
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Aggregate w keys:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
codegen = F                                        7630           8038         577         11.0          91.0       1.0X
codegen = T, hashmap = F                           4040           4076          44         20.8          48.2       1.9X
codegen = T, row-based hashmap = T                 1139           1179          67         73.7          13.6       6.7X
codegen = T, vectorized hashmap = T                 781            786           5        107.4           9.3       9.8X


================================================================================================
aggregate with randomized keys
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Aggregate w keys:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
codegen = F                                        6300           6378         111         13.3          75.1       1.0X
codegen = T, hashmap = F                           3752           3810          51         22.4          44.7       1.7X
codegen = T, row-based hashmap = T                 1712           1719           5         49.0          20.4       3.7X
codegen = T, vectorized hashmap = T                1179           1209          17         71.2          14.1       5.3X


================================================================================================
aggregate with string key
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Aggregate w string key:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
codegen = F                                        2182           2239          81          9.6         104.0       1.0X
codegen = T, hashmap = F                           1300           1308          11         16.1          62.0       1.7X
codegen = T, row-based hashmap = T                  950            958           7         22.1          45.3       2.3X
codegen = T, vectorized hashmap = T                 800            805           4         26.2          38.2       2.7X


================================================================================================
aggregate with decimal key
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Aggregate w decimal key:                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
codegen = F                                        2547           2647         142          8.2         121.4       1.0X
codegen = T, hashmap = F                           1499           1525          36         14.0          71.5       1.7X
codegen = T, row-based hashmap = T                  521            534          17         40.2          24.9       4.9X
codegen = T, vectorized hashmap = T                 320            324           2         65.5          15.3       8.0X


================================================================================================
aggregate with multiple key types
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
Aggregate w multiple keys:                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
codegen = F                                        4153           4206          74          5.0         198.1       1.0X
codegen = T, hashmap = F                           1962           1982          29         10.7          93.5       2.1X
codegen = T, row-based hashmap = T                 1606           1621          21         13.1          76.6       2.6X
codegen = T, vectorized hashmap = T                1528           1528           0         13.7          72.8       2.7X


================================================================================================
max function bytecode size of wholestagecodegen
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
max function bytecode size:               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
codegen = F                                         408            428          33          1.6         622.9       1.0X
codegen = T, hugeMethodLimit = 10000                131            144          14          5.0         199.9       3.1X
codegen = T, hugeMethodLimit = 1500                 129            139          11          5.1         197.0       3.2X


================================================================================================
cube
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
cube:                                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cube wholestage off                                1781           1814          46          2.9         339.8       1.0X
cube wholestage on                                  909            921          10          5.8         173.3       2.0X


================================================================================================
hash and BytesToBytesMap
================================================================================================

OpenJDK 64-Bit Server VM 25.0.2+10-LTS on Linux 6.14.0-1017-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
BytesToBytesMap:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
UnsafeRowhash                                       116            116           0        181.5           5.5       1.0X
murmur3 hash                                         47             47           0        447.7           2.2       2.5X
fast hash                                            39             40           0        531.3           1.9       2.9X
arrayEqual                                          121            121           0        173.3           5.8       1.0X
Java HashMap (Long)                                  67             82          11        314.5           3.2       1.7X
Java HashMap (two ints)                              83             86           3        252.7           4.0       1.4X
Java HashMap (UnsafeRow)                            471            472           1         44.5          22.5       0.2X
LongToUnsafeRowMap (opt=false)                      361            361           1         58.1          17.2       0.3X
LongToUnsafeRowMap (opt=true)                        63             67           5        332.2           3.0       1.8X
BytesToBytesMap (off Heap)                          437            443           5         48.0          20.8       0.3X
BytesToBytesMap (on Heap)                           450            454           4         46.6          21.4       0.3X
Aggregate HashMap                                    40             40           0        522.2           1.9       2.9X


