Postgres Monitor Logo
Alpha Release

Demo Account

Unused Index Recommendation

Page Outline


An unused index is one where the Postgres Monitor agent has not detected any queries using it in the past 24 hours.

Unused indexes take up additional disk space and can slow down writes to the table, so it is recommended to remove them.


If an unused index is detected, a recommendation will be created for the affected index. Take action to drop the index or ignore the recommendation to remove it from your recommendation dashboard.

If there are plans to use the index in the future, then the index should be kept.