Let us try to generate a very simple pgbadger report
1. Run a simple query:
\c pgbenchdb
select pg_sleep(2);
2. launch the below command:
pgbager $PGDATA/log/postgresql-Sun.log
3. Download the out.html generated in the same directory from where the previous command was run.
4. Open the Report and navigate the report:
Flow diagram:
>> postgreslog --- pgbadger --> output in html format (JSON)
You can get an incremental updates as well for the report.
YouTube Video link:
