What does HackerNews think of pgbadger?

A fast PostgreSQL Log Analyzer

Language: Perl

#32 in PostgreSQL
#25 in SQL
SQL:2023 has been released | Jun 2023
Expand Context ↕
Interestingly, when a place does get to the point where the single instance has capacity issues (after upgrading to EPYC and lots of flash drives) then other non-obvious stuff shows up too.

For example, at one place just over a year ago they were well into this territory. One of weird problems for them was with pgBadger's memory usage (https://github.com/darold/pgbadger). That's written in perl, which doesn't seem to do garbage collection well. So even on a reporting node with a few hundred GB's of ram, it could take more than 24 hours to do a "monthly" reporting run to analyse PG usage for the time period.

There wasn't a solution in place at the time I left, so they're probably still having the issue... ;)
Tips for a healthier Postgres database (2021) | Feb 2023
Expand Context ↕
Before we jumped on all kinds of SaaS offerings we used pgbadger.

https://github.com/darold/pgbadger
Building a PostgreSQL load tester | Apr 2019
> When faced with a technical problem it’s often better to use an existing tool than jump into writing one yourself. Having benchmarked Postgres clusters before, I was already familiar with a tool called pgreplay that I thought could do the job.

There is also pg_badger which can run parallel jobs:

https://github.com/darold/pgbadger

pg_badger is also used by nancy, an benchmark experiment driver, so you can replay your logs, then change something, like add an index, and replay them again and nancy will show you to differential performance:

https://gitlab.com/postgres-ai-team/nancy

PostgreSQL's Explain Analyze Made Readable | Feb 2019
Expand Context ↕
Probably the closest thing to what you are asking for is pgBadger [0]. If there is a better tool I'd love to hear about it.

[0] https://github.com/darold/pgbadger
PgFormatter: A PostgreSQL SQL syntax beautifier | Oct 2018
Expand Context ↕
The most productive language of Gilles, well-known in the Postgres community by the way, is perl, and he can do completely crazy things with it. See for example pgbadger (https://github.com/darold/pgbadger), one of his other projects.