Basic understanding of EXPLAIN ANALYZE

Justin Harvey
PostgresConf South Africa 2019
postgresconf.o...
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.