0001 Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4
0002 Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz
0003 Invoke extract for timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0004 ------------------------------------------------------------------------------------------------------------------------
0005 cast to timestamp 333 345 13 30.0 33.3 1.0X
0006 YEAR of timestamp 826 840 16 12.1 82.6 0.4X
0007 YEAROFWEEK of timestamp 1161 1168 7 8.6 116.1 0.3X
0008 QUARTER of timestamp 961 966 6 10.4 96.1 0.3X
0009 MONTH of timestamp 831 838 6 12.0 83.1 0.4X
0010 WEEK of timestamp 1155 1159 4 8.7 115.5 0.3X
0011 DAY of timestamp 822 828 6 12.2 82.2 0.4X
0012 DAYOFWEEK of timestamp 968 972 6 10.3 96.8 0.3X
0013 DOW of timestamp 960 966 9 10.4 96.0 0.3X
0014 DOW_ISO of timestamp 961 967 9 10.4 96.1 0.3X
0015 DAYOFWEEK_ISO of timestamp 965 968 5 10.4 96.5 0.3X
0016 DOY of timestamp 864 873 9 11.6 86.4 0.4X
0017 HOUR of timestamp 631 647 14 15.9 63.1 0.5X
0018 MINUTE of timestamp 638 651 12 15.7 63.8 0.5X
0019 SECOND of timestamp 758 760 2 13.2 75.8 0.4X
0020
0021 Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4
0022 Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz
0023 Invoke date_part for timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0024 ------------------------------------------------------------------------------------------------------------------------
0025 cast to timestamp 301 307 8 33.2 30.1 1.0X
0026 YEAR of timestamp 797 805 7 12.6 79.7 0.4X
0027 YEAROFWEEK of timestamp 1147 1156 8 8.7 114.7 0.3X
0028 QUARTER of timestamp 965 974 9 10.4 96.5 0.3X
0029 MONTH of timestamp 801 815 17 12.5 80.1 0.4X
0030 WEEK of timestamp 1133 1157 21 8.8 113.3 0.3X
0031 DAY of timestamp 825 828 4 12.1 82.5 0.4X
0032 DAYOFWEEK of timestamp 929 937 8 10.8 92.9 0.3X
0033 DOW of timestamp 933 940 11 10.7 93.3 0.3X
0034 DOW_ISO of timestamp 944 954 11 10.6 94.4 0.3X
0035 DAYOFWEEK_ISO of timestamp 948 965 21 10.5 94.8 0.3X
0036 DOY of timestamp 894 898 6 11.2 89.4 0.3X
0037 HOUR of timestamp 678 683 6 14.7 67.8 0.4X
0038 MINUTE of timestamp 669 670 2 15.0 66.9 0.5X
0039 SECOND of timestamp 762 771 12 13.1 76.2 0.4X
0040
0041 Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4
0042 Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz
0043 Invoke extract for date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0044 ------------------------------------------------------------------------------------------------------------------------
0045 cast to date 737 751 23 13.6 73.7 1.0X
0046 YEAR of date 804 811 11 12.4 80.4 0.9X
0047 YEAROFWEEK of date 1151 1155 4 8.7 115.1 0.6X
0048 QUARTER of date 964 987 26 10.4 96.4 0.8X
0049 MONTH of date 831 835 6 12.0 83.1 0.9X
0050 WEEK of date 1162 1163 2 8.6 116.2 0.6X
0051 DAY of date 826 833 7 12.1 82.6 0.9X
0052 DAYOFWEEK of date 984 1003 26 10.2 98.4 0.7X
0053 DOW of date 995 997 2 10.0 99.5 0.7X
0054 DOW_ISO of date 985 992 8 10.2 98.5 0.7X
0055 DAYOFWEEK_ISO of date 985 1001 19 10.1 98.5 0.7X
0056 DOY of date 884 890 8 11.3 88.4 0.8X
0057 HOUR of date 1630 1640 13 6.1 163.0 0.5X
0058 MINUTE of date 1631 1636 6 6.1 163.1 0.5X
0059 SECOND of date 1737 1739 2 5.8 173.7 0.4X
0060
0061 Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4
0062 Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz
0063 Invoke date_part for date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0064 ------------------------------------------------------------------------------------------------------------------------
0065 cast to date 746 753 8 13.4 74.6 1.0X
0066 YEAR of date 841 843 1 11.9 84.1 0.9X
0067 YEAROFWEEK of date 1169 1191 20 8.6 116.9 0.6X
0068 QUARTER of date 1008 1012 4 9.9 100.8 0.7X
0069 MONTH of date 838 844 6 11.9 83.8 0.9X
0070 WEEK of date 1179 1182 3 8.5 117.9 0.6X
0071 DAY of date 849 850 1 11.8 84.9 0.9X
0072 DAYOFWEEK of date 984 988 4 10.2 98.4 0.8X
0073 DOW of date 986 994 7 10.1 98.6 0.8X
0074 DOW_ISO of date 974 992 17 10.3 97.4 0.8X
0075 DAYOFWEEK_ISO of date 979 994 14 10.2 97.9 0.8X
0076 DOY of date 874 878 3 11.4 87.4 0.9X
0077 HOUR of date 1644 1649 6 6.1 164.4 0.5X
0078 MINUTE of date 1610 1626 15 6.2 161.0 0.5X
0079 SECOND of date 1768 1789 30 5.7 176.8 0.4X
0080
0081 Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4
0082 Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz
0083 Invoke extract for interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0084 ------------------------------------------------------------------------------------------------------------------------
0085 cast to interval 989 1003 13 10.1 98.9 1.0X
0086 YEAR of interval 980 999 16 10.2 98.0 1.0X
0087 MONTH of interval 988 1000 15 10.1 98.8 1.0X
0088 DAY of interval 970 983 11 10.3 97.0 1.0X
0089 HOUR of interval 989 1000 13 10.1 98.9 1.0X
0090 MINUTE of interval 1019 1034 13 9.8 101.9 1.0X
0091 SECOND of interval 1084 1095 10 9.2 108.4 0.9X
0092
0093 Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4
0094 Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz
0095 Invoke date_part for interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0096 ------------------------------------------------------------------------------------------------------------------------
0097 cast to interval 955 969 15 10.5 95.5 1.0X
0098 YEAR of interval 1004 1007 3 10.0 100.4 1.0X
0099 MONTH of interval 989 990 2 10.1 98.9 1.0X
0100 DAY of interval 1006 1011 6 9.9 100.6 0.9X
0101 HOUR of interval 986 997 10 10.1 98.6 1.0X
0102 MINUTE of interval 1004 1014 15 10.0 100.4 1.0X
0103 SECOND of interval 1083 1088 6 9.2 108.3 0.9X
0104