Learn the basics of query optimization in PostgreSQL®. From understanding the path of the query to optimizing your indexes and joins, we’ll cover the foundation, tools and techniques to improve the performance of your SQL queries.
Open to beginner levels, though the knowledge of SQL basics is desired.

We'll cover the following topics:

• Understanding the query execution flow and path of the query.
• Using tools such as ANALYSE and EXPLAIN
• Efficient usage of indexing
• To join or not to join that is the question
• Spotting query issues
• Reason behind the table bloat and why we need to vacuum the data
• Applying UI Tools

Prerequisites

• A web browser.
• An Aiven account, using our free trial. We will lead you through setting that up in the workshop, if you don’t already have one.
• A GitHub account. Here’s the GitHub repository we’ll be using: https://github.com/Aiven-Labs/workshop-sql-optimization
• We’ll use GitHub Codespaces as our working environment.

RESOURCES
Create your free Aiven account: https://go.aiven.io/youtube-signup

AIVEN DATA PLATFORM
The Aiven Platform is more than a collection of open source services for streaming, storing and analyzing data. The platform ensures that all services run reliably and securely in the clouds of your choice, are observable, and can easily be integrated with each other and with external 3rd party tools.

CONNECT WITH US
Website: http://aiven.io​​​
LinkedIn: https://www.linkedin.com/company/aiven/
GitHub: https://github.com/aiven​​​
X: https://twitter.com/aiven_io