PostgreSQL - Execution

Conan Mercer Applied Scientist

PostgreSQL - Execution

30 May 2021 - Conan Mercer

Motivation

This Jupyter Notebook is the second in my series on PostgreSQL, the first blog post can be found here. The goal is to become familiar with the EXPLAIN and ANALYSE statements, with particular focus on execution and planning times of queries. This guide uses a sample database called dvdrental, a common resource used to learn PostgreSQL, it can be downloaded from here.

This Jupyter Notebook also resides on my GitHub - it can be viewed from here

Conclusion

This post introduced the EXPLAIN and ANALYSE statements in PostgreSQL along with how a table is scanned.
In the future I will be writing about indexes and how they can help to improve execution times and performance optimization.