Gain Actionable Insights into your Postgres Performance with our Dashboard
See bloated tables and indexes
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.
Find and remove indexes you don't need
Duplicate and unused indexes are nothing more than wasted disk space and the app helps clean them up and free up some disk space.
Get rid of slow queries
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.
Understand how big your tables are
Magistrate breaks down table statistics to give insights into how much data is in your tables.
