Magistrate Postgres Stats for Developers

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.