How to Understand SQL EXPLAIN ANALYZE and BUFFERS

In this video we’ll cover how we can understand the output of the SQL EXPLAIN ANALYZE statement and also look at BUFFERS. The SQL EXPLAIN ANALYZE and BUFFERS statements can give us a lot of insights into how our query actually performed compared to the plan. We can then properly understand how much data we&sifting through and more accurate determine next steps to improving our query performance.