Why isn't PostgreSQL using my index

[xluffy]

There are two main reasons that Postgres will not use an index. Either it can’t use the index, or it doesn’t think using the index will be faster.

https://www.pgmustard.com/blog/why-isnt-postgres-using-my-index