PGCon2017 - 20180510
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 |
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.