How a Single Index Cut Query Time from Minutes to Milliseconds

Failed to add items

Sorry, we are unable to add the item because your shopping cart is already at capacity.

Add to basket failed.

Please try again later

Add to wishlist failed.

Please try again later

Remove from wishlist failed.

Please try again later

Adding to library failed

Please try again

Follow podcast failed

Unfollow podcast failed

How a Single Index Cut Query Time from Minutes to Milliseconds

Listen for free

View show details

In this episode, Lucas and Luna dive into the story of how one database index — just one — turned a query that took over two minutes into a response that came back in under twenty milliseconds. They walk through the specific scenario: a PostgreSQL database on AWS RDS, a SaaS startup seeing page load times spike to critical levels, and the engineer who found the problem by examining the query plan. Along the way, they explain what a B-tree index actually does under the hood, why sequential scans kill performance at scale, how to read an EXPLAIN ANALYZE output like a pro, and the counterintuitive truth that adding an index can sometimes slow things down. This is a concrete, actionable episode for anyone who works with databases — no theory without practice. #DatabasePerformance #PostgreSQL #QueryOptimization #Indexing #BTreeIndex #ExplainAnalyze #SequentialScan #RDS #AWS #BackendEngineering #SoftwareEngineering #TechPodcast #DatabaseTuning #Latency #ProductionDebugging #FexingoBusiness #BusinessPodcast #Technology Keep every episode free: buymeacoffee.com/fexingo

No reviews yet