Before and After - Fixing a Real Slow Postgres Query
📝 Get the SQL Performance Checklist: https://databasestar.mykajabi.com/lpk... 📝 Get the AI prompt from this video: https://databasestar.mykajabi.com/lpk... 🎓 Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/off... In this video, you'll see a before and after example of a slow Postgres query being optimised, how it compares to an AI analysis, and what the final performance improvement is. TIMESTAMPS: 00:00 - Understand the query 01:22 - See the execution plan 04:53 - Non-sargable condition 07:34 - Add index 09:45 - AI Analysis 12:17 - Query rewrite
▶︎
SQL Performance Myths (And What Actually Hurts)
▶︎
How to Measure Query Performance in SQL
▶︎
MCP vs API: Simplifying AI Agent Integration with External Data
▶︎
Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker
▶︎
PostgreSQL Crash Course - Beginner Tutorial
▶︎
I Let Copilot Analyse My Slow Query. Was It Right?
▶︎
The NoSQL Lie That Keeps Developers Overbuilding
▶︎
Slow SQL Server Query: AI vs Me
▶︎
How Instagram Scaled Postgres to 2 Billion Users
▶︎
Postgres can replace your entire stack...
▶︎
Tune SQL Like a Senior Developer
▶︎
Reinventing Entropy | Compression is Intelligence Part 1
▶︎
How To Think SO CLEARLY People Assume You're A Genius
▶︎
System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎
Solving one of PostgreSQL's biggest weaknesses.
▶︎
7 Simple Tricks to Instantly Make Your SQL Queries Better
▶︎
Why Your SQL Is Slower Than It Should Be
▶︎
30 Seconds to 4 Seconds - A Real SQL Server Case Study
▶︎
Slow Queries Are Costing Your Team More Than You Think
▶︎