Explain Postgres Explain
Workshop 👥
Norwegian 🇳🇴
Tuesday, 3:45 – 5:45 PM
Length: 120 minutes
Room: Workshop E
Abstract
Bad SQL statements can ruin both performance and user experience. And in some cases, they can be quite hard to fix. Luckily most relational databases have a tool we can use to analyse the execution of queries, and understand where the problem lies. In this workshop we will be taking a look at Postgres' implementation of this functionality, called Explain. We'll use Postgres as it is a popular open-source alternative, but the principles you'll learn are transferrable to most other relational databases. We will talk about how to interpret the execution plans and get to know some of the most common operations. Underway, we'll be testing the theory on a supplied dataset to see how it works in practice. After completion, you should be able to read and analyse most queries. The workshop is intended for any developer who have basic knowledge of SQL, but want to understand how to improve their queries, or are just curious as to how a relational database works.
Prerequisites
Laptop with Git and Docker installed. If you have a preferred database client, it would be advisable to install it before the workshop. If not, a client will be supplied.
Day & time
Tuesday, 3:45 – 5:45 PM
Intended audience
The workshop is intended for any developer who have basic knowledge of SQL, but want to understand how to improve their queries, or are just curious as to how a relational database works.
Jørgen Langemyr
Jørgen works as a senior consultant for Kantega, with previous experience from Kongsberg Gruppen. And he is passionately interested in all things backend.