PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Bruce Momjian
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Monpetit 202
Start time 16:15
Duration 00:45
ID 668
Event type Lecture
Track Performance
Language used for presentation English

Explaining the Postgres Query Optimizer

The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution.

This talk uses the EXPLAIN command to show how the optimizer interprets queries and determines optimal execution. Examples include scan methods, index selection, join types, and how ANALYZE statistics influence their selection. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behavior.