What pgAudit Actually Logs pgAudit is a PostgreSQL extension that captures query-level...
What pgAudit Actually Logs
pgAudit is a PostgreSQL extension that captures query-level events at the database session layer. A typical entry looks like this:
2026-03-14 11:22:08 UTC [8841]: [4-1]
user=app_user,db=production,app=psql
AUDIT: SESSION,1,1,READ,SELECT,TABLE,users,
You build the feature. You test it. It works. Three months later: data is missing, a transaction...
Most operational infrastructure starts this way: a requirement appears before the architecture...
Prisma query logs help you catch patterns, but if the problem lives inside PostgreSQL, the ORM won't show it to you. Here I break…
Most developers I talk to connect Cursor or Claude directly to their databases using a full admin...
Introducing query tagging improvements in Postgres Query Insights
PostgreSQL WAL Bloat: Why Automatic Management Is Often Insufficient? While managing a...
