Skip to content
Health
52/100
fair
  • Security22/25
    1 minor finding
  • Activity20/25
    Last human commit 9 months ago
  • Required by5/25
    0 modules depend on it
  • Maturity5/25
    In 1 Odoo series since 18.0

Heuristic over the facts below, not an audit · How it's computed

Security findings
Grave / minor (static analysis)
Required by
0
Modules depending on it
External deps
0 pip · 0 bin
Python packages / system binaries
License
LGPL-3
No conflicts with its dependencies
Folder size
0.05 MB
Module directory on disk
Code analysis 0 migration notes 2 models 3 views 0 HTTP endpoints

Description

Database Autovacuum Tuning helps administrators keep PostgreSQL healthy by exposing recommended autovacuum settings in Odoo. It provides guidance and documentation for sizing thresholds and scale factors so large, busy databases avoid table bloat and excessive vacuum lag. Use it to standardize autovacuum configuration across environments and speed up maintenance operations without manual tuning.

This module is mostly useful for PostgreSQL <= 17. PostgreSQL 18.0 introduces the autovacuum_vacuum_max_threshold parameter, which already provides the capability this module targets.

The pgstattuple extension must be installed on the database.

Dependencies

Odoo dependencies
odoo/odoo:
- web
Python dependencies
None
System dependencies
None
Required by
None

Code analysis

Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.

Views touched 3

XML IDNameModelTypeStatus
database_autovacuum_tuning_view_tree database.autovacuum.tuning list New
databaseautovacuum_tuning_view_search database.autovacuum.tuning search New
res_config_settings_view_form Database Autovacuum Tuning Settings res.config.settings form Inherits base_setup.res_config_settings_view_form

HTTP endpoints 0

No HTTP endpoints found for this module.

Models touched 2

New fields (3)
  • analyze_threshold Integer
  • name Char
    help='Table name' required=True
  • vacuum_threshold Integer
Public methods (0)

No public methods.

New fields (2)
  • autovacuum_vacuum_analyze_max_threshold Integer
    config_parameter='database_autovacuum_tuning.autovacuum_vacuum_analyze_max_threshold'
  • autovacuum_vacuum_max_threshold Integer
    config_parameter='database_autovacuum_tuning.autovacuum_vacuum_max_threshold'
Public methods (0)

No public methods.