© Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/978-1-4842-6885-8_4

4. Understanding Execution Plans

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
Braviant Holdings, Chicago, IL, USA
(2)
HSE University, Saint Petersburg, Russia
(3)
Zendesk, Madison, WI, USA
 

At long last, it’s time to look at execution plans. Before we begin, let’s review our theoretical foundations. Chapter 3 explained how logical operations are mapped to their physical execution, covering data retrieval and more complex operations.

In this chapter, understanding these algorithms will allow us to interpret execution plans and get a better grasp of their components.

Putting Everything ...

Get PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.