Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

different parsing between two versions #820

Open
bagafoot opened this issue Mar 21, 2024 · 0 comments
Open

different parsing between two versions #820

bagafoot opened this issue Mar 21, 2024 · 0 comments

Comments

@bagafoot
Copy link

bagafoot commented Mar 21, 2024

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?

@bagafoot bagafoot changed the title differnt parsing between two versions different parsing between two versions Mar 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant