0001 ================================================================================================
0002 datetime +/- interval
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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) 1555 1634 113 6.4 155.5 1.0X
0010 date + interval(m, d) 1774 1797 33 5.6 177.4 0.9X
0011 date + interval(m, d, ms) 6293 6335 59 1.6 629.3 0.2X
0012 date - interval(m) 1461 1468 10 6.8 146.1 1.1X
0013 date - interval(m, d) 1741 1741 0 5.7 174.1 0.9X
0014 date - interval(m, d, ms) 6503 6518 21 1.5 650.3 0.2X
0015 timestamp + interval(m) 2384 2385 1 4.2 238.4 0.7X
0016 timestamp + interval(m, d) 2683 2684 2 3.7 268.3 0.6X
0017 timestamp + interval(m, d, ms) 2987 3001 19 3.3 298.7 0.5X
0018 timestamp - interval(m) 2391 2395 5 4.2 239.1 0.7X
0019 timestamp - interval(m, d) 2674 2684 14 3.7 267.4 0.6X
0020 timestamp - interval(m, d, ms) 3005 3007 3 3.3 300.5 0.5X
0021
0022
0023 ================================================================================================
0024 Extract components
0025 ================================================================================================
0026
0027 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 313 320 10 31.9 31.3 1.0X
0032 cast to timestamp wholestage on 325 341 18 30.8 32.5 1.0X
0033
0034 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1216 1216 1 8.2 121.6 1.0X
0039 year of timestamp wholestage on 1226 1243 13 8.2 122.6 1.0X
0040
0041 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1417 1421 5 7.1 141.7 1.0X
0046 quarter of timestamp wholestage on 1358 1365 8 7.4 135.8 1.0X
0047
0048 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1219 1220 1 8.2 121.9 1.0X
0053 month of timestamp wholestage on 1222 1227 7 8.2 122.2 1.0X
0054
0055 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1950 1950 0 5.1 195.0 1.0X
0060 weekofyear of timestamp wholestage on 1890 1899 8 5.3 189.0 1.0X
0061
0062 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1212 1213 2 8.3 121.2 1.0X
0067 day of timestamp wholestage on 1216 1227 13 8.2 121.6 1.0X
0068
0069 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1282 1284 3 7.8 128.2 1.0X
0074 dayofyear of timestamp wholestage on 1269 1274 5 7.9 126.9 1.0X
0075
0076 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1214 1219 7 8.2 121.4 1.0X
0081 dayofmonth of timestamp wholestage on 1216 1224 6 8.2 121.6 1.0X
0082
0083 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1403 1430 39 7.1 140.3 1.0X
0088 dayofweek of timestamp wholestage on 1378 1386 8 7.3 137.8 1.0X
0089
0090 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1344 1353 13 7.4 134.4 1.0X
0095 weekday of timestamp wholestage on 1316 1322 5 7.6 131.6 1.0X
0096
0097 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 992 1000 10 10.1 99.2 1.0X
0102 hour of timestamp wholestage on 960 962 3 10.4 96.0 1.0X
0103
0104 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 989 1000 16 10.1 98.9 1.0X
0109 minute of timestamp wholestage on 965 974 13 10.4 96.5 1.0X
0110
0111 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 974 977 5 10.3 97.4 1.0X
0116 second of timestamp wholestage on 959 966 8 10.4 95.9 1.0X
0117
0118
0119 ================================================================================================
0120 Current date and time
0121 ================================================================================================
0122
0123 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 281 282 2 35.6 28.1 1.0X
0128 current_date wholestage on 294 300 5 34.0 29.4 1.0X
0129
0130 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 282 296 19 35.4 28.2 1.0X
0135 current_timestamp wholestage on 304 331 31 32.9 30.4 0.9X
0136
0137
0138 ================================================================================================
0139 Date arithmetic
0140 ================================================================================================
0141
0142 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1060 1061 1 9.4 106.0 1.0X
0147 cast to date wholestage on 1021 1026 10 9.8 102.1 1.0X
0148
0149 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1278 1280 3 7.8 127.8 1.0X
0154 last_day wholestage on 1560 1566 6 6.4 156.0 0.8X
0155
0156 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1091 1093 3 9.2 109.1 1.0X
0161 next_day wholestage on 1070 1076 9 9.3 107.0 1.0X
0162
0163 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1041 1047 8 9.6 104.1 1.0X
0168 date_add wholestage on 1044 1050 4 9.6 104.4 1.0X
0169
0170 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1038 1040 3 9.6 103.8 1.0X
0175 date_sub wholestage on 1057 1061 4 9.5 105.7 1.0X
0176
0177 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1401 1401 1 7.1 140.1 1.0X
0182 add_months wholestage on 1438 1442 4 7.0 143.8 1.0X
0183
0184
0185 ================================================================================================
0186 Formatting dates
0187 ================================================================================================
0188
0189 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 5482 5803 454 1.8 548.2 1.0X
0194 format date wholestage on 5502 5518 9 1.8 550.2 1.0X
0195
0196
0197 ================================================================================================
0198 Formatting timestamps
0199 ================================================================================================
0200
0201 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 8538 8553 22 1.2 853.8 1.0X
0206 from_unixtime wholestage on 8545 8552 6 1.2 854.5 1.0X
0207
0208
0209 ================================================================================================
0210 Convert timestamps
0211 ================================================================================================
0212
0213 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1094 1099 8 9.1 109.4 1.0X
0218 from_utc_timestamp wholestage on 1109 1114 5 9.0 110.9 1.0X
0219
0220 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1466 1469 4 6.8 146.6 1.0X
0225 to_utc_timestamp wholestage on 1401 1408 7 7.1 140.1 1.0X
0226
0227
0228 ================================================================================================
0229 Intervals
0230 ================================================================================================
0231
0232 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 332 332 0 30.1 33.2 1.0X
0237 cast interval wholestage on 315 324 10 31.7 31.5 1.1X
0238
0239 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1796 1802 8 5.6 179.6 1.0X
0244 datediff wholestage on 1758 1764 10 5.7 175.8 1.0X
0245
0246 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 4833 4836 4 2.1 483.3 1.0X
0251 months_between wholestage on 4777 4780 2 2.1 477.7 1.0X
0252
0253 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1812 1908 136 0.6 1811.7 1.0X
0258 window wholestage on 46279 46376 74 0.0 46278.8 0.0X
0259
0260
0261 ================================================================================================
0262 Truncation
0263 ================================================================================================
0264
0265 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2367 2368 1 4.2 236.7 1.0X
0270 date_trunc YEAR wholestage on 2321 2334 22 4.3 232.1 1.0X
0271
0272 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2330 2334 5 4.3 233.0 1.0X
0277 date_trunc YYYY wholestage on 2326 2332 5 4.3 232.6 1.0X
0278
0279 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2334 2335 1 4.3 233.4 1.0X
0284 date_trunc YY wholestage on 2315 2324 6 4.3 231.5 1.0X
0285
0286 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2327 2330 4 4.3 232.7 1.0X
0291 date_trunc MON wholestage on 2279 2289 12 4.4 227.9 1.0X
0292
0293 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2330 2332 2 4.3 233.0 1.0X
0298 date_trunc MONTH wholestage on 2277 2284 6 4.4 227.7 1.0X
0299
0300 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2328 2329 2 4.3 232.8 1.0X
0305 date_trunc MM wholestage on 2279 2284 4 4.4 227.9 1.0X
0306
0307 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1974 1984 14 5.1 197.4 1.0X
0312 date_trunc DAY wholestage on 1914 1922 7 5.2 191.4 1.0X
0313
0314 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1967 1976 12 5.1 196.7 1.0X
0319 date_trunc DD wholestage on 1913 1917 4 5.2 191.3 1.0X
0320
0321 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1970 1970 0 5.1 197.0 1.0X
0326 date_trunc HOUR wholestage on 1945 1946 2 5.1 194.5 1.0X
0327
0328 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 361 361 1 27.7 36.1 1.0X
0333 date_trunc MINUTE wholestage on 331 336 4 30.2 33.1 1.1X
0334
0335 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 360 361 1 27.8 36.0 1.0X
0340 date_trunc SECOND wholestage on 335 348 15 29.8 33.5 1.1X
0341
0342 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 2232 2236 6 4.5 223.2 1.0X
0347 date_trunc WEEK wholestage on 2225 2232 6 4.5 222.5 1.0X
0348
0349 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 3083 3086 4 3.2 308.3 1.0X
0354 date_trunc QUARTER wholestage on 3073 3086 16 3.3 307.3 1.0X
0355
0356 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 321 321 0 31.1 32.1 1.0X
0361 trunc year wholestage on 299 303 5 33.5 29.9 1.1X
0362
0363 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 323 327 5 30.9 32.3 1.0X
0368 trunc yyyy wholestage on 299 302 3 33.4 29.9 1.1X
0369
0370 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 315 315 1 31.8 31.5 1.0X
0375 trunc yy wholestage on 299 304 4 33.4 29.9 1.1X
0376
0377 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 320 321 1 31.2 32.0 1.0X
0382 trunc mon wholestage on 299 307 10 33.4 29.9 1.1X
0383
0384 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 316 317 1 31.6 31.6 1.0X
0389 trunc month wholestage on 299 302 5 33.5 29.9 1.1X
0390
0391 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 313 313 1 32.0 31.3 1.0X
0396 trunc mm wholestage on 298 302 4 33.5 29.8 1.0X
0397
0398
0399 ================================================================================================
0400 Parsing
0401 ================================================================================================
0402
0403 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 217 217 0 4.6 217.3 1.0X
0408 to timestamp str wholestage on 209 212 2 4.8 209.5 1.0X
0409
0410 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1676 1677 2 0.6 1675.6 1.0X
0415 to_timestamp wholestage on 1599 1606 8 0.6 1599.5 1.0X
0416
0417 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 1582 1589 9 0.6 1582.1 1.0X
0422 to_unix_timestamp wholestage on 1634 1637 3 0.6 1633.8 1.0X
0423
0424 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 275 282 9 3.6 275.0 1.0X
0429 to date str wholestage on 264 265 2 3.8 263.5 1.0X
0430
0431 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 3170 3188 25 0.3 3170.1 1.0X
0436 to_date wholestage on 3134 3143 10 0.3 3134.3 1.0X
0437
0438
0439 ================================================================================================
0440 Conversion from/to external types
0441 ================================================================================================
0442
0443 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 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 407 413 7 12.3 81.5 1.0X
0448 From java.time.LocalDate 340 344 5 14.7 68.1 1.2X
0449 Collect java.sql.Date 1700 2658 1422 2.9 340.0 0.2X
0450 Collect java.time.LocalDate 1473 1494 30 3.4 294.6 0.3X
0451 From java.sql.Timestamp 252 266 13 19.8 50.5 1.6X
0452 From java.time.Instant 236 243 7 21.1 47.3 1.7X
0453 Collect longs 1280 1337 79 3.9 256.1 0.3X
0454 Collect java.sql.Timestamp 1485 1501 15 3.4 297.0 0.3X
0455 Collect java.time.Instant 1441 1465 37 3.5 288.1 0.3X
0456
0457