Why the index I added made my query slower

I added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.