Cleanup bloated postgres index

SELECT datname, pg_size_pretty(pg_database_size(datname))
FROM pg_database
ORDER by pg_database_size(datname) DESC;

select table_name, pg_size_pretty(pg_total_relation_size(quote_ident(table_name)))
from information_schema.tables
where table_schema = 'public'
order by pg_total_relation_size(quote_ident(table_name)) desc;

REINDEX TABLE hungry;