================================================================================================
parsing large select expressions
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
parsing large select:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 select expressions                                  1              1           0          0.0      778290.0       1.0X
100 select expressions                                3              3           1          0.0     2968067.0       0.3X
2500 select expressions                              63             65           4          0.0    62918675.0       0.0X


================================================================================================
optimize large select expressions
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
optimize large select:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
100 columns                                           3              5           1          0.0     3449795.0       1.0X
1000 columns                                         20             22           1          0.0    20071330.0       0.2X
10000 columns                                       193            207          12          0.0   192787888.0       0.0X


================================================================================================
many column field read and write
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
many column field r/w:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 cols x 100000 rows (read in-mem)                   19             26           5          5.2         192.5       1.0X
1 cols x 100000 rows (exec in-mem)                   19             23           4          5.4         186.9       1.0X
1 cols x 100000 rows (read parquet)                  35             42           7          2.9         347.0       0.6X
1 cols x 100000 rows (write parquet)                116            125           8          0.9        1162.6       0.2X
100 cols x 1000 rows (read in-mem)                   16             19           4          6.3         158.4       1.2X
100 cols x 1000 rows (exec in-mem)                   19             23           4          5.3         188.4       1.0X
100 cols x 1000 rows (read parquet)                  30             36           8          3.3         302.7       0.6X
100 cols x 1000 rows (write parquet)                111            117           7          0.9        1107.0       0.2X
2500 cols x 40 rows (read in-mem)                    54             58           7          1.8         544.2       0.4X
2500 cols x 40 rows (exec in-mem)                    84             90           7          1.2         839.5       0.2X
2500 cols x 40 rows (read parquet)                  311            318           6          0.3        3108.3       0.1X
2500 cols x 40 rows (write parquet)                 148            155           8          0.7        1482.8       0.1X


================================================================================================
wide shallowly nested struct field read and write
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
wide shallowly nested struct field r/w:   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 wide x 100000 rows (read in-mem)                   25             33           6          4.0         252.3       1.0X
1 wide x 100000 rows (exec in-mem)                   27             32           6          3.7         268.2       0.9X
1 wide x 100000 rows (read parquet)                  27             33           8          3.7         272.7       0.9X
1 wide x 100000 rows (write parquet)                121            127           5          0.8        1205.8       0.2X
100 wide x 1000 rows (read in-mem)                   20             25           7          5.0         201.3       1.3X
100 wide x 1000 rows (exec in-mem)                   21             24           5          4.8         208.7       1.2X
100 wide x 1000 rows (read parquet)                  27             33           7          3.6         274.7       0.9X
100 wide x 1000 rows (write parquet)                113            122           8          0.9        1128.9       0.2X
2500 wide x 40 rows (read in-mem)                    27             30           5          3.7         273.0       0.9X
2500 wide x 40 rows (exec in-mem)                    31             35           6          3.3         305.4       0.8X
2500 wide x 40 rows (read parquet)                   73             76           3          1.4         732.0       0.3X
2500 wide x 40 rows (write parquet)                 119            128          10          0.8        1189.6       0.2X


================================================================================================
deeply nested struct field read and write
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
deeply nested struct field r/w:           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 deep x 100000 rows (read in-mem)                   20             24           6          5.0         199.7       1.0X
1 deep x 100000 rows (exec in-mem)                   22             26           6          4.5         220.0       0.9X
1 deep x 100000 rows (read parquet)                  22             26           5          4.4         224.9       0.9X
1 deep x 100000 rows (write parquet)                109            116          10          0.9        1086.7       0.2X
100 deep x 1000 rows (read in-mem)                   47             49           4          2.1         468.3       0.4X
100 deep x 1000 rows (exec in-mem)                  464            470           6          0.2        4641.1       0.0X
100 deep x 1000 rows (read parquet)                 472            474           2          0.2        4720.6       0.0X
100 deep x 1000 rows (write parquet)                140            145           5          0.7        1397.9       0.1X
250 deep x 400 rows (read in-mem)                   197            202           4          0.5        1973.0       0.1X
250 deep x 400 rows (exec in-mem)                  2813           2813           0          0.0       28131.6       0.0X
250 deep x 400 rows (read parquet)                 2799           2806          10          0.0       27989.6       0.0X
250 deep x 400 rows (write parquet)                 287            293           4          0.3        2871.7       0.1X


