0001 ================================================================================================
0002 SQL Single Numeric Column Scan
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 SQL Single TINYINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 Sum 2689 2694 7 5.8 170.9 1.0X
0010
0011 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0012 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0013 SQL Single SMALLINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0014 ------------------------------------------------------------------------------------------------------------------------
0015 Sum 2741 2759 26 5.7 174.2 1.0X
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 SQL Single INT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0020 ------------------------------------------------------------------------------------------------------------------------
0021 Sum 2736 2748 17 5.7 173.9 1.0X
0022
0023 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0024 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0025 SQL Single BIGINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0026 ------------------------------------------------------------------------------------------------------------------------
0027 Sum 3305 3317 17 4.8 210.2 1.0X
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 SQL Single FLOAT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0032 ------------------------------------------------------------------------------------------------------------------------
0033 Sum 2904 2952 68 5.4 184.6 1.0X
0034
0035 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0036 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0037 SQL Single DOUBLE Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0038 ------------------------------------------------------------------------------------------------------------------------
0039 Sum 3090 3093 4 5.1 196.5 1.0X
0040
0041
0042 ================================================================================================
0043 Int and String Scan
0044 ================================================================================================
0045
0046 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0047 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0048 Int and String Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0049 ------------------------------------------------------------------------------------------------------------------------
0050 Sum of columns 5351 5365 20 2.0 510.3 1.0X
0051
0052
0053 ================================================================================================
0054 Partitioned Table Scan
0055 ================================================================================================
0056
0057 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0058 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0059 Partitioned Table: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0060 ------------------------------------------------------------------------------------------------------------------------
0061 Data column 3278 3288 14 4.8 208.4 1.0X
0062 Partition column 3149 3193 62 5.0 200.2 1.0X
0063 Both columns 3198 3204 7 4.9 203.4 1.0X
0064
0065
0066 ================================================================================================
0067 Repeated String Scan
0068 ================================================================================================
0069
0070 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0071 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0072 Repeated String: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0073 ------------------------------------------------------------------------------------------------------------------------
0074 Sum of string length 3435 3438 5 3.1 327.6 1.0X
0075
0076
0077 ================================================================================================
0078 String with Nulls Scan
0079 ================================================================================================
0080
0081 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0082 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0083 String with Nulls Scan (0.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0084 ------------------------------------------------------------------------------------------------------------------------
0085 Sum of string length 5634 5650 23 1.9 537.3 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 String with Nulls Scan (50.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0090 ------------------------------------------------------------------------------------------------------------------------
0091 Sum of string length 4725 4752 39 2.2 450.6 1.0X
0092
0093 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0094 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0095 String with Nulls Scan (95.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0096 ------------------------------------------------------------------------------------------------------------------------
0097 Sum of string length 3550 3566 23 3.0 338.6 1.0X
0098
0099
0100 ================================================================================================
0101 Single Column Scan From Wide Columns
0102 ================================================================================================
0103
0104 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0105 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0106 Single Column Scan from 100 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0107 ------------------------------------------------------------------------------------------------------------------------
0108 Sum of single column 5271 5279 11 0.2 5027.0 1.0X
0109
0110 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0111 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0112 Single Column Scan from 200 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0113 ------------------------------------------------------------------------------------------------------------------------
0114 Sum of single column 10393 10516 174 0.1 9911.3 1.0X
0115
0116 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0117 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0118 Single Column Scan from 300 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0119 ------------------------------------------------------------------------------------------------------------------------
0120 Sum of single column 15330 15343 19 0.1 14619.6 1.0X
0121
0122