On January 30th, TimescaleDB was running low on storage. To mitigate the issue, we began cleaning up unused indexes. However, one of the removed indexes was actively used by a custom dashboard, which subsequently led to degraded dashboard performance.
In response, we promptly initiated an index rollback to restore dashboard performance and minimize customer impact.
One of the databases supporting custom dashboards was nearing its storage limit. To address this, we began reclaiming space through reindexing and applying data retention policies. During this cleanup process, a specific index - believed to be unused - was dropped to free up space. However, this index was actively used by the custom dashboard, leading to degraded performance.
VACUUM and ANALYZE operations to ensure accurate index usage statistics, and establish a robust review process to validate dependencies before dropping any indexes.