Practical Postgres: Query Plans You Can Read
Downtown Rockford · Rockford, IL
July's meetup was a hands-on tour of Postgres query planning: reading EXPLAIN ANALYZE output without dread, spotting sequential scans that should be index scans, and knowing when the planner is smarter than you (usually) and when it isn't (memorably).
Talks from this meetup
Query Plans You Can Read
Sam Delgado
EXPLAIN ANALYZE produces a wall of text that most of us squint at and close. This talk builds a reading strategy: find the expensive node, understand why the planner chose it, and learn the three fixes that solve ninety percent of slow queries.
Sam is a database engineer who has spent a decade making other people's queries faster and only occasionally making them slower first.