EXPLAIN (ANALYZE, BUFFERS) and interpreting shared buffers hit in Nested Loops

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-explain-analyze-buffers-nested-loops

In E83 of “5mins of Postgres” we're talking about using EXPLAIN (ANALYZE, BUFFERS) to optimize Postgres queries, and what to watch out for when looking for the shared hits counter in EXPLAIN (ANALYZE, BUFFERS).

*Learn more about pganalyze:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*

https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Buffer analysis when using EXPLAIN ANALYSE in Postgres*

https://willj.net/posts/buffer-analysis-when-using-explain-analyse-in-postgres/

*EXPLAIN (ANALYZE, BUFFERS) in Postgres*

https://www.postgresql.org/docs/current/sql-explain.html

*Will Jessop on Mastodon*

https://ruby.social/@wj