Gold Lapel
How it works
Integrations
The Study
The Book Get Started
← The Grounds

Indexes & Missing Index Detection

The right index turns a full-table scan into a microsecond lookup. The wrong one wastes disk and slows writes. B-tree, GIN, partial, composite — and how to detect the ones you are missing.

1 A Proper Introduction to PostgreSQL Index Types2 PostgreSQL Composite Indexes: Column Order Is Not a Suggestion3 PostgreSQL Partial Indexes: An Elegant Solution for Particular Queries4 PostgreSQL Missing Index Detection: Automatic Recommendations5 How to Detect Missing Indexes Automatically with pg_qualstats6 HypoPG: Test PostgreSQL Indexes Without Creating Them7 HypoPG + pg_qualstats: Automatic Index Recommendations for PostgreSQL8 HypoPG in CI/CD: Automated Index Testing for PostgreSQL
Gold Lapel © 2026 Gold Lapel
The Waiter's correspondence
Company About Press thewaiter@goldlapel.com
Legal Terms Privacy