0001 ================================================================================================
0002 filter & aggregate without group
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 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 46812 48110 1836 44.8 22.3 1.0X
0010 range/filter/sum wholestage on 3116 3656 309 673.1 1.5 15.0X
0011
0012
0013 ================================================================================================
0014 range/limit/sum
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 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 200 219 27 2621.6 0.4 1.0X
0022 range/limit/sum wholestage on 117 125 7 4477.8 0.2 1.7X
0023
0024
0025 ================================================================================================
0026 sample
0027 ================================================================================================
0028
0029 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 12963 13506 768 10.1 98.9 1.0X
0034 sample with replacement wholestage on 7397 7742 300 17.7 56.4 1.8X
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 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 2977 2977 0 44.0 22.7 1.0X
0041 sample without replacement wholestage on 1087 1099 13 120.6 8.3 2.7X
0042
0043
0044 ================================================================================================
0045 collect
0046 ================================================================================================
0047
0048 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 281 315 34 3.7 268.2 1.0X
0053 collect 2 millions 531 564 28 2.0 506.6 0.5X
0054 collect 4 millions 1179 1970 1118 0.9 1124.5 0.2X
0055
0056
0057 ================================================================================================
0058 collect limit
0059 ================================================================================================
0060
0061 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 344 352 5 3.0 328.0 1.0X
0066 collect limit 2 millions 656 660 6 1.6 625.2 0.5X
0067
0068
0069 ================================================================================================
0070 generate explode
0071 ================================================================================================
0072
0073 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 14664 14780 164 1.1 874.0 1.0X
0078 generate explode array wholestage on 14789 14886 87 1.1 881.5 1.0X
0079
0080 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 50441 51014 811 0.3 3006.5 1.0X
0085 generate explode map wholestage on 49164 49915 892 0.3 2930.4 1.0X
0086
0087 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 17101 17130 40 1.0 1019.3 1.0X
0092 generate posexplode array wholestage on 15625 15675 46 1.1 931.3 1.1X
0093
0094 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 13923 14720 1127 1.2 829.9 1.0X
0099 generate inline array wholestage on 12246 12591 695 1.4 729.9 1.1X
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 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 442 456 20 0.1 7368.2 1.0X
0106 generate big struct array wholestage on 409 429 22 0.1 6823.9 1.1X
0107
0108 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 409 415 8 0.1 6822.4 1.0X
0113 generate big nested struct array wholestage on 401 414 23 0.1 6687.0 1.0X
0114
0115
0116 ================================================================================================
0117 generate regular generator
0118 ================================================================================================
0119
0120 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 27043 27118 106 0.6 1611.9 1.0X
0125 generate stack wholestage on 24002 24036 34 0.7 1430.6 1.1X
0126
0127