0001 ================================================================================================
0002 Join Benchmark
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 Join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 Join w long wholestage off 4531 4557 37 4.6 216.1 1.0X
0010 Join w long wholestage on 1214 1310 95 17.3 57.9 3.7X
0011
0012 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0013 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0014 Join w long duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0015 ------------------------------------------------------------------------------------------------------------------------
0016 Join w long duplicated wholestage off 5200 5239 55 4.0 248.0 1.0X
0017 Join w long duplicated wholestage on 1535 1547 11 13.7 73.2 3.4X
0018
0019 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0020 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0021 Join w 2 ints: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0022 ------------------------------------------------------------------------------------------------------------------------
0023 Join w 2 ints wholestage off 170776 170795 27 0.1 8143.2 1.0X
0024 Join w 2 ints wholestage on 165134 165183 36 0.1 7874.2 1.0X
0025
0026 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0027 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0028 Join w 2 longs: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0029 ------------------------------------------------------------------------------------------------------------------------
0030 Join w 2 longs wholestage off 6561 6595 48 3.2 312.8 1.0X
0031 Join w 2 longs wholestage on 2999 3070 85 7.0 143.0 2.2X
0032
0033 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0034 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0035 Join w 2 longs duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0036 ------------------------------------------------------------------------------------------------------------------------
0037 Join w 2 longs duplicated wholestage off 15731 15757 38 1.3 750.1 1.0X
0038 Join w 2 longs duplicated wholestage on 8017 8112 80 2.6 382.3 2.0X
0039
0040 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0041 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0042 outer join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0043 ------------------------------------------------------------------------------------------------------------------------
0044 outer join w long wholestage off 3573 3577 6 5.9 170.4 1.0X
0045 outer join w long wholestage on 1310 1325 15 16.0 62.5 2.7X
0046
0047 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0048 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0049 semi join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0050 ------------------------------------------------------------------------------------------------------------------------
0051 semi join w long wholestage off 1893 1916 33 11.1 90.3 1.0X
0052 semi join w long wholestage on 819 842 30 25.6 39.0 2.3X
0053
0054 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0055 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0056 sort merge join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0057 ------------------------------------------------------------------------------------------------------------------------
0058 sort merge join wholestage off 1302 1312 13 1.6 620.9 1.0X
0059 sort merge join wholestage on 1168 1233 62 1.8 557.0 1.1X
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 sort merge join with duplicates: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0064 ------------------------------------------------------------------------------------------------------------------------
0065 sort merge join with duplicates wholestage off 1996 2005 12 1.1 951.7 1.0X
0066 sort merge join with duplicates wholestage on 1766 1803 42 1.2 842.0 1.1X
0067
0068 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0069 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0070 shuffle hash join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0071 ------------------------------------------------------------------------------------------------------------------------
0072 shuffle hash join wholestage off 1298 1300 3 3.2 309.6 1.0X
0073 shuffle hash join wholestage on 1201 1210 10 3.5 286.4 1.1X
0074
0075