Ouch. I’d recommend looking into pg_repack
to reclaim some space. It’ll be a painful process, but you can operate on smallest indexes and tables first to slowly relieve pressure.
Alternatively, you can TRUNCATE
the sentry_eventmapping
table with minimal impact. This should free up lots of space alone. This table only holds mappings for event ids to groups. This is usually ok compromise to reclaim a bunch of space.