Low row estimation is the cause. It predicted 6k~ and ended up doing millions.

I guess the fix is a better index, key, join, etc. However, can you take a moment to tell me what is logically going on, and how the lack of one or more of those items makes this occur?