Overview

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.

Recommendation

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.