Version 4.2.0

• New feature
  • Add pg_stat_statements.toplevel field (Marc Cousin, Julien Rouhaud)
• Bugfixes
  • Fix a possible long waiting time when the background worker is asleep and another session is waiting for a pending event, like a DROP DATABASE (Julien Rouhaud, thanks for github user anikin-aa for the report)
  • Fix pg_stat_kcache support when not all metrics are available (Julien Rouhaud)
• Misc
  • Add compatibility with postgres 16 (Julien Rouhaud)
  • Immediately exit the bgworker in binary upgrade mode, which could lead to data corruption in the powa database (Julien Rouhaud)

Version 4.1.4

• Bugfixes
  • Fix compatibility with standard_conforming_strings = off (Julien Rouhaud, per report from github user arnobnq)
• Misc
  • Add compatibility with postgres 15

Version 4.1.3

• Bugfixes
  • Handle possibly duplicated query in powa_statements_src (Julien Rouhaud, per report from github user gjedeer)
  • Fix column name and ORDER BY in powa_qualstats_aggregate_constvalues_current function (Adrien Nayrat)
  • Fix powa_kcache_src compatibility with pgsk 2.1- (Julien Rouhaud, per report from github user hrawulwa)
  • Fix powa_wait_sampling_unregister() to accept a server id (Julien Rouhaud)
• Performance improvement
  • Rewrite powa_qualstats_aggregate_constvalues_current with Window Function, making those at least twice as fast (Adrien Nayrat)
• Misc
  • Narrow the error condition in powa_prevent_concurrent_snapshot() (Denis Laxalde)
  • Make sure that GUC won't leak the extension script (Julien Rouhaud)
  • Don't rely on public being in search_path in event trigger code (Julien Rouhaud)

Version 4.1.2

• Bugfixes
  • Fix remote server removal by adding ON UPDATE / ON DELETE CASCADE clause
    for the powa_extensions foreign keys. Thanks to Andriy Bartash for the
    report.
  • Fix pg_qualstats snapshot. Thanks to github user alepaes1975 for the
    report.
  • Clear *_src_tmp tables on reset operation. Those tables are supposed
    to be empty, but if anything goes wrong and those tables contains
    problematic data, it could prevent users from cleaning up the situation.
    Thanks to Marc Cousin for the report.

Version 4.1.1

• Bugfixes
  • Fix regression tests for version 4.1 (Christoph Berg)

Version 4.1.0

4.1.0

• New features:
  • Add compatibility with pg_stat_statements 1.8 / pg13 (Julien Rouhaud)
  • Clean up statements that haven't been executed during the configured
    retention interval (Andriy Bartash)
  • Store the postgres and external extension versios in PoWA catalog (Julien
    Rouhaud)
  • Add compatibility with pg_stat_kcache 2.2 (Julien Rouhaud)
  • Don't require to load 'powa' anymore (Julien Rouhaud)
• Bugfixes
  • Ignore quals that don't match powa_statements row during snapshot. This
    fixes pg_qualstats foreign key errors that can happen during snapshots
    (Julien Rouhaud)
  • Fix pg_wait_sampling counters if multiple users run the same queries
    (Marc Cousin and Julien Rouhaud)

Version 4.0.1

Bugfixes:

• Fix typo in powa_all_relations_history_db_div
• Fix regression tests

Version 4.0.0

This is a major rework of PoWA. Please not that there is not upgrade to switch to this version. You need to remove the old one and install the new 4.0.0 version.

New features:

• Add a remote capture mode, allowing to gather data from a remote server and store them on a central repository. This avoids the overhead of storing and processing performance data on the local instance, and also allows using PoWA on hot-standby server (Julien Rouhaud, Thanks to Adrien Nayrat for extensive testing).
• Store new metrics added in pg_stat_kcache 2.1.0 (Julien Rouhaud)
• Aggregate relation statistics per database (Alexander Kukushkin)
• Add support for pg_qualstats 2.0.0 (Julien Rouhaud)
• Add a query_cleanup column to powa_functions (Julien Rouhaud)

Miscellaneous:

• Add support for makefile option NO_PGXS (Julien Rouhaud)
• Cleanup old databases after the expiration period, and stop gathering data belonging to dropped database when doing the snapshots (Marc Cousin)
• Fix possible bug with background worker type in pg_stat_activity (github user ppetrov91)
• Add some missing indexes (Julien Rouhaud, thanks to PoWA for noticing)
• Add compatibility with upcoming pg13 (Julien Rouhaud)
• Reduce noise is powa is disabled and the target database doesn't exist (Julien Rouhaud)

Bugfixes:

• Schema qualify powa_take_snapshot() call, so powa can work without public being in the superuser search_path (Julien Rouhaud)
• Fix powa_snapshot_metas dump config (Julien Rouhaud, reported by Adrien Nayrat)
• Fix long standing bug in pg_qualstats aggregation - Fix typos in SQL comments (Magnus Hagander)

Version 4.0.0beta1

*/!\ This is a beta version /!*

This is a major rework of PoWA. Please not that there is not upgrade to switch to this version. You need to remove the old one and install the new 4.0.0 version.

New features:

• Add a remote capture mode, allowing to gather data from a remote server
  and store them on a central repository. This avoids the overhead of
  storig and processing performance data on the local instance, and also
  allows using PoWA on hot-standby server (Julien Rouhaud, Thanks to Adrien
  Nayrat for extensive testing).
• Store new metrics added in pg_stat_kcache 2.1.0 (Julien Rouhaud)

Miscellaneous:

• Add support for makefile option NO_PGXS (Julien Rouhaud)
• Cleanup old databases after the expiration period, and stop gathering
  data belonging to dropped database when doing the snapshots (Marc Cousin)
• Fix possible bug with background worker type in pg_stat_activity
  (github user ppetrov91)
• Add some missing indexes (Julien Rouhaud, thanks to PoWA for noticing)

Bugfix:

• Schema qualify powa_take_snapshot() call, so powa can work without public
  being in the superuser search_path (Julien Rouhaud)

version 3.2.0

New features:

• Add support for pg_wait_sampling extension (Julien Rouhaud)
  Miscellaneous:
• Reduce logs when PoWA is deactivated (Julien Rouhaud)
  Bugfix:
• Fix possible bug if an error happens during the stats retrieval (Julien Rouhaud)