pgbadger
pgbadger copied to clipboard
darold
A fast PostgreSQL Log Analyzer
The explain link create a "get" request that looks like: ``` http://explain.depesz.com/?is_public=0&is_anon=0&plan=%09Aggregate%20%20%28cost%3D1114961.18..1114961.19%20rows%3D1%20width%3D8%29%0A%09%20%20Output%3A%20count%28DISTINCT ``` and could be ... very very big :(=) This errs with various errors (depending on browser and...
 
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...
Hi Darold Would be amazing if we can get a friendly report or a tab from `pgAudit` entries, what do you think? All your tools are amazing, thank you so...
Currently I have multiple "small" 100MB sized files sent to my pgBadger "processor" where the files are processed with `-I -J ` every hour as they arived. This is generating...
Hello, I have this recurrent error : `Corrupted storable file (binary v2.11) at /usr/lib/perl5/core_perl/Storable.pm line 443, at /usr/bin/pgbadger line 14164.` debugging locally, I am able to identify this problematic file...
In Most Frequent Queries, if Min duration is eq to 0, then number in Avg is zero too (and it seems it's not correct): 
This adds a Dockerfile adapted from https://github.com/matsuu/docker-pgbadger that allows the latest pgbadger source codes to be built into a docker image. Also included a readme that has brief instructions for...
If logs contains UTF-8 characters JSON output embeds "badly converted" characters : ~~~ echo "2021-06-08 13:51:04.966 UTC [22436-2] postgres@postgres LOG: duration: 5025.921 ms statement: select ' € € ', pg_sleep(5);"|perl...
Dear Gilles, I have been running your awesome pgBadger script for over a month now and I'd like to build a monthly report of the month of August. This is...
