0001 ================================================================================================
0002 aggregate without grouping
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0006 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0007 agg w/o group: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 agg w/o group wholestage off 49902 52257 NaN 42.0 23.8 1.0X
0010 agg w/o group wholestage on 1162 1171 10 1805.2 0.6 43.0X
0011
0012
0013 ================================================================================================
0014 stat functions
0015 ================================================================================================
0016
0017 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0018 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0019 stddev: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0020 ------------------------------------------------------------------------------------------------------------------------
0021 stddev wholestage off 8203 8243 56 12.8 78.2 1.0X
0022 stddev wholestage on 1287 1303 10 81.5 12.3 6.4X
0023
0024 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0025 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0026 kurtosis: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0027 ------------------------------------------------------------------------------------------------------------------------
0028 kurtosis wholestage off 39557 39919 511 2.7 377.2 1.0X
0029 kurtosis wholestage on 1398 1476 138 75.0 13.3 28.3X
0030
0031
0032 ================================================================================================
0033 aggregate with linear keys
0034 ================================================================================================
0035
0036 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0037 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0038 Aggregate w keys: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0039 ------------------------------------------------------------------------------------------------------------------------
0040 codegen = F 11236 12182 1337 7.5 133.9 1.0X
0041 codegen = T hashmap = F 7079 7337 250 11.9 84.4 1.6X
0042 codegen = T hashmap = T 1278 1419 186 65.6 15.2 8.8X
0043
0044
0045 ================================================================================================
0046 aggregate with randomized keys
0047 ================================================================================================
0048
0049 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0050 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0051 Aggregate w keys: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0052 ------------------------------------------------------------------------------------------------------------------------
0053 codegen = F 11629 11650 30 7.2 138.6 1.0X
0054 codegen = T hashmap = F 7552 7747 169 11.1 90.0 1.5X
0055 codegen = T hashmap = T 2414 2662 167 34.7 28.8 4.8X
0056
0057
0058 ================================================================================================
0059 aggregate with string key
0060 ================================================================================================
0061
0062 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0063 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0064 Aggregate w string key: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0065 ------------------------------------------------------------------------------------------------------------------------
0066 codegen = F 4790 4904 162 4.4 228.4 1.0X
0067 codegen = T hashmap = F 3439 3504 105 6.1 164.0 1.4X
0068 codegen = T hashmap = T 2327 2365 39 9.0 111.0 2.1X
0069
0070
0071 ================================================================================================
0072 aggregate with decimal key
0073 ================================================================================================
0074
0075 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0076 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0077 Aggregate w decimal key: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0078 ------------------------------------------------------------------------------------------------------------------------
0079 codegen = F 3260 3418 223 6.4 155.5 1.0X
0080 codegen = T hashmap = F 2316 2325 14 9.1 110.4 1.4X
0081 codegen = T hashmap = T 605 607 2 34.7 28.8 5.4X
0082
0083
0084 ================================================================================================
0085 aggregate with multiple key types
0086 ================================================================================================
0087
0088 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0089 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0090 Aggregate w multiple keys: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0091 ------------------------------------------------------------------------------------------------------------------------
0092 codegen = F 7426 7473 67 2.8 354.1 1.0X
0093 codegen = T hashmap = F 4685 4723 54 4.5 223.4 1.6X
0094 codegen = T hashmap = T 3946 4005 83 5.3 188.2 1.9X
0095
0096
0097 ================================================================================================
0098 max function bytecode size of wholestagecodegen
0099 ================================================================================================
0100
0101 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0102 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0103 max function bytecode size: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0104 ------------------------------------------------------------------------------------------------------------------------
0105 codegen = F 628 672 49 1.0 958.4 1.0X
0106 codegen = T hugeMethodLimit = 10000 357 373 12 1.8 545.3 1.8X
0107 codegen = T hugeMethodLimit = 1500 344 356 7 1.9 525.6 1.8X
0108
0109
0110 ================================================================================================
0111 cube
0112 ================================================================================================
0113
0114 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0115 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0116 cube: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0117 ------------------------------------------------------------------------------------------------------------------------
0118 cube wholestage off 3167 3266 140 1.7 604.1 1.0X
0119 cube wholestage on 1549 1576 29 3.4 295.4 2.0X
0120
0121
0122 ================================================================================================
0123 hash and BytesToBytesMap
0124 ================================================================================================
0125
0126 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0127 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0128 BytesToBytesMap: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0129 ------------------------------------------------------------------------------------------------------------------------
0130 UnsafeRowhash 326 328 2 64.3 15.5 1.0X
0131 murmur3 hash 147 147 0 142.7 7.0 2.2X
0132 fast hash 74 75 1 282.3 3.5 4.4X
0133 arrayEqual 175 175 0 119.8 8.3 1.9X
0134 Java HashMap (Long) 138 140 4 152.1 6.6 2.4X
0135 Java HashMap (two ints) 148 154 7 141.7 7.1 2.2X
0136 Java HashMap (UnsafeRow) 1043 1090 66 20.1 49.8 0.3X
0137 LongToUnsafeRowMap (opt=false) 464 466 2 45.2 22.1 0.7X
0138 LongToUnsafeRowMap (opt=true) 104 106 8 202.3 4.9 3.1X
0139 BytesToBytesMap (off Heap) 1140 1149 12 18.4 54.4 0.3X
0140 BytesToBytesMap (on Heap) 1002 1132 183 20.9 47.8 0.3X
0141 Aggregate HashMap 74 74 0 281.9 3.5 4.4X
0142
0143
