So I was not aware of this in the docs:
Gotcha: You cannot use pgBouncer to perform
Which I did. I have had a few issues with migrations that failed but ended up finishing.
So far my instance seems fine but the reports have been broken for months now:
Is there a way I could run the appropriate DB migrations again (without pgbouncer) in order to fix that?