Session-level read-only mode
Collector docs
Read-only PostgreSQL audit collector
The collector is designed for small teams that need performance evidence without granting a third-party tool write access.
Local JSON export
No automatic SQL changes
What it collects
The collector reads relation size, table scan counts, index usage, dead-row signals, pg_stat_statements query statistics, and selected PostgreSQL settings.
What it does not do
It does not create indexes, run VACUUM, change settings, install extensions, or execute optimization SQL on your database.
Recommended command
Run: npx postgresaudit collect --url "$DATABASE_URL" --out audit.json. Use a restricted user and review the JSON before upload if your company requires it.