> 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.
Have you vacuum analyzed that table? Maybe the statistics still think a
table scan is the best option?