# pgaudit/pgaudit

PostgreSQL Audit Extension

Repository: https://github.com/pgaudit/pgaudit
Canonical: https://ross.abutalabs.com/products/pgaudit
Homepage: http://pgaudit.org/
Language: C
License: NOASSERTION
License Family: other
Topics: pgaudit, extension, postgresql, postgresql-extension, audit, audit-log, database, auditor
Last push: 2026-07-30T13:08:02+00:00

## Health v2 (maintenance only)
Score: 80/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 95, release rhythm 49, longevity 100
- inputs: {"age_days": 4082, "days_push": 34, "days_rel": 343, "gap_med": 4.5, "n_releases_24m": 7}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1695, forks 195 (observed 2026-08-28T04:05:23.774750+00:00)

## What it is
pgAudit is a PostgreSQL extension written in C that provides detailed session and object audit logging through the standard PostgreSQL logging facility. It produces structured audit trails suitable for government, financial, and ISO certification compliance requirements.

## Use cases
- produce audit logs for compliance with government, financial, or ISO certifications
- log all statements that touched a specific table without parsing SQL
- capture DDL statements executed inside DO blocks and functions
- track which user ran which statement against the database
- generate detailed audit trails for database forensics
- log object-level access to sensitive tables

## When to choose
- you need detailed, searchable audit logs of PostgreSQL activity for auditors
- standard log_statement=all output is insufficient for compliance requirements
- you need to identify all statements affecting a particular relation
- you must demonstrate object-level access logging for certification

## When to avoid
- you only need basic monitoring or debugging of statements
- you cannot tolerate the additional logging volume and performance overhead
- you need audit logging for databases other than PostgreSQL

## Facets
- artifact type: plugin
- maturity: stable
- function: logging, security, database
- domain: databases, security, legal
- platform: windows, self-hosted
- tags: postgresql-extension, audit-logging, audit-trail, compliance, c, linux, macos

## Member repositories
- pgaudit/pgaudit (main) score 80

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:23.774750+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:37:56.853908+00:00, confidence not recorded.
  - readme: https://github.com/pgaudit/pgaudit (fetched 2026-08-28T04:05:23.774750+00:00, sha ca61681554f8)
  - homepage: http://pgaudit.org/ (fetched 2026-08-29T11:12:52.019654+00:00, sha e18a7a067e2f)
- Data as of 2026-08-30T08:39:29.467469+00:00.