Releases: CrunchyData/pgmonitor-extension
Releases · CrunchyData/pgmonitor-extension
v2.0.0
FEATURES
- Compatible with PostgreSQL 17
BREAKING CHANGES
- PG17 restructured the pg_stat_bgwriter catalog information. This extension has been restructured around those changes:
- Changed the
ccp_stat_bgwriter
metric from a materialized view to a standard view - Removed columns from
ccp_stat_bgwriter
that are no longer part ofpg_catalog.pg_stat_bgwriter
- New metrics views created:
ccp_stat_checkpointer
andccp_stat_io_bgwriter
. These align with where the columns frompg_stat_bgwriter
were moved to. - For versions of PG older than 17, these new metrics still apply and simply pull that data from the original
pg_stat_bgwriter
catalog and present them in the new format. - All applications that made use of the old
ccp_stat_bgwriter
metric will need to be updated to use the new metrics. - Due to dropping old metrics and recreating new ones, permissions may need to be regranted to any monitoring roles that use these new views.
- Changed the
v2.0.0-beta2
Beta release with support for PG17
- Fixes syntax error in update script from beta1
v2.0.0-beta1
Beta release with support for PG17