Postgres FM Intro to query optimization
Sep 2, 2022
This podcast discusses query optimization in Postgres, including the use of 'explain' command, analyzing query performance, common mistakes in query optimization, and the impact of enabling timing on in Postgres. It also emphasizes the importance of query optimization on performance and invites listener engagement for future topics.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 2min
Analyzing Query Performance with Explain and Explain Analyze
02:24 • 8min
Query Optimization Mistakes and Tools
10:26 • 14min
Exploring the Overhead of Enabling Timing on in Postgres
24:20 • 2min
Query Optimization and its Impact on Performance
26:45 • 4min
Discussion on Query Optimization and Listener Engagement
30:41 • 3min