pgAssistant 3.8.0 : continuous improvement loop for Postgres

With this release, pgAssistant is evolving beyond PostgreSQL analysis and tuning to become a continuous PostgreSQL improvement platform.

The new positioning is built around a continuous improvement loop:

Observe → Diagnose → Prioritize → Plan → Implement → Collect again → Measure

pgAssistant already helped identify what should be improved and turn recommendations into a prioritized Executive Plan with clear DEV and OPS ownership.

Combined with pgAssistant Collector, version 3.8.0 goes further by adding historical workload and environment measurements. The objective is to answer four essential questions:

• What should we improve?
• What did we decide to do?
• What did we actually change?
• What was the result?

Workload Insights compares consecutive collections and highlights:

• new and no-longer-detected recommendations;
• changes to the PostgreSQL version and configuration;
• workload evolution by statement type;
• changes in execution time and call volume;
• the queries with the greatest impact on the overall workload.

The ambition is to correlate the application of pgAssistant recommendations and the Executive Plan with observed performance changes.

Correlation is not causation, and a recommendation that is no longer detected does not necessarily prove that it was implemented. pgAssistant keeps these distinctions explicit while bringing the relevant evidence together in one place.

pgAssistant is not intended to replace real-time monitoring. Monitoring shows what is happening now; pgAssistant helps teams decide what to improve next, organize the remediation work, and measure what changed afterwards.

From recommendations to action—and from action to measurable evidence.

pgAssistant 3.8.0: https://github.com/beh74/pgassistant-community

pgAssistant Collector: https://github.com/beh74/pgassistant-collector

pgAssistant Grafana : https://github.com/beh74/pgassistant-grafana