Magistrate shows a list of tables and indexes that meet our criteria for bloat worth caring about. If you would like to mitigate the bloat, Magistrate provides intelligently generated SQL using established best practices you can run to help.
Duplicate and unused indexes are nothing more than wasted disk space and the app helps clean them up and free up some disk space.
Magistrate takes slow queries from the pg_stat_statements extension and sorts them in a way that prioritizes the impact improving the query would have on the system.
Magistrate breaks down table statistics to give insights into how much data is in your tables.