Some minor comments on the JIT explain output. For example: Seq Scan on tenk1 (cost=0.00..483.00 rows=3333 width=244) (actual time=5.564..8.755 rows=4960 loops=1) Filter: (unique1 > unique2) Rows Removed by Filter: 5040 Planning Time: 0.857 ms JIT: Functions: 2 Generation Time: 0.439 ms Inlining: false Inlining Time: 0.000 ms Optimization: false Optimization Time: 0.375 ms Emission Time: 5.020 ms Execution Time: 25.230 ms
Why is the optimization time nonzero when optimization is claimed to be off? Could we perhaps save some vertical space by showing alternatively: Optimization Time: 0.375 ms and Optimization Time: off and omit the Optimization: line? Similarly for Inlining. What is the Generation Time and Emissions Time? Could we document this? Is there a benefit to the user to see them listed separately? It might be useful to see a JIT total time somewhere, which would be the sum of all the phases. Then it's easier to compare that against the total run time. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
