>
> Way to many indexes. I'm going to have a hard time convincing our
> programmers to get rid of any of them )
>
You can create (concurrently) an identical index with a new name, then drop
old version concurrently and repeat for each. It doesn't help you figure
out the root cause and how to prevent it from happening again, but gets you
to a fresh start at least.