Monitor Database Index Bloat in Python

import random
import time

class IndexBloatMonitor:
    def __init__(self, thresholds=(0.5, 0.8, 0.9)):
        self.thresholds = thresholds
        self.indices = {
            "users_pk": 48.2,
            "orders_created_idx": 124.7,
            "products_name_idx": 15.3,
            "payments_user_idx": 203.9,
        }
    
    def _simulate_bloat(self):
        for key in self.indices:
            self.indices[key] += random.uniform(0.1, 2.5)
    
    def check(self):
        self._simulate_bloat()
        alerts = []
        for name, size in self.indices.items():
            bloat_ratio = random.uniform(0.0, 1.0)
            status = "healthy"
            if bloat_ratio > self.thresholds[2]:
                status = "critical"
            elif bloat_ratio > self.thresholds[1]:
                status = "warning"
            elif bloat_ratio > self.thresholds[0]:
                status = "monitor"
            alerts.append((name, size, bloat_ratio, status))
        return alerts


if __name__ == "__main__":
    monitor = IndexBloatMonitor()
    for index_name, size_mb, bloat, level in monitor.check():
        print(f"{index_name}: {size_mb:.1f} MB, bloat {bloat:.0%} -> {level.upper()}")