# Sample Reports

> Open complete, error-only, and incremental pgBadger reports

---

LLMS index: [llms.txt](/llms.txt)

---

The example content was generated by pgBadger 11.8 in May 2022. Report navigation, charts, styles, and scripts are available offline.

| Example | What it demonstrates | Local copy |
|---|---|---|
| Complete report | PostgreSQL activity together with PgBouncer statistics | [Open the complete report](/third_party/pgbadger/examples/sample.html) |
| Incremental report | Calendar index, weekly aggregation, and daily pages | [Open the incremental index](/third_party/pgbadger/examples/report/index.html) |
| Errors and events | A report restricted to errors and operational events | [Open the error report](/third_party/pgbadger/examples/errors.html) |

## Complete report {#complete-report}

The complete report is a self-contained HTML document. Use its top navigation to inspect global statistics, queries, sessions, connections, temporary files, checkpoints, autovacuum activity, locks, and PgBouncer-specific charts.

The data is a demonstration fixture, not a current benchmark. Values, PostgreSQL versions, and the embedded pgBadger UI reflect the report generation date.

## Incremental hierarchy {#incremental-hierarchy}

The incremental example preserves the full link structure:

```text
report/
├── index.html
├── 2012/
│   ├── week-49/index.html
│   ├── week-50/index.html
│   └── 12/06 … 12/index.html
└── 11/
    ├── pgbadger.min.css
    ├── pgbadger.min.js
    └── bundled chart and UI assets
```

The top index links to two weekly reports and seven daily reports. Moving only `index.html` breaks its relative links; keep the complete directory tree together.

## Security and privacy {#security-and-privacy}

Real reports may expose SQL text, bind values, database and user names, application names, client addresses, error details, and workload patterns. Before publishing a report:

- use `--anonymize` when literals are not needed;
- apply include/exclude filters before report generation;
- inspect the final HTML or exported data, not only the command line;
- protect the report location with the same care as operational logs.

---

Backlinks:

- [Attribution](/attribution/)
- [pgBadger](/docs/pgbadger/)