0001 ================================================================================================
0002 filter & aggregate without group
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 range/filter/sum: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 range/filter/sum wholestage off 54616 54834 309 38.4 26.0 1.0X
0010 range/filter/sum wholestage on 3263 3369 129 642.6 1.6 16.7X
0011
0012
0013 ================================================================================================
0014 range/limit/sum
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 range/limit/sum: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0020 ------------------------------------------------------------------------------------------------------------------------
0021 range/limit/sum wholestage off 239 265 36 2190.0 0.5 1.0X
0022 range/limit/sum wholestage on 137 162 15 3814.6 0.3 1.7X
0023
0024
0025 ================================================================================================
0026 sample
0027 ================================================================================================
0028
0029 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0030 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0031 sample with replacement: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0032 ------------------------------------------------------------------------------------------------------------------------
0033 sample with replacement wholestage off 13093 13417 458 10.0 99.9 1.0X
0034 sample with replacement wholestage on 7606 7624 13 17.2 58.0 1.7X
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 sample without replacement: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0039 ------------------------------------------------------------------------------------------------------------------------
0040 sample without replacement wholestage off 3031 3038 9 43.2 23.1 1.0X
0041 sample without replacement wholestage on 1156 1177 16 113.4 8.8 2.6X
0042
0043
0044 ================================================================================================
0045 collect
0046 ================================================================================================
0047
0048 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0049 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0050 collect: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0051 ------------------------------------------------------------------------------------------------------------------------
0052 collect 1 million 335 360 20 3.1 319.0 1.0X
0053 collect 2 millions 579 633 42 1.8 552.2 0.6X
0054 collect 4 millions 1192 1331 196 0.9 1137.1 0.3X
0055
0056
0057 ================================================================================================
0058 collect limit
0059 ================================================================================================
0060
0061 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0062 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0063 collect limit: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0064 ------------------------------------------------------------------------------------------------------------------------
0065 collect limit 1 million 378 386 12 2.8 360.8 1.0X
0066 collect limit 2 millions 724 733 12 1.4 690.3 0.5X
0067
0068
0069 ================================================================================================
0070 generate explode
0071 ================================================================================================
0072
0073 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0074 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0075 generate explode array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0076 ------------------------------------------------------------------------------------------------------------------------
0077 generate explode array wholestage off 15880 16159 395 1.1 946.5 1.0X
0078 generate explode array wholestage on 15690 15783 73 1.1 935.2 1.0X
0079
0080 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0081 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0082 generate explode map: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0083 ------------------------------------------------------------------------------------------------------------------------
0084 generate explode map wholestage off 51293 51311 26 0.3 3057.3 1.0X
0085 generate explode map wholestage on 50409 50795 388 0.3 3004.6 1.0X
0086
0087 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0088 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0089 generate posexplode array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0090 ------------------------------------------------------------------------------------------------------------------------
0091 generate posexplode array wholestage off 17246 17860 869 1.0 1027.9 1.0X
0092 generate posexplode array wholestage on 17344 17472 88 1.0 1033.8 1.0X
0093
0094 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0095 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0096 generate inline array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0097 ------------------------------------------------------------------------------------------------------------------------
0098 generate inline array wholestage off 13698 13790 130 1.2 816.5 1.0X
0099 generate inline array wholestage on 12995 13033 38 1.3 774.6 1.1X
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 generate big struct array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0104 ------------------------------------------------------------------------------------------------------------------------
0105 generate big struct array wholestage off 476 489 18 0.1 7938.6 1.0X
0106 generate big struct array wholestage on 424 440 14 0.1 7074.9 1.1X
0107
0108 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0109 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0110 generate big nested struct array: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0111 ------------------------------------------------------------------------------------------------------------------------
0112 generate big nested struct array wholestage off 413 433 28 0.1 6886.8 1.0X
0113 generate big nested struct array wholestage on 394 420 39 0.2 6560.9 1.0X
0114
0115
0116 ================================================================================================
0117 generate regular generator
0118 ================================================================================================
0119
0120 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0121 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0122 generate stack: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0123 ------------------------------------------------------------------------------------------------------------------------
0124 generate stack wholestage off 26494 26510 23 0.6 1579.2 1.0X
0125 generate stack wholestage on 24205 24339 80 0.7 1442.8 1.1X
0126
0127