Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore the inner workings of database query execution and optimization in this 57-minute talk focused on PostgreSQL. Delve into the representation of queries as trees, examine fundamental query optimization techniques, and gain insights into the Postgres query planner. Through practical examples, learn how the planner utilizes statistics, estimates costs, and determines execution plans. Analyze query plans, identify potential issues, and discover strategies to assist the planner in improving performance. Access accompanying slides for a comprehensive understanding of PostgreSQL query planning processes.
