Temp Timings in Postgres 15’s EXPLAIN (BUFFERS)

Ryan Lambert looks at a code change:

This improvement adds new detail to the output provided from Postgres 15 when running EXPLAIN (ANALYZE, BUFFERS) <query>. This post explores this feature along with a couple different ways the reported I/O timing interacts with performance tuning.

Read on to see how you can enable this feature and what it can do for you.