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
Posted on 2026-09-16 by pgAssistant dev team
Related Open Source
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:
Workload Insights compares consecutive collections and highlights:
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
| # | Наименование новости | Тональность | Информативность | Дата публикации |
|---|---|---|---|---|
| 1 | SQL Manager for PostgreSQL 7.0: meet the AI Assistant | 0 | 7.82 | 22-09-2026 |
| 2 | PostgresCompare 2.2.0 Released | 0 | 12 | 22-09-2026 |
| 3 | powa-archivist 5.2.0 is out! | 0 | 5 | 12-07-2026 |
| 4 | pgAdmin 4 v9.18 Released | 0 | 10.22 | 17-09-2026 |
| 5 | pgsql-test: Real Postgres Testing for Faster Development Loops | 0 | 7.47 | 22-09-2026 |
| 6 | PostgreSQL Migrator 1.0 : first stable release | 0 | 10.42 | 10-09-2026 |
| 7 | PostgreSQL 19 Beta 4 Released! | 0 | 8.58 | 24-09-2026 |
| 8 | PostgreSQL 19 Beta 2 Released! | 5 | 7 | 16-07-2026 |
| 9 | CERN PGDay 2027: Announcement and CfP | 0 | 12.57 | 11-09-2026 |
| 10 | Barman 3.19.0 and 3.19.1 Released | 2 | 6 | 08-07-2026 |