Justin Harvey
Mr at GoodX Software
About
Justin Harvey has presented the following presentations
Basic understanding of EXPLAIN ANALYZE
at
South Africa 2019
presented by Justin Harvey
Good day,
My talk will be 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.
Kind regards, Justin
Tue 8 2019 Ops and Administration