New features:
- Make the UI compatible with remote-mode setup (Julien Rouhaud)
- Query and display powa-collector information (Julien Rouhaud)
- Expose system cache hit / disk read metrics on global and per-database pages (Julien Rouhaud)
- Expose new metrics added in pg_stat_kcache 2.1 (page faults, context
switches...) on global, per-database and per-query pages (Julien Rouhaud) - Add wait events graphs on global and per-database pages (Julien Rouhaud)
- Add queries per second counter on global and per-database pages (Julien Rouhaud)
- Display configuration changes and PostgreSQL restart on graphs when pg_track_settings is configured (Julien Rouhaud)
- Add an url_prefix parameter (Julien Rouhaud and github user rippiedoos)
- Add options to forbid the UI from connecting to databases different than the dedicated powa one, or to remote server, either globally or per server.
- Provide metric definitions and link to the documentation on the graph
(Julien Rouhaud) - Add pg_stat_bgwriter graphs (Julien Rouhaud)
- Add database objects (based on pg_stat_all_tables info) graphs (Julien Rouhaud)
- Move the "other queries" panel to its own grid (Ronan Dunklau)
- Multiple UI improvements (Pierre Giraud)
Bug fixes:
- Fix longstanding bug in graph hover boxes position (Julien Rouhaud)
- Fix the graph preview selection (Julien Rouhaud)
- Add pg_wait_sampling in the config extension list (Julien Rouhaud, thanks to Adrien Nayrat for the report)
- Don't try to detect if a hypotetical index would be used if no suitable index is detected (Julien Rouhaud, thanks to Guillaume Lelarge for the report)
- Fix lost filter when changing the time range (Pierre Giraud, thanks to Marc Cousin for the report)
- Fix database wizard query validation for pg11+ (Julien Rouhaud)
- Handle hypopg unsupported access methods in dataabase wizard (Julien
Rouhaud, thanks to Adrien Di Mascio for the report) - Fix compatibility with SQLAlchemy 1.3+ (Julien Rouhaud, thanks to github
user mchubby and irc user ChOcO-Bn for the report) - Fix query detail if no data is found on the selected range (Julien Rouhaud,
thanks to irc user ChOcO-Bn for the report) - Fix some metrics in wait events and general query datasources (Julien
Rouhaud, thanks to Adrien Nayrat for the report) - Fix per-server graphs having multiple data and pg_stat_kcache enabled
(Alexander Kukushkin) - Fix #calls and #rows metrics on the per-query page (Julien Rouhaud)
- Fix query detail and performance problems on quals (Ronan Dunklau)
- Fix queries for pg_stat_kcache and pg_qualstats (Ronan Dunklau)
- Fix query details when multiples users run the same query (Julien Rouhaud)
- Fix global databases metrics query (Alexander Kukushkin)
- Fix long standing bug in pg_qualstats aggregation
- Fix data retrieval when a time interval spread over more than 2 aggregated
rows
Misc:
- Display server's alias instead of hostname:port (Adrien Nayrat)
- Support pg_qualstats 2 (Julien Rouhaud)