I think I screwed up.
I was running something in the background to update a table based on the jobs
output (once every 1-10 seconds) and while that was running I created an index
on the same table.
Now that index is not used according to explain plans.
It does show up when I type '\di'
But I can't DROP INDEX.
I think I'm in some trouble but I don't know how much.