VACUUM: Bloat - Insufficient VACUUM Frequency

Check Frequency

Daily

Default Configuration

Detects when insufficient VACUUM frequency leads to avoidable growth in a table. It analyzes the table statistic from the past seven days and calculates the amount of rows that could have been avoided to grow if VACUUM had been performed more frequently. Creates an issue when such rows exceeds 20% of total new rows, as well as 10MB accumulated. Resolves once such growth decreases.

This check is enabled by default. These parameters can be tuned in the Configure section of the Alerts & Check-Up page.

Guidance

You can learn about VACUUM Advisor and insufficient VACUUM frequency insights in the VACUUM Advisor documentation. You can also learn more about bloat in general by reading about Bloat in Postgres.

---

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →