pgbadger session - 3: A first look of pgbadger report

 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: