0001 ================================================================================================
0002 datetime +/- interval
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0006 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0007 datetime +/- interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 date + interval(m) 1660 1745 120 6.0 166.0 1.0X
0010 date + interval(m, d) 1672 1685 19 6.0 167.2 1.0X
0011 date + interval(m, d, ms) 6462 6481 27 1.5 646.2 0.3X
0012 date - interval(m) 1456 1480 35 6.9 145.6 1.1X
0013 date - interval(m, d) 1501 1509 11 6.7 150.1 1.1X
0014 date - interval(m, d, ms) 6457 6466 12 1.5 645.7 0.3X
0015 timestamp + interval(m) 2941 2944 4 3.4 294.1 0.6X
0016 timestamp + interval(m, d) 3008 3012 6 3.3 300.8 0.6X
0017 timestamp + interval(m, d, ms) 3329 3333 6 3.0 332.9 0.5X
0018 timestamp - interval(m) 2964 2982 26 3.4 296.4 0.6X
0019 timestamp - interval(m, d) 3030 3039 13 3.3 303.0 0.5X
0020 timestamp - interval(m, d, ms) 3312 3313 1 3.0 331.2 0.5X
0021
0022
0023 ================================================================================================
0024 Extract components
0025 ================================================================================================
0026
0027 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0028 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0029 cast to timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0030 ------------------------------------------------------------------------------------------------------------------------
0031 cast to timestamp wholestage off 333 334 0 30.0 33.3 1.0X
0032 cast to timestamp wholestage on 349 368 12 28.6 34.9 1.0X
0033
0034 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0035 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0036 year of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0037 ------------------------------------------------------------------------------------------------------------------------
0038 year of timestamp wholestage off 1229 1229 1 8.1 122.9 1.0X
0039 year of timestamp wholestage on 1218 1223 5 8.2 121.8 1.0X
0040
0041 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0042 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0043 quarter of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0044 ------------------------------------------------------------------------------------------------------------------------
0045 quarter of timestamp wholestage off 1593 1594 2 6.3 159.3 1.0X
0046 quarter of timestamp wholestage on 1515 1529 14 6.6 151.5 1.1X
0047
0048 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0049 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0050 month of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0051 ------------------------------------------------------------------------------------------------------------------------
0052 month of timestamp wholestage off 1222 1246 34 8.2 122.2 1.0X
0053 month of timestamp wholestage on 1207 1232 31 8.3 120.7 1.0X
0054
0055 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0056 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0057 weekofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0058 ------------------------------------------------------------------------------------------------------------------------
0059 weekofyear of timestamp wholestage off 2453 2455 2 4.1 245.3 1.0X
0060 weekofyear of timestamp wholestage on 2357 2380 22 4.2 235.7 1.0X
0061
0062 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0063 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0064 day of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0065 ------------------------------------------------------------------------------------------------------------------------
0066 day of timestamp wholestage off 1216 1219 5 8.2 121.6 1.0X
0067 day of timestamp wholestage on 1205 1221 25 8.3 120.5 1.0X
0068
0069 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0070 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0071 dayofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0072 ------------------------------------------------------------------------------------------------------------------------
0073 dayofyear of timestamp wholestage off 1268 1274 9 7.9 126.8 1.0X
0074 dayofyear of timestamp wholestage on 1253 1268 10 8.0 125.3 1.0X
0075
0076 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0077 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0078 dayofmonth of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0079 ------------------------------------------------------------------------------------------------------------------------
0080 dayofmonth of timestamp wholestage off 1223 1224 1 8.2 122.3 1.0X
0081 dayofmonth of timestamp wholestage on 1231 1246 14 8.1 123.1 1.0X
0082
0083 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0084 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0085 dayofweek of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0086 ------------------------------------------------------------------------------------------------------------------------
0087 dayofweek of timestamp wholestage off 1398 1406 12 7.2 139.8 1.0X
0088 dayofweek of timestamp wholestage on 1387 1399 15 7.2 138.7 1.0X
0089
0090 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0091 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0092 weekday of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0093 ------------------------------------------------------------------------------------------------------------------------
0094 weekday of timestamp wholestage off 1327 1333 9 7.5 132.7 1.0X
0095 weekday of timestamp wholestage on 1329 1333 4 7.5 132.9 1.0X
0096
0097 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0098 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0099 hour of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0100 ------------------------------------------------------------------------------------------------------------------------
0101 hour of timestamp wholestage off 1005 1016 15 9.9 100.5 1.0X
0102 hour of timestamp wholestage on 934 940 4 10.7 93.4 1.1X
0103
0104 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0105 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0106 minute of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0107 ------------------------------------------------------------------------------------------------------------------------
0108 minute of timestamp wholestage off 1003 1009 8 10.0 100.3 1.0X
0109 minute of timestamp wholestage on 934 938 7 10.7 93.4 1.1X
0110
0111 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0112 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0113 second of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0114 ------------------------------------------------------------------------------------------------------------------------
0115 second of timestamp wholestage off 997 998 2 10.0 99.7 1.0X
0116 second of timestamp wholestage on 925 935 8 10.8 92.5 1.1X
0117
0118
0119 ================================================================================================
0120 Current date and time
0121 ================================================================================================
0122
0123 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0124 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0125 current_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0126 ------------------------------------------------------------------------------------------------------------------------
0127 current_date wholestage off 297 297 0 33.7 29.7 1.0X
0128 current_date wholestage on 280 282 2 35.7 28.0 1.1X
0129
0130 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0131 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0132 current_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0133 ------------------------------------------------------------------------------------------------------------------------
0134 current_timestamp wholestage off 307 337 43 32.6 30.7 1.0X
0135 current_timestamp wholestage on 260 284 29 38.4 26.0 1.2X
0136
0137
0138 ================================================================================================
0139 Date arithmetic
0140 ================================================================================================
0141
0142 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0143 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0144 cast to date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0145 ------------------------------------------------------------------------------------------------------------------------
0146 cast to date wholestage off 1066 1073 10 9.4 106.6 1.0X
0147 cast to date wholestage on 997 1003 6 10.0 99.7 1.1X
0148
0149 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0150 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0151 last_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0152 ------------------------------------------------------------------------------------------------------------------------
0153 last_day wholestage off 1238 1242 6 8.1 123.8 1.0X
0154 last_day wholestage on 1259 1272 12 7.9 125.9 1.0X
0155
0156 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0157 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0158 next_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0159 ------------------------------------------------------------------------------------------------------------------------
0160 next_day wholestage off 1116 1138 32 9.0 111.6 1.0X
0161 next_day wholestage on 1052 1063 11 9.5 105.2 1.1X
0162
0163 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0164 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0165 date_add: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0166 ------------------------------------------------------------------------------------------------------------------------
0167 date_add wholestage off 1048 1049 1 9.5 104.8 1.0X
0168 date_add wholestage on 1035 1039 3 9.7 103.5 1.0X
0169
0170 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0171 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0172 date_sub: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0173 ------------------------------------------------------------------------------------------------------------------------
0174 date_sub wholestage off 1119 1127 11 8.9 111.9 1.0X
0175 date_sub wholestage on 1028 1039 7 9.7 102.8 1.1X
0176
0177 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0178 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0179 add_months: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0180 ------------------------------------------------------------------------------------------------------------------------
0181 add_months wholestage off 1421 1421 0 7.0 142.1 1.0X
0182 add_months wholestage on 1423 1434 11 7.0 142.3 1.0X
0183
0184
0185 ================================================================================================
0186 Formatting dates
0187 ================================================================================================
0188
0189 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0190 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0191 format date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0192 ------------------------------------------------------------------------------------------------------------------------
0193 format date wholestage off 5293 5296 5 1.9 529.3 1.0X
0194 format date wholestage on 5143 5157 19 1.9 514.3 1.0X
0195
0196
0197 ================================================================================================
0198 Formatting timestamps
0199 ================================================================================================
0200
0201 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0202 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0203 from_unixtime: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0204 ------------------------------------------------------------------------------------------------------------------------
0205 from_unixtime wholestage off 7136 7136 1 1.4 713.6 1.0X
0206 from_unixtime wholestage on 7049 7068 29 1.4 704.9 1.0X
0207
0208
0209 ================================================================================================
0210 Convert timestamps
0211 ================================================================================================
0212
0213 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0214 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0215 from_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0216 ------------------------------------------------------------------------------------------------------------------------
0217 from_utc_timestamp wholestage off 1325 1329 6 7.5 132.5 1.0X
0218 from_utc_timestamp wholestage on 1269 1273 4 7.9 126.9 1.0X
0219
0220 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0221 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0222 to_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0223 ------------------------------------------------------------------------------------------------------------------------
0224 to_utc_timestamp wholestage off 1684 1691 10 5.9 168.4 1.0X
0225 to_utc_timestamp wholestage on 1641 1648 9 6.1 164.1 1.0X
0226
0227
0228 ================================================================================================
0229 Intervals
0230 ================================================================================================
0231
0232 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0233 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0234 cast interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0235 ------------------------------------------------------------------------------------------------------------------------
0236 cast interval wholestage off 343 346 4 29.1 34.3 1.0X
0237 cast interval wholestage on 281 282 1 35.6 28.1 1.2X
0238
0239 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0240 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0241 datediff: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0242 ------------------------------------------------------------------------------------------------------------------------
0243 datediff wholestage off 1831 1840 13 5.5 183.1 1.0X
0244 datediff wholestage on 1759 1769 15 5.7 175.9 1.0X
0245
0246 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0247 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0248 months_between: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0249 ------------------------------------------------------------------------------------------------------------------------
0250 months_between wholestage off 5729 5747 25 1.7 572.9 1.0X
0251 months_between wholestage on 5710 5720 9 1.8 571.0 1.0X
0252
0253 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0254 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0255 window: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0256 ------------------------------------------------------------------------------------------------------------------------
0257 window wholestage off 2183 2189 9 0.5 2182.6 1.0X
0258 window wholestage on 46835 46944 88 0.0 46834.8 0.0X
0259
0260
0261 ================================================================================================
0262 Truncation
0263 ================================================================================================
0264
0265 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0266 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0267 date_trunc YEAR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0268 ------------------------------------------------------------------------------------------------------------------------
0269 date_trunc YEAR wholestage off 2668 2672 5 3.7 266.8 1.0X
0270 date_trunc YEAR wholestage on 2719 2731 9 3.7 271.9 1.0X
0271
0272 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0273 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0274 date_trunc YYYY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0275 ------------------------------------------------------------------------------------------------------------------------
0276 date_trunc YYYY wholestage off 2672 2677 8 3.7 267.2 1.0X
0277 date_trunc YYYY wholestage on 2710 2726 12 3.7 271.0 1.0X
0278
0279 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0280 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0281 date_trunc YY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0282 ------------------------------------------------------------------------------------------------------------------------
0283 date_trunc YY wholestage off 2670 2673 4 3.7 267.0 1.0X
0284 date_trunc YY wholestage on 2711 2720 7 3.7 271.1 1.0X
0285
0286 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0287 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0288 date_trunc MON: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0289 ------------------------------------------------------------------------------------------------------------------------
0290 date_trunc MON wholestage off 2674 2674 0 3.7 267.4 1.0X
0291 date_trunc MON wholestage on 2667 2677 10 3.7 266.7 1.0X
0292
0293 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0294 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0295 date_trunc MONTH: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0296 ------------------------------------------------------------------------------------------------------------------------
0297 date_trunc MONTH wholestage off 2675 2686 16 3.7 267.5 1.0X
0298 date_trunc MONTH wholestage on 2667 2674 6 3.7 266.7 1.0X
0299
0300 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0301 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0302 date_trunc MM: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0303 ------------------------------------------------------------------------------------------------------------------------
0304 date_trunc MM wholestage off 2673 2674 1 3.7 267.3 1.0X
0305 date_trunc MM wholestage on 2664 2669 4 3.8 266.4 1.0X
0306
0307 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0308 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0309 date_trunc DAY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0310 ------------------------------------------------------------------------------------------------------------------------
0311 date_trunc DAY wholestage off 2281 2288 10 4.4 228.1 1.0X
0312 date_trunc DAY wholestage on 2302 2312 8 4.3 230.2 1.0X
0313
0314 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0315 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0316 date_trunc DD: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0317 ------------------------------------------------------------------------------------------------------------------------
0318 date_trunc DD wholestage off 2281 2283 3 4.4 228.1 1.0X
0319 date_trunc DD wholestage on 2291 2302 11 4.4 229.1 1.0X
0320
0321 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0322 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0323 date_trunc HOUR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0324 ------------------------------------------------------------------------------------------------------------------------
0325 date_trunc HOUR wholestage off 2331 2332 1 4.3 233.1 1.0X
0326 date_trunc HOUR wholestage on 2290 2304 11 4.4 229.0 1.0X
0327
0328 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0329 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0330 date_trunc MINUTE: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0331 ------------------------------------------------------------------------------------------------------------------------
0332 date_trunc MINUTE wholestage off 379 385 9 26.4 37.9 1.0X
0333 date_trunc MINUTE wholestage on 371 376 5 27.0 37.1 1.0X
0334
0335 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0336 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0337 date_trunc SECOND: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0338 ------------------------------------------------------------------------------------------------------------------------
0339 date_trunc SECOND wholestage off 375 376 1 26.7 37.5 1.0X
0340 date_trunc SECOND wholestage on 370 376 8 27.0 37.0 1.0X
0341
0342 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0343 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0344 date_trunc WEEK: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0345 ------------------------------------------------------------------------------------------------------------------------
0346 date_trunc WEEK wholestage off 2597 2604 10 3.9 259.7 1.0X
0347 date_trunc WEEK wholestage on 2591 2605 13 3.9 259.1 1.0X
0348
0349 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0350 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0351 date_trunc QUARTER: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0352 ------------------------------------------------------------------------------------------------------------------------
0353 date_trunc QUARTER wholestage off 3501 3511 14 2.9 350.1 1.0X
0354 date_trunc QUARTER wholestage on 3477 3489 9 2.9 347.7 1.0X
0355
0356 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0357 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0358 trunc year: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0359 ------------------------------------------------------------------------------------------------------------------------
0360 trunc year wholestage off 332 334 3 30.1 33.2 1.0X
0361 trunc year wholestage on 332 346 17 30.1 33.2 1.0X
0362
0363 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0364 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0365 trunc yyyy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0366 ------------------------------------------------------------------------------------------------------------------------
0367 trunc yyyy wholestage off 331 331 0 30.2 33.1 1.0X
0368 trunc yyyy wholestage on 336 339 4 29.8 33.6 1.0X
0369
0370 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0371 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0372 trunc yy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0373 ------------------------------------------------------------------------------------------------------------------------
0374 trunc yy wholestage off 330 342 17 30.3 33.0 1.0X
0375 trunc yy wholestage on 333 337 3 30.0 33.3 1.0X
0376
0377 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0378 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0379 trunc mon: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0380 ------------------------------------------------------------------------------------------------------------------------
0381 trunc mon wholestage off 334 335 1 30.0 33.4 1.0X
0382 trunc mon wholestage on 333 347 9 30.0 33.3 1.0X
0383
0384 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0385 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0386 trunc month: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0387 ------------------------------------------------------------------------------------------------------------------------
0388 trunc month wholestage off 332 333 1 30.1 33.2 1.0X
0389 trunc month wholestage on 333 340 7 30.0 33.3 1.0X
0390
0391 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0392 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0393 trunc mm: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0394 ------------------------------------------------------------------------------------------------------------------------
0395 trunc mm wholestage off 328 336 11 30.5 32.8 1.0X
0396 trunc mm wholestage on 333 343 11 30.0 33.3 1.0X
0397
0398
0399 ================================================================================================
0400 Parsing
0401 ================================================================================================
0402
0403 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0404 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0405 to timestamp str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0406 ------------------------------------------------------------------------------------------------------------------------
0407 to timestamp str wholestage off 170 171 1 5.9 170.1 1.0X
0408 to timestamp str wholestage on 172 174 2 5.8 171.6 1.0X
0409
0410 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0411 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0412 to_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0413 ------------------------------------------------------------------------------------------------------------------------
0414 to_timestamp wholestage off 1437 1439 3 0.7 1437.0 1.0X
0415 to_timestamp wholestage on 1288 1292 5 0.8 1288.1 1.1X
0416
0417 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0418 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0419 to_unix_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0420 ------------------------------------------------------------------------------------------------------------------------
0421 to_unix_timestamp wholestage off 1352 1353 2 0.7 1352.0 1.0X
0422 to_unix_timestamp wholestage on 1314 1319 5 0.8 1314.4 1.0X
0423
0424 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0425 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0426 to date str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0427 ------------------------------------------------------------------------------------------------------------------------
0428 to date str wholestage off 211 215 6 4.7 210.7 1.0X
0429 to date str wholestage on 217 217 1 4.6 216.5 1.0X
0430
0431 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0432 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0433 to_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0434 ------------------------------------------------------------------------------------------------------------------------
0435 to_date wholestage off 3281 3295 20 0.3 3280.9 1.0X
0436 to_date wholestage on 3223 3239 17 0.3 3222.8 1.0X
0437
0438
0439 ================================================================================================
0440 Conversion from/to external types
0441 ================================================================================================
0442
0443 OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws
0444 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0445 To/from Java's date-time: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0446 ------------------------------------------------------------------------------------------------------------------------
0447 From java.sql.Date 446 447 1 11.2 89.1 1.0X
0448 From java.time.LocalDate 354 356 1 14.1 70.8 1.3X
0449 Collect java.sql.Date 2722 3091 495 1.8 544.4 0.2X
0450 Collect java.time.LocalDate 1786 1836 60 2.8 357.2 0.2X
0451 From java.sql.Timestamp 275 287 19 18.2 55.0 1.6X
0452 From java.time.Instant 325 328 3 15.4 65.0 1.4X
0453 Collect longs 1300 1321 25 3.8 260.0 0.3X
0454 Collect java.sql.Timestamp 1450 1557 102 3.4 290.0 0.3X
0455 Collect java.time.Instant 1499 1599 87 3.3 299.9 0.3X
0456
0457