TLDR Tech / Data
Adding an Index Made This Query Slower
An index matching ORDER BY in Postgres can still hurt when the filtered rows sit far down that index: inspect Rows Removed by Filter, test representative parameters, and use a composite index that matches both the filter and ordering.
Read the full story