Blocked by #2121 calculate/store daily metrics from the alert_metrics table to allow efficient lookup of yearly metrics # daily_alert_metrics table | id | date | service_id | alert_count | avg_tta | avg_ttc | escalated_alerts_count=0 | | --- | ---- | ---------- | ----------- | ------- | ------- | ------------------------ | index on (service_id, date) -- look for postgres spacial date index type