1. find db byte sizes
SELECT datname, pg_size_pretty(pg_database_size(datname))
FROM pg_database
ORDER by pg_database_size(datname) DESC;
2. find tables + indices sizes
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;
3. recreate index
REINDEX TABLE hungry;
Conclusion
index shrank from ~12GiB to ~800MiB
![Github logo](https://knrdl.github.io/github.png)