Basic understanding of EXPLAIN ANALYZE

Justin Harvey

PostgresConf South Africa 2019

https://postgresconf.org/conferences/SouthAfrica2019/program/proposals/basic-understanding-of-explain-analyze

My talk is a beginners guide to using and understanding EXPLAIN ANALYZE.

This will include understanding: -INDEX SCAN VS. BITMAP SCAN VS. SEQUENTIAL SCAN (BASICS) -B-tree vs GIN vs GiST vs SP-GiST vs BRIN vs HASH -Costs and actual times

This is for unskilled and new PostgreSQL users.