Indexes don’t lie — but they don’t tell the whole story either

Recently, I’ve been deep in PostgreSQL performance work — analyzing execution plans, tuning materialized views, chasing down GroupAggregate…