| ================================================================================================ |
| Recursive CTE with only LocalRelation |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 10 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 10 integers using VALUES 148 167 18 0.0 14839785.2 1.0X |
| First 10 integers using SELECT 98 104 10 0.0 9804143.1 1.5X |
| First 10 integers using SELECT and LIMIT 69 74 6 0.0 6947861.5 2.1X |
| First 10 integers referencing external table in anchor 137 152 14 0.0 13678740.6 1.1X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 20 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 20 integers using VALUES 106 133 36 0.0 5307230.3 1.0X |
| First 20 integers using SELECT 71 76 6 0.0 3547554.4 1.5X |
| First 20 integers using SELECT and LIMIT 65 70 5 0.0 3261191.1 1.6X |
| First 20 integers referencing external table in anchor 124 136 12 0.0 6178005.2 0.9X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 30 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 30 integers using VALUES 76 80 3 0.0 2534581.7 1.0X |
| First 30 integers using SELECT 75 89 13 0.0 2502620.9 1.0X |
| First 30 integers using SELECT and LIMIT 68 75 10 0.0 2268367.1 1.1X |
| First 30 integers referencing external table in anchor 130 145 14 0.0 4335711.0 0.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 40 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 40 integers using VALUES 88 91 3 0.0 2189691.2 1.0X |
| First 40 integers using SELECT 81 92 14 0.0 2016015.3 1.1X |
| First 40 integers using SELECT and LIMIT 76 76 0 0.0 1895381.1 1.2X |
| First 40 integers referencing external table in anchor 138 144 6 0.0 3438437.8 0.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 50 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 50 integers using VALUES 92 93 2 0.0 1841580.9 1.0X |
| First 50 integers using SELECT 88 96 7 0.0 1767409.2 1.0X |
| First 50 integers using SELECT and LIMIT 85 89 7 0.0 1690024.1 1.1X |
| First 50 integers referencing external table in anchor 138 170 49 0.0 2768320.2 0.7X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 60 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 60 integers using VALUES 102 108 6 0.0 1695633.1 1.0X |
| First 60 integers using SELECT 106 109 3 0.0 1764378.9 1.0X |
| First 60 integers using SELECT and LIMIT 86 88 2 0.0 1431717.5 1.2X |
| First 60 integers referencing external table in anchor 143 151 14 0.0 2375875.2 0.7X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 70 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 70 integers using VALUES 120 120 0 0.0 1713649.0 1.0X |
| First 70 integers using SELECT 106 107 1 0.0 1518864.8 1.1X |
| First 70 integers using SELECT and LIMIT 100 108 7 0.0 1434807.4 1.2X |
| First 70 integers referencing external table in anchor 151 163 10 0.0 2161647.3 0.8X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 80 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 80 integers using VALUES 128 130 3 0.0 1598576.8 1.0X |
| First 80 integers using SELECT 121 124 4 0.0 1508073.3 1.1X |
| First 80 integers using SELECT and LIMIT 122 125 3 0.0 1519987.5 1.1X |
| First 80 integers referencing external table in anchor 176 185 11 0.0 2203944.4 0.7X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 90 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| -------------------------------------------------------------------------------------------------------------------------------------- |
| First 90 integers using VALUES 139 143 4 0.0 1542391.2 1.0X |
| First 90 integers using SELECT 133 136 5 0.0 1476130.4 1.0X |
| First 90 integers using SELECT and LIMIT 120 127 8 0.0 1331007.2 1.2X |
| First 90 integers referencing external table in anchor 173 173 1 0.0 1916955.5 0.8X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| First 100 integers: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| --------------------------------------------------------------------------------------------------------------------------------------- |
| First 100 integers using VALUES 152 155 3 0.0 1517038.9 1.0X |
| First 100 integers using SELECT 145 147 3 0.0 1446338.1 1.0X |
| First 100 integers using SELECT and LIMIT 137 140 3 0.0 1371332.3 1.1X |
| First 100 integers referencing external table in anchor 180 181 2 0.0 1799060.3 0.8X |
| |
| |
