Postgresql too many dead tuples warning
PostgreSQL dead tuples is too large
>>>
((
> 10000) / (
+
)) >= 0.1
The rule evaluates each user table and triggers when the number of dead tuples is over 10,000 and those dead tuples make up at least 10 % of the total rows (dead + live). In other words, if (dead / (live + dead)) >= 0.1 while dead > 10000, the alert fires.
Get Alert✕
Download
Copy to Clipboard