pgbadger VS pgaudit_analyze

pgbadger

• Site down due hosted on digitalocean
  1 project | /r/django | 30 Jun 2023

  It might also help to use pgbadger or something similar to process your postgres logs and see whether some event is aligned with your outages.

• SQL: 2023 Has Been Released
  1 project | news.ycombinator.com | 1 Jun 2023

  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 go 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.

  There wasn't a solution in place at the time I left, so they're probably still having the issue... ;)

• Moving from Oracle to Postgres, what should I know?
  5 projects | /r/PostgreSQL | 11 Jul 2022
• What are the top 3 most useful things that you have hosted over the years?
  11 projects | /r/selfhosted | 24 Jan 2022

  First of all I used a profiler (pgbadger and netdata) to figure out where the lags were coming from. I then tried the usual stuff (increasing shared_buffers, max_wal_size, min_wal_size from their ultra low defaults), but the biggest performance gain came from moving the database from eMMC to a mechanical hard drive :-D

• Best way to find queries that might benefit from indexes.
  1 project | /r/PostgreSQL | 22 Apr 2021

  Look into PgBadger (a log parser/analyser): https://github.com/darold/pgbadger

pgaudit_analyze

We haven't tracked posts mentioning pgaudit_analyze yet.
Tracking mentions began in Dec 2020.