At least you have access to USE INDEX on MySQL. On Postgres it's not rare to have a query suddenly perform awful in production because some switch flipped in the planner and now it's picking some random index
Edit: Never mind, found it https://www.postgresql.org/docs/19/pgplanadvice.html