Скачать или смотреть Make PostgreSQL Queries Faster | EXPLAIN Plans, Indexes & SQL Tuning Basics

No matter how advanced hardware, query planners, or AI become, users still care about one thing:
⚡ How fast does my query respond?

In this session, we open up the PostgreSQL performance beginner’s toolbox and focus on the first places to look when queries or applications slow down—and yes, in 2024, human intervention still matters.

🔍 What you’ll learn in this talk:

How to read and use EXPLAIN & EXPLAIN ANALYZE effectively

Key PostgreSQL settings to tune problem queries

When and how to use indexes (and when not to)

Basics of partitioning for performance

Practical SQL tips to improve slow queries

Tools and features to diagnose unexpected performance issues


This session is perfect for developers, DBAs, SREs, and backend engineers who want a practical, no-nonsense approach to speeding up PostgreSQL queries in real-world systems.

🎯 Walk away with actionable ideas you can apply immediately in your day-to-day PostgreSQL work.

👉 Like, share, and subscribe for more deep dives into PostgreSQL tuning, performance engineering, and production troubleshooting.