ADDING AN INDEX MADE THIS QUERY SLOWER

Summary from the TLDR Data newsletter

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.