Explaining EXPLAIN: A Deep-Dive into EXPLAIN Plans

preview_player
Показать описание
For developers and DBAs, this talk discusses what EXPLAIN does, how to interpret its output, what inferences can be extracted from its output, and what can be done to improve query performance.
Рекомендации по теме
Комментарии
Автор

24:54 says EXPLAIN ANALYZE is not completely accurate either. Which statistics from EXPLAIN ANALYZE are not accurate? Anyway to make it accurate?

Han-veuh