Reading Buffer statistics in EXPLAIN output

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

In the article about Buffers in PostgreSQL we kept adding EXPLAIN (ANALYZE, BUFFERS) to every query without giving much thought to the output. Time to fix that. PostgreSQL breaks down buffer usage for each plan node, and once you learn to read those numbers, you'll know exactly where your query spent time waiting for I/O - and where it didn't have to. That's about as…

Read on boringsql.com ↗