================================================================================================
bushy struct field read and write
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
bushy struct field r/w:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------
1 x 1 deep x 100000 rows (read in-mem)                17             19           4          6.0         165.5       1.0X
1 x 1 deep x 100000 rows (exec in-mem)                18             23           6          5.5         180.9       0.9X
1 x 1 deep x 100000 rows (read parquet)               21             24           4          4.9         205.7       0.8X
1 x 1 deep x 100000 rows (write parquet)             110            115           9          0.9        1097.5       0.2X
128 x 8 deep x 1000 rows (read in-mem)                16             20           4          6.1         164.3       1.0X
128 x 8 deep x 1000 rows (exec in-mem)                19             23           5          5.3         187.5       0.9X
128 x 8 deep x 1000 rows (read parquet)               24             28           5          4.2         237.8       0.7X
128 x 8 deep x 1000 rows (write parquet)             105            112           9          1.0        1046.9       0.2X
1024 x 11 deep x 100 rows (read in-mem)               22             25           5          4.6         217.7       0.8X
1024 x 11 deep x 100 rows (exec in-mem)               26             29           5          3.9         258.6       0.6X
1024 x 11 deep x 100 rows (read parquet)              40             45           8          2.5         395.8       0.4X
1024 x 11 deep x 100 rows (write parquet)            111            116           7          0.9        1114.1       0.1X


================================================================================================
wide array field read and write
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
wide array field r/w:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 wide x 100000 rows (read in-mem)                   18             21           5          5.6         179.0       1.0X
1 wide x 100000 rows (exec in-mem)                   20             24           6          5.1         197.3       0.9X
1 wide x 100000 rows (read parquet)                  20             22           5          5.0         200.2       0.9X
1 wide x 100000 rows (write parquet)                107            112           7          0.9        1074.1       0.2X
100 wide x 1000 rows (read in-mem)                   13             16           5          7.4         134.9       1.3X
100 wide x 1000 rows (exec in-mem)                   15             18           4          6.6         152.1       1.2X
100 wide x 1000 rows (read parquet)                  20             22           5          5.1         196.1       0.9X
100 wide x 1000 rows (write parquet)                103            110           9          1.0        1029.5       0.2X
2500 wide x 40 rows (read in-mem)                    14             15           4          7.4         135.5       1.3X
2500 wide x 40 rows (exec in-mem)                    15             17           4          6.5         152.8       1.2X
2500 wide x 40 rows (read parquet)                   19             22           4          5.2         193.2       0.9X
2500 wide x 40 rows (write parquet)                 103            110           7          1.0        1034.1       0.2X


================================================================================================
wide map field read and write
================================================================================================

OpenJDK 64-Bit Server VM 21.0.10+7-LTS on Linux 6.14.0-1017-azure
AMD EPYC 7763 64-Core Processor
wide map field r/w:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 wide x 100000 rows (read in-mem)                   14             16           3          7.0         143.6       1.0X
1 wide x 100000 rows (exec in-mem)                   18             20           3          5.6         179.6       0.8X
1 wide x 100000 rows (read parquet)                  24             29           6          4.1         243.8       0.6X
1 wide x 100000 rows (write parquet)                104            110           6          1.0        1038.2       0.1X
100 wide x 1000 rows (read in-mem)                    8             10           2         11.9          84.3       1.7X
100 wide x 1000 rows (exec in-mem)                   11             14           4          9.3         107.7       1.3X
100 wide x 1000 rows (read parquet)                  20             25           6          4.9         204.4       0.7X
100 wide x 1000 rows (write parquet)                 97            103           7          1.0         974.0       0.1X
2500 wide x 40 rows (read in-mem)                    10             12           3          9.7         103.1       1.4X
2500 wide x 40 rows (exec in-mem)                    13             15           3          8.0         125.5       1.1X
2500 wide x 40 rows (read parquet)                   21             25           6          4.8         208.0       0.7X
2500 wide x 40 rows (write parquet)                 100            105           9          1.0         996.5       0.1X


