darold / pgbadger

A fast PostgreSQL Log Analyzer
http://pgbadger.darold.net/
PostgreSQL License
3.45k stars 348 forks source link

different parsing between two versions #820

Open bagafoot opened 3 months ago

bagafoot commented 3 months ago

Hello, I am trying to export single database report and I have two versions of pgbadger image image

export command: /usr/local/bin/pgbadger --prefix "t=%m p=%p a=%a h=%h db=%d u=%u x=%x " -d test_db -v -a 1 -j 16 -s 2 -T "yzva58_20" -O /var/lib/pgsql --exclude-query="^(COPY|refresh materialized VIEW|VACUUM)" -o tst58_20.html /pg01/mounts/pg12/pg_log/log/yzva_pg12db01-2024.03.20.log.gz

never v. command: /usr/bin/pgbadger --prefix "t=%m p=%p a=%a h=%h db=%d u=%u x=%x " -d test_db -v -a 1 -j 16 -s 2 -T "yzva58_20" -O /var/lib/pgsql --exclude-query="^(COPY|refresh materialized VIEW|VACUUM)" -o tst58_20.html /pg01/mounts/pg12/pg_log/log/yzva_pg12db01-2024.03.20.log.gz

older version parsing logs but it doesnt work properly in html, some sections doesn't work, sections on the left is ok but after vacuum to the events it doesnt work. image image

never version evet cant parsing that contain auto_explain log

DEBUG: Unknown stderr log line format:                SubPlan 5
DEBUG: Unknown stderr log line format:                  ->  Nested Loop  (cost=0.83..10.88 rows=1 width=22) (actual time=0.008..0.008 rows=1 loops=702598)
...

why this version differ that much, and how to solve html issue?