PGCon2017 - 0626

PGCon 2017
The PostgreSQL Conference

Speakers
Stephen Frost
Schedule
Day Talks - Day 2 - 2017-05-26
Room DMS 1160
Start time 15:00
Duration 00:45
Info
ID 1098
Event type Lecture
Track Performance
Language used for presentation English
Feedback

UNDERSTANDING POSTGRESQL QUERY PLANS (AKA EXPLAIN)

Learn how to read EXPLAIN, EXPLAIN ANALYZE and about how you can influence query plans.

One of the most complex parts of the PostgreSQL system is the planner and the optimizer. This talk will help you understand what happens when you ask the database to execute a query on your behalf. We will go over EXPLAIN, EXPLAIN ANALYZE, other ways of running EXPLAIN, how to adjust parameters to view alternative possible plans, and what the output and results mean.