0001 ================================================================================================
0002 SQL Single Numeric Column Scan
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 SQL Single TINYINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 Sum 3049 3071 32 5.2 193.8 1.0X
0010
0011 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 2982 2992 13 5.3 189.6 1.0X
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 SQL Single INT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0020 ------------------------------------------------------------------------------------------------------------------------
0021 Sum 2984 2989 7 5.3 189.7 1.0X
0022
0023 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 3262 3353 128 4.8 207.4 1.0X
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 SQL Single FLOAT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0032 ------------------------------------------------------------------------------------------------------------------------
0033 Sum 2716 2723 10 5.8 172.7 1.0X
0034
0035 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 2868 2870 3 5.5 182.4 1.0X
0040
0041
0042 ================================================================================================
0043 Int and String Scan
0044 ================================================================================================
0045
0046 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 4714 4739 35 2.2 449.6 1.0X
0051
0052
0053 ================================================================================================
0054 Partitioned Table Scan
0055 ================================================================================================
0056
0057 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 3257 3286 41 4.8 207.1 1.0X
0062 Partition column 3258 3277 27 4.8 207.2 1.0X
0063 Both columns 3399 3405 9 4.6 216.1 1.0X
0064
0065
0066 ================================================================================================
0067 Repeated String Scan
0068 ================================================================================================
0069
0070 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 3292 3316 33 3.2 314.0 1.0X
0075
0076
0077 ================================================================================================
0078 String with Nulls Scan
0079 ================================================================================================
0080
0081 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 5450 5456 9 1.9 519.7 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 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 4410 4435 35 2.4 420.6 1.0X
0092
0093 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 3074 3122 68 3.4 293.2 1.0X
0098
0099
0100 ================================================================================================
0101 Single Column Scan From Wide Columns
0102 ================================================================================================
0103
0104 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 5120 5136 23 0.2 4882.7 1.0X
0109
0110 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 9952 10002 71 0.1 9490.7 1.0X
0115
0116 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 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 14973 14978 7 0.1 14279.8 1.0X
0121
0122