Postgresql table not auto analyzed warning
Table {{ $labels.relname }} has not been auto analyzed for 10 days
>>>
((
+
+
) >
) and (
time
() -
) > 24 * 60 * 60 * 10
The alert fires when the sum of deleted, updated, and HOT‑updated rows for a table exceeds the autovacuum_analyze_threshold and the table has not been auto‑analyzed for at least 10 days (10 × 24 × 60 × 60 = 864000 seconds). In that case Prometheus triggers the "Postgresql table not auto analyzed" alert, inserting the table name via the relname label.
Get Alert✕
Download
Copy to Clipboard