Indexing

Index creation, maintenance, monitoring, and optimization strategies

How-to guides

How to monitor CREATE INDEX / REINDEX progress in Postgres 12+

Difficulty: advanced • Time: 5 min

Over-indexing

Difficulty: beginner • Time: 5 min

Index maintenance

Difficulty: beginner • Time: 5 min

How to find unused indexes

Difficulty: beginner • Time: 7 min

How to find redundant indexes

Difficulty: beginner • Time: 6 min

How to rebuild many indexes using many backends avoiding deadlocks

Difficulty: intermediate • Time: 5 min

Get AI-powered index recommendations

Use our free index advisor to get expert recommendations for B-tree, GIN, GiST, BRIN, and hash indexes, including multi-column and covering index strategies.