Skip to content

Releases: trix/pg_peek

v0.2.1

Choose a tag to compare

@defkode defkode released this 03 Oct 09:14
  • New: pg_stat_statements has its own page: when statistics were last reset, how full its table is (pg_stat_statements.max), how many statements the server dropped for lack of room, its settings and the reset button. Every "stats since" link leads there, including from the job and endpoint pages. (#56)
  • New: tables have their own page in the top menu; the overview no longer lists them. (#57)
  • Long queries are laid out one clause per line, with WHERE conditions indented, and wrap at spaces instead of inside names. A query longer than three lines shows its start, with a "show all" toggle. (#58)

v0.2.0

Choose a tag to compare

@defkode defkode released this 02 Oct 14:50
  • New: every endpoint has its own page listing its queries, linked from the overview, the endpoints page and the SQL tags. The endpoints page has a filter. (#44, #45)
  • Fix: job names are shown decoded (Control::RunPrecalculationsJob, not Control%3A%3A…), link to their page with a plain URL, and keep their capital letters in page titles. (#42, #46)
  • The attention list flags only what needs action: dead tuples only past autovacuum's own trigger point, unused indexes only of at least unused_index_min_size (default 1 MB) and once statistics are older than unused_index_min_stats_age (default 1 day). Young statistics are marked in the header instead of being listed as a warning. (#50, #41)
  • Long endpoint and job names are cut from the left, with the namespace dimmed and the full name on hover, so overview tables no longer scroll sideways. (#43, #49)
  • Queries tables show the call count next to its bar, and durations under 1 ms as <1ms instead of 0ms. The separate share column of endpoints and jobs is now the bar in the db time column. (#47, #48)

v0.1.1

Choose a tag to compare

@defkode defkode released this 02 Oct 12:25
  • Fix: pg_peek works with a database role that may not read server settings (e.g. dokku-review-pg, managed hosts) instead of crashing with PG::InsufficientPrivilege.
  • The pg_stat_statements reset button is disabled when the role may not reset, with the GRANT that would allow it. (#40)

v0.1.0

Choose a tag to compare

@defkode defkode released this 02 Oct 09:44

First release.