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 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)
    • 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)
  • Bugfix
    • 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)

3.2.0 (2018-10-14)

  • 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)

3.1.2 (2018-05-30)

  • Miscellaneous:
    • Add pg11 compatibility (Julien Rouhaud)
    • Catch errors in Debian packaging test script (Christoph Berg, spotted by Niels Thykier)

3.1.1 (2017-09-19)

  • Bugfix:
    • Fix unsafe coding with sighup handler (Andreas Seltenreich, Julien Rouhaud)
    • Make sure we wait at least powa.frequency between two snapshot (Marc Cousin and Julien Rouhaud)
    • Fix win32 portability of compute_powa_frequeny() (Julien Rouhaud)
    • Don't try to read dbentry->tables if it's NULL (Julien Rouhaud)
    • Fix compilation for platform with HAVE_CLOCK_GETTIME (Julien Rouhaud, reported by Maxence Ahlouche)
  • Miscellaneous:
    • Add pg10 Compatibility (Julien Rouhaud)
    • Only execute once the powa_stat functions (Julien Rouhaud)

3.1.0 (2016-07-29)

  • Fix issue leading to impossibility to stop the worker without shutting down the database
  • Fix cluster wide statistics to get fresh values
  • Report PoWA collector activity in pg_stat_activity and process title
  • add a new powa.debug parameter
  • Purge at the same frequency as we coalesce. We just don't do both at the same iteration
  • Fix bloat issue
  • Add + and / operators on powa types to get delta and counters per second given two records

3.0.1 (2016-02-09)

  • Don't track 2PC related statements, as they're not normalized by pg_stat_statements. Upgrade script will do all the needed cleanup.
  • Restore the install_all.sql file to easily setup PoWA.
  • Maintain a cache of pg_database to allow seeing dropped database in the UI. See issue https://github.com/powa-team/powa/issues/63
  • Don't try to load PoWA if it's not in shared_preload_libraries

3.0.0 (2015-11-06)

Please not that there is not upgrade to switch to this version. You need to remove the old one and install the new 3.0.0 version.

  • Handle pg_qualtats 0.0.7
  • Sample cluster wide statistics, for relations and functions
  • Fix the powa reset function, and rename it to powa_reset()
  • Add min/max records to improve performance when analyzing big time interval
  • Allow disabling some statistics sampling
  • Handle pg_track_settings extension
  • Add a GUC to ignore some users activity in sampled data

2.0.1 (2015-07-27)

  • Handle creation/suppression of supported extensions.
  • Remove the install_all script

2.0 (2015-02-06)

Major rework of the extension. PoWA 2 is now only compatible with PostgreSQL version 9.4 and above. PoWA 2 is also now compatible with external extensions, such as pg_qualstats or pg_stat_kcache. Third-part extensions can also now be implemented easily.

The UI is also now in a new repository, with more frequent release cycle.

1.2.1 (2015-01-16)

No changes in core.

New features and changes in UI : - UI is now compatible with mojolicious 5.0 and more - UI can now connect to multiple servers, and credentials can be specified for each server - Use ISO 8601 timestamp format - Add POWA_CONFIG_FILE variable to specify config file location - Better charts display on small screens

When upgrading from 1.2: - No change on the extension - the format of the database section of the powa.conf has changed, to allow multiple servers specification. Please read INSTALL.md for more details about it.

1.2 (2014-10-27)

News features and fixes in core : - Display more metrics : temporary data, I/O time, average runtime - Fix timestamp for snapshots - DEALLOCATE and BEGIN statements are now ignored - PoWA history tables are now marked as "to be dumped" by pg_dump - Improve performance for "per database aggregated stats"

News features and changes in UI : - Follow the selected time interval between each page - Add a title to each page - Display metrics for each query page - Move database selector as a menu entry - Display human readable metrics - Fix empty graph bug

When upgrading from older versions : - Upgrade the core with ALTER EXTENSION powa UPDATE. - The format of the database section of the powa.conf has changed. The new format is :

 "dbname"   : "powa",
 "host"     : "127.0.0.1",
 "port"     : "5432",

(instead of one line containing the dbi:Pg connection info)

1.1 (2014-08-18)

POWA is now production ready

Features:

  • Various UI improvments
  • More documentation
  • New demo mode
  • Plugin support
  • The code is now under the PostgreSQL license
  • New website
  • New logo

Bug fixes:

  • Use a temporary table for unpacked records to avoid unnecessary bloat

1.0 (2014-06-13)

Hello World ! This is the first public release of POWA

Features:

  • Web UI based on Mojolicious
  • Graph and dynamic charts
  • Packed the code as an extension
  • PL functions