Version 5.0.0

• New features:
  • Complete rewrite of the UI using (currently) modern frameworks and libraries. It is now built with ViteJS, VueJS, Vuetify and d3. (Marion Giusti, Pierre-Louis Gonon and Pierre Giraud. Thanks to Dalibo for sponsoring this work).
  • Allow forcing a snapshot or requesting a catalog refresh from the UI (Julien Rouhaud)
  • Handle any extension installed in any schema (Julien Rouhaud)
  • Add support for PostgreSQL 17 (Julien Rouhaud)
  • Add widgets for pg_stat_user_functions metrics (Julien Rouhaud)
  • Add pg_stat_activity graphs on the per-server and per-db pages (Julien
    Rouhaud)
  • Add table / index bar graphs on the per-server and per-db pages (Julien Rouhaud)
  • Add pg_stat_archiver widgets (Julien Rouhaud)
  • Add pg_stat_replication widgets (Julien Rouhaud)
  • Add pg_stat_database widgets (Julien Rouhaud)
  • Add pg_stat_replication_slots widgets (Julien Rouhaud)
  • Add pg_stat_io widgets (Julien Rouhaud)
  • Add pg_stat_database_conflicts widgets (Julien Rouhaud)
  • Add pg_stat_slru widgets (Julien Rouhaud)
  • Add pg_stat_wal widgets (Julien Rouhaud)
  • Add pg_stat_wal_receiver widgets (Julien Rouhaud)
  • Add pg_stat_subscription(_statistic) widgets (Julien Rouhaud)
  • Handle new IO timing and JIT counters added in newer pg_stat_statements
    versions (Julien Rouhaud)
• Bug fixes:
  • Properly handle metric groups that don't return any row (Julien Rouhaud)
  • Properly handle SQL error when retrieving execution plans (Julien Rouhaud)
  • Ignore query texts truncated by pg_qualstats when getting a sampled query (Julien Rouhaud)
  • Fix the worker status retrieval for local server on the config page (Julien Rouhaud)
  • Detect insufficient privilege when checking for collector processes (Julien Rouhaud)
• Misc:
  • Assume pg10+ server if no remote connection is available (Julien Rouhaud)
  • Remove sqlalchemy dependency (Julien Rouhaud)
  • Split the list of extensions in configuration page to multiple categories depending on their use (Julien Rouhaud)
  • Show server alias in the breadcrumb selector (Pierre Giraud)

Version 4.2.1

sqlalchemy > 1.4 is not supported (thanks to David Mödinger for the report)

Version 4.2.0

New feature:

• Add support for pg_stat_statements.toplevel, added in pg_stat_statements version 1.9 (Julien Rouhaud)

Version 4.1.4

New features:

• Add support for HTTPS (Julien Rouhaud, per initial request from github user hrawulwa, then further requests from github users banlex73 and guruguruguru. Thanks also to github user guruguruguru for testing the feature)

Bug fixes:

• Fix explain plan css (Julien Rouhaud, per report from github user Ravi160492)
• Fix detection of nodes with the same qualid in the global index suggestion wizard (Pierre Giraud)
• Fix detection of powa bgworker in the config page (Julien Rouhaud)

Misc:

• Improve grid queries performance (Marc Cousin and Julien Rouhaud)
• Improve login form serverlist (Uwe Simon)

Version 4.1.3

New features:

• Add a new cookie_expires_days option (Julien Rouhaud, per request from github user Kamal-Villupuram)
• Use pgsql language set for highlighting (Christoph Dreis)

Bug fixes:

• Allow missing pg_stat_kcache records (Julien Rouhaud, per report from Christoph Dreis)
• Fix query unjumbling code (Julien Rouhaud, per report from Martin Aparicio and Frédéric Yhuel)
• Correctly handle multiple queries with the same qual in the wizard (Julien Rouhaud)

Misc:

• Update build and build dependencies and highlight.js (Christoph Dreis)

Version 4.1.2

Bug fixes:

• Restore compatibility with tornado 2.0, thanks to github user hrawulwa for the report.
• Fix detection of extension in local mode (Julien Rouhaud, thanks to Magnus Hagander for the report)

Version 4.1.1

New features:

• Use locally available info for remote server configuration page when possible (Julien Rouhaud)

Bug fixes:

• Fix per-query page for queries with identical query identifier executed on multiple remote servers (Julien Rouhaud)
• Properly handle situation where the UI doesn't know the remote server PostgreSQL version (Julien Rouhaud)
• Fix local server detection (Julien Rouhaud, thanks to github user alepaes1975 for the report)

Version 4.1.0

New features:

• Add compatibility with pg_stat_statements 1.8, and expose all new counters (Julien Rouhaud)
• Add compatibility with pg_stat_kcache 2.2 (Julien Rouhaud)

Version 4.0.2

New features:

• Add powa_coaslesce setting on config page (Adrien Nayrat)

Performance improvements:

• Fix a cartesian product in the predicate view (Adrien Nayrat)
• Fix multiple queries so they can use the existing indexes (Adrien Nayrat)
• Multiple performance improvements on the per-predicate views (Adrien Nayrat and Julien Rouhaud)

Bug fixes:

• Properly ignore queries that weren't called on the given interval (Adrien Nayrat)
• Don't display the last retrieved value on graphs, as the value is known to
  always be zero and lead to wrong graphs (Adrien Nayrat)
• Fix links to documentation (Matthias Dötsch)
• Fix collector worker status state when srvid greater than 9 (Julien Rouhaud, thanks to Adrien Nayrat for the report)

Version 4.0.1

Bug fixes:

• Fix per-query hypothetical index checking for remote servers (Julien Rouhaud, thanks to github user hrawulwa)