Sessions info is incorrect

darold / pgbadger

A fast PostgreSQL Log Analyzer

http://pgbadger.darold.net/

PostgreSQL License

3.49k stars 349 forks source link

Sessions info is incorrect #733

Closed vitalca closed 1 year ago

vitalca commented 2 years ago

Hello,

pgBadger 11.8

Yesterday I updated autovacuum_vacuum_scale_factor and autovacuum_vacuum_threshold for a few large tables. As a result, vacuums began to behave more aggressively and efficiently. At the same time the "Simultaneous sessions" report became incorrect:

Next logfile (daily rotation):

Besides, there is another issue with Sessions, not sure if this is related.

At the same time the Chart tab looks much better:

darold commented 2 years ago

Commit c3ad6ab fixes the second issue, I'm working on the first one.

vitalca commented 2 years ago

Great, thanks for the quick response, Gilles!

darold commented 1 year ago

Commit 7b8b28a might fix this issue.