Indexing & Query PlanningIndexing & Query PlanningMaking the planner choose the fast path.Copy MarkdownOpenMaking the planner choose the fast path. Sections6.1IndexingB-Tree, Hash, GIN, GiST, BRIN, SP-GiST6.2Query PlannerCost model, statistics, scan and join strategies6.3EXPLAIN & EXPLAIN ANALYZEReading execution plansLocks & DeadlocksRow/table locks, lock modes, advisory locksIndexingB-Tree, Hash, GIN, GiST, BRIN, SP-GiST