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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-Core Processor
parsing large select:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1 select expressions                                  0              0           0          0.0      293800.0       1.0X
100 select expressions                                3              3           0          0.0     2973933.0       0.1X
2500 select expressions                              69             70           1          0.0    69480028.0       0.0X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-Core Processor
optimize large select:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
100 columns                                           3              3           1          0.0     2929006.0       1.0X
1000 columns                                         19             20           1          0.0    19200982.0       0.2X
10000 columns                                       189            197          13          0.0   188989894.0       0.0X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                   12             16           4          8.7         115.2       1.0X
1 cols x 100000 rows (exec in-mem)                   13             17           4          7.8         127.9       0.9X
1 cols x 100000 rows (read parquet)                  29             39          10          3.5         286.8       0.4X
1 cols x 100000 rows (write parquet)                112            121           7          0.9        1120.0       0.1X
100 cols x 1000 rows (read in-mem)                   11             15           4          8.8         114.2       1.0X
100 cols x 1000 rows (exec in-mem)                   14             17           3          7.0         143.9       0.8X
100 cols x 1000 rows (read parquet)                  25             29           5          3.9         253.5       0.5X
100 cols x 1000 rows (write parquet)                109            116           7          0.9        1089.8       0.1X
2500 cols x 40 rows (read in-mem)                   168            178          13          0.6        1681.4       0.1X
2500 cols x 40 rows (exec in-mem)                   196            206          13          0.5        1957.3       0.1X
2500 cols x 40 rows (read parquet)                  256            263           5          0.4        2560.9       0.0X
2500 cols x 40 rows (write parquet)                 267            281          12          0.4        2667.5       0.0X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                   22             29           7          4.5         223.8       1.0X
1 wide x 100000 rows (exec in-mem)                   24             28           5          4.1         242.2       0.9X
1 wide x 100000 rows (read parquet)                  25             29           7          4.0         252.2       0.9X
1 wide x 100000 rows (write parquet)                120            130          10          0.8        1204.8       0.2X
100 wide x 1000 rows (read in-mem)                   17             20           5          5.9         168.3       1.3X
100 wide x 1000 rows (exec in-mem)                   18             22           7          5.4         183.8       1.2X
100 wide x 1000 rows (read parquet)                  25             28           5          4.0         249.9       0.9X
100 wide x 1000 rows (write parquet)                113            121           9          0.9        1131.0       0.2X
2500 wide x 40 rows (read in-mem)                    23             26           5          4.4         226.6       1.0X
2500 wide x 40 rows (exec in-mem)                    24             28           6          4.2         238.9       0.9X
2500 wide x 40 rows (read parquet)                   72             79           9          1.4         719.6       0.3X
2500 wide x 40 rows (write parquet)                 118            130          11          0.8        1181.8       0.2X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                   18             22           6          5.5         180.8       1.0X
1 deep x 100000 rows (exec in-mem)                   20             23           5          4.9         204.2       0.9X
1 deep x 100000 rows (read parquet)                  21             25           6          4.7         211.0       0.9X
1 deep x 100000 rows (write parquet)                114            121           7          0.9        1136.7       0.2X
100 deep x 1000 rows (read in-mem)                   49             53           6          2.0         488.3       0.4X
100 deep x 1000 rows (exec in-mem)                  534            539           5          0.2        5335.2       0.0X
100 deep x 1000 rows (read parquet)                 543            547           7          0.2        5426.1       0.0X
100 deep x 1000 rows (write parquet)                145            153           9          0.7        1450.9       0.1X
250 deep x 400 rows (read in-mem)                   208            212           3          0.5        2079.7       0.1X
250 deep x 400 rows (exec in-mem)                  3223           3229           9          0.0       32225.5       0.0X
250 deep x 400 rows (read parquet)                 3237           3242           7          0.0       32370.4       0.0X
250 deep x 400 rows (write parquet)                 304            309           3          0.3        3037.0       0.1X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                15             18           4          6.5         154.3       1.0X
1 x 1 deep x 100000 rows (exec in-mem)                17             21           6          5.9         169.6       0.9X
1 x 1 deep x 100000 rows (read parquet)               20             23           6          5.0         199.6       0.8X
1 x 1 deep x 100000 rows (write parquet)             110            118           8          0.9        1095.8       0.1X
128 x 8 deep x 1000 rows (read in-mem)                15             18           5          6.5         153.1       1.0X
128 x 8 deep x 1000 rows (exec in-mem)                16             19           5          6.1         164.8       0.9X
128 x 8 deep x 1000 rows (read parquet)               24             26           6          4.2         237.0       0.7X
128 x 8 deep x 1000 rows (write parquet)             110            116           8          0.9        1100.0       0.1X
1024 x 11 deep x 100 rows (read in-mem)               18             21           5          5.4         184.4       0.8X
1024 x 11 deep x 100 rows (exec in-mem)               20             23           6          5.0         200.6       0.8X
1024 x 11 deep x 100 rows (read parquet)              39             43           6          2.6         389.4       0.4X
1024 x 11 deep x 100 rows (write parquet)            114            120           7          0.9        1136.3       0.1X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                   17             21           6          5.8         173.2       1.0X
1 wide x 100000 rows (exec in-mem)                   20             23           6          5.1         195.3       0.9X
1 wide x 100000 rows (read parquet)                  20             22           5          5.0         201.3       0.9X
1 wide x 100000 rows (write parquet)                113            119           8          0.9        1127.7       0.2X
100 wide x 1000 rows (read in-mem)                   13             14           4          7.7         129.2       1.3X
100 wide x 1000 rows (exec in-mem)                   15             18           6          6.8         146.1       1.2X
100 wide x 1000 rows (read parquet)                  20             23           6          5.0         199.5       0.9X
100 wide x 1000 rows (write parquet)                107            112           7          0.9        1068.6       0.2X
2500 wide x 40 rows (read in-mem)                    13             14           4          7.8         127.7       1.4X
2500 wide x 40 rows (exec in-mem)                    14             17           6          6.9         144.1       1.2X
2500 wide x 40 rows (read parquet)                   19             22           6          5.2         191.1       0.9X
2500 wide x 40 rows (write parquet)                 107            113           8          0.9        1069.8       0.2X


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

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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           4          7.1         140.9       1.0X
1 wide x 100000 rows (exec in-mem)                   18             21           4          5.5         181.7       0.8X
1 wide x 100000 rows (read parquet)                  24             27           6          4.2         238.9       0.6X
1 wide x 100000 rows (write parquet)                108            110           3          0.9        1079.8       0.1X
100 wide x 1000 rows (read in-mem)                    8             10           4         12.1          82.3       1.7X
100 wide x 1000 rows (exec in-mem)                   10             11           3          9.8         102.3       1.4X
100 wide x 1000 rows (read parquet)                  21             25           6          4.8         210.3       0.7X
100 wide x 1000 rows (write parquet)                102            105           5          1.0        1023.6       0.1X
2500 wide x 40 rows (read in-mem)                    10             11           3         10.0         100.4       1.4X
2500 wide x 40 rows (exec in-mem)                    12             13           3          8.3         120.0       1.2X
2500 wide x 40 rows (read parquet)                   21             24           6          4.8         210.1       0.7X
2500 wide x 40 rows (write parquet)                 104            109           5          1.0        1039.5       0.1X


