0001 ================================================================================================
0002 aggregate without grouping
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 59499 62969 2375 35.2 28.4 1.0X
0010 agg w/o group wholestage on 890 902 10 2357.2 0.4 66.9X
0011
0012
0013 ================================================================================================
0014 stat functions
0015 ================================================================================================
0016
0017 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 8702 8870 237 12.0 83.0 1.0X
0022 stddev wholestage on 1307 1314 9 80.2 12.5 6.7X
0023
0024 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 42656 42797 198 2.5 406.8 1.0X
0029 kurtosis wholestage on 1440 1466 32 72.8 13.7 29.6X
0030
0031
0032 ================================================================================================
0033 aggregate with linear keys
0034 ================================================================================================
0035
0036 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 10963 11035 101 7.7 130.7 1.0X
0041 codegen = T hashmap = F 6852 7080 207 12.2 81.7 1.6X
0042 codegen = T hashmap = T 1377 1421 43 60.9 16.4 8.0X
0043
0044
0045 ================================================================================================
0046 aggregate with randomized keys
0047 ================================================================================================
0048
0049 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 12240 12296 80 6.9 145.9 1.0X
0054 codegen = T hashmap = F 8318 8376 87 10.1 99.2 1.5X
0055 codegen = T hashmap = T 2551 2617 80 32.9 30.4 4.8X
0056
0057
0058 ================================================================================================
0059 aggregate with string key
0060 ================================================================================================
0061
0062 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 4442 4504 88 4.7 211.8 1.0X
0067 codegen = T hashmap = F 2685 2778 95 7.8 128.0 1.7X
0068 codegen = T hashmap = T 1181 1203 15 17.8 56.3 3.8X
0069
0070
0071 ================================================================================================
0072 aggregate with decimal key
0073 ================================================================================================
0074
0075 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 3487 3534 66 6.0 166.3 1.0X
0080 codegen = T hashmap = F 2239 2353 161 9.4 106.8 1.6X
0081 codegen = T hashmap = T 664 693 26 31.6 31.7 5.3X
0082
0083
0084 ================================================================================================
0085 aggregate with multiple key types
0086 ================================================================================================
0087
0088 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 6414 6475 86 3.3 305.9 1.0X
0093 codegen = T hashmap = F 3776 3800 34 5.6 180.1 1.7X
0094 codegen = T hashmap = T 2824 2852 40 7.4 134.7 2.3X
0095
0096
0097 ================================================================================================
0098 max function bytecode size of wholestagecodegen
0099 ================================================================================================
0100
0101 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 654 696 36 1.0 998.6 1.0X
0106 codegen = T hugeMethodLimit = 10000 378 405 24 1.7 577.1 1.7X
0107 codegen = T hugeMethodLimit = 1500 383 403 22 1.7 584.3 1.7X
0108
0109
0110 ================================================================================================
0111 cube
0112 ================================================================================================
0113
0114 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 3443 3444 1 1.5 656.7 1.0X
0119 cube wholestage on 1797 1815 20 2.9 342.7 1.9X
0120
0121
0122 ================================================================================================
0123 hash and BytesToBytesMap
0124 ================================================================================================
0125
0126 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 313 314 2 67.1 14.9 1.0X
0131 murmur3 hash 144 145 2 145.9 6.9 2.2X
0132 fast hash 70 72 5 301.5 3.3 4.5X
0133 arrayEqual 189 190 0 111.0 9.0 1.7X
0134 Java HashMap (Long) 129 132 4 162.4 6.2 2.4X
0135 Java HashMap (two ints) 148 154 7 142.0 7.0 2.1X
0136 Java HashMap (UnsafeRow) 839 840 1 25.0 40.0 0.4X
0137 LongToUnsafeRowMap (opt=false) 462 464 1 45.4 22.0 0.7X
0138 LongToUnsafeRowMap (opt=true) 108 108 1 194.2 5.2 2.9X
0139 BytesToBytesMap (off Heap) 1027 1029 2 20.4 49.0 0.3X
0140 BytesToBytesMap (on Heap) 999 1001 3 21.0 47.6 0.3X
0141 Aggregate HashMap 44 44 0 477.8 2.1 7.1X
0142
0143
