Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package pgbadger for openSUSE:Factory checked in at 2025-03-18 17:41:49 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/pgbadger (Old) and /work/SRC/openSUSE:Factory/.pgbadger.new.19136 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "pgbadger" Tue Mar 18 17:41:49 2025 rev:2 rq:1253952 version:13.1 Changes: -------- --- /work/SRC/openSUSE:Factory/pgbadger/pgbadger.changes 2024-03-06 23:04:29.737234777 +0100 +++ /work/SRC/openSUSE:Factory/.pgbadger.new.19136/pgbadger.changes 2025-03-18 17:43:51.039942463 +0100 @@ -1,0 +2,90 @@ +Mon Mar 17 22:20:37 UTC 2025 - Marcus Rueckert <mrueck...@suse.de> + +- update to 13.1 + This is a maintenance release of pgBadger that fixes issues + reported by users since last release and adds some new features: + + - Add new report about vacuum throughput with a graph about + vacuum per table that consume the more CPU. The table output + reports I/O timing read and write per table as well as the CPU + time elapsed on the table. Thanks to Ales Zeleny for the + feature request. This patch also adds frozen pages and tuples + to the Vacuums per Table report. + - Add --no-fork option for debugging purpose to not fork + processes at all. Thanks to Ales Zeleny for the feature + request. + - Add millisecond to the raw csv output. Thanks to Henrietta + Dombrovskaya for the feature request. + - Add log filename to sample reports when multiple file are + processed. Thanks to Adrien Nayrat for the feature request. + + Here is the complete list of changes and acknowledgments: + + - Fix bind parameters parsing. Thanks to Thomas Kotzian for the + patch + - Apply query filter on multi-lines queries. Thanks to Benjamin + Jacobs for the patch + - Update test result for log filename storage changes + - Fix ERROR vs LOG message level in json output. Thanks to + Philippe Viegas for the report. + - Remove import of tmpdir not exported method from File::Temp. + Thanks to kmoradha for the report. + +------------------------------------------------------------------- +Sun Dec 8 08:36:50 UTC 2024 - Marcus Rueckert <mrueck...@suse.de> + +- update to 13.0 + This is a major release of pgBadger that fixes issues reported by + users since last release and adds some new features: + + - Add two new option to be able to redefined inbound of query and + session histogram. Thanks to JosefMachytkaNetApp for the + feature request. + --histogram-query VAL : use custom inbound for query + times histogram. + Default inbound in milliseconds: + 0,1,5,10,25,50,100,500,1000,10000 + --histogram-session VAL : use custom inbound for session + times histogram. + Default inbound in milliseconds: + 0,500,1000,30000,60000,600000, + 1800000,3600000,28800000 + - Add support of auto_explain plan for csv and json log formats. + Thanks to zxwsbg and to Alexander Rumyantsev for the report. + - Add three LOG message that was not reported as events: + unexpected EOF, incomplete startup packet and detected deadlock + while waiting for. Thanks to dottle for the report. + + Backward compatibility issues: + - Change the way LOG level events reported in the Events reports + are stored. Some of them was still reported and counted as + errors instead as LOG level entries. The fix is to stored and + report them as EVENTLOG to differentiate them from queries. + This change introduce a backward compatibility break when + pgbadger is used in incremental mode. You will just have the + double behavior during the week of the upgrade. Thanks to Matti + Linnanvuori for the report. + + Bug fixes: + - Fix non reported queries generating the most cancellation due + to statement_timeout. + - Update regression tests + - Fix formatting of explain plan when extracted from csv log + format. + - Fix jsonlog missing autovacuum data reports: Average Autovacuum + Duration, Tuples removed per table and vacuums by hour in + autovacuum activity report. Thanks to Ales Zeleny for the + patch. + - Fix orphan line not associated to the time consuming bind + queries. Thanks to Henrietta Dombrovskaya for the report. Fix + use of uninitialized value in pattern match. Thanks to Junior + Dias for the patch. + - Apply option --csv-separator to raw export to CSV. Default + separator is semicolon (;). Thanks to Henrietta Dombrovskaya + for the feature request. + - Raw csv output: do not add double quote to parameters and + application name if they are empty. + - Add double quotes when queries have a semi colon in raw csv + output. Thanks to Henrietta Dombrovskaya for the report. + +------------------------------------------------------------------- Old: ---- pgbadger-12.4.tar.gz New: ---- pgbadger-13.1.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ pgbadger.spec ++++++ --- /var/tmp/diff_new_pack.LFxMap/_old 2025-03-18 17:43:51.599965961 +0100 +++ /var/tmp/diff_new_pack.LFxMap/_new 2025-03-18 17:43:51.603966128 +0100 @@ -1,6 +1,7 @@ # # spec file for package pgbadger # +# Copyright (c) 2025 SUSE LLC # Copyright (c) 2013-2015 Lars Vogdt # # All modifications and additions to the file contributed by third parties @@ -12,9 +13,10 @@ # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. -# Please submit bugfixes or comments via http://bugs.opensuse.org/ +# Please submit bugfixes or comments via https://bugs.opensuse.org/ # + %if 0%{?is_opensuse} %bcond_without jsonxs %else @@ -28,11 +30,11 @@ %endif Name: pgbadger -Version: 12.4 +Version: 13.1 Release: 0 License: MIT Summary: A fast PostgreSQL log analyzer -Url: https://pgbadger.darold.net/ +URL: https://pgbadger.darold.net/ Group: System/Monitoring Source0: https://github.com/darold/%{name}/archive/refs/tags/v%{version}.tar.gz#/%{name}-%{version}.tar.gz Source1: %{name}-cron @@ -41,32 +43,32 @@ Source4: README.SUSE BuildRequires: cron BuildRequires: perl +BuildRequires: perl(Benchmark) +BuildRequires: perl(File::Basename) BuildRequires: perl(Getopt::Long) BuildRequires: perl(IO::File) BuildRequires: perl(Pod::Markdown) -BuildRequires: perl(Benchmark) -BuildRequires: perl(File::Basename) -BuildRequires: perl(Time::Local) BuildRequires: perl(Text::CSV_XS) +BuildRequires: perl(Time::Local) %if %{with jsonxs} BuildRequires: perl(JSON::XS) %endif BuildRequires: sed -Requires: perl(Getopt::Long) -Requires: perl(IO::File) +Requires: perl = %{perl_version} Requires: perl(Benchmark) +Requires: perl(Encode) Requires: perl(File::Basename) -Requires: perl(Storable) Requires: perl(File::Spec) Requires: perl(File::Temp) +Requires: perl(FileHandle) +Requires: perl(Getopt::Long) +Requires: perl(IO::File) Requires: perl(IO::Handle) Requires: perl(IO::Pipe) -Requires: perl(FileHandle) Requires: perl(Socket) -Requires: perl(Encode) +Requires: perl(Storable) Requires: perl(Text::Wrap) Requires: perl(Time::Local) -Requires: perl = %{perl_version} %{?systemd_ordering} %if %{with cron} ++++++ pgbadger-12.4.tar.gz -> pgbadger-13.1.tar.gz ++++++ ++++ 2094 lines of diff (skipped)