A real-world debugging story about how a subtle interaction between OR clauses and PostgreSQL indexes was silently tanking our batch job performance, and how a small query rewrite fixed everything.