SYNOTI / Long-Term Metrics
Long-Term Metrics
ClickStat rollups and materialized views for long retention.
Daily Rows
120M
rolled up
MV Tables
8
materialized
Compression
12.4x
avg ratio
Retention
180d
long-term
Rollup Trend
Materialized Views
| View | Granularity | Rows | Last Run |
|---|---|---|---|
| events_1h | 1 hour | 5.2M | 4m |
| events_1d | 1 day | 120M | 1h |
| alerts_1h | 1 hour | 86K | 4m |
| services_1d | 1 day | 2.1M | 1h |
Recent Activity
View allPipeline lag 14ms — nominal
3,204 events/sec across 8 streams
Data store compaction finished
Reclaimed 42 GB · 0 dropped samples
Dashboard 'SOC-24h' auto-refreshed
12 panels · 6 queries cached
Long-term retention rollup for May
Aggregated 1.2B samples 64M datapoints
Disk usage on ch-02 at 71%
Predicted full in 12 days · alerting set
Anomaly centroid drift detected on 'nginx'
Detector recalibrated automatically