log_statement
No restart — reload (superuser)enum: none / ddl / mod / all
Logs statements by category — none, DDL only, data-modifying, or all.
What it does
log_statement records statements regardless of how long they take, filtered by type: 'ddl' logs schema changes, 'mod' adds data-modifying statements, 'all' logs everything. It's separate from the duration-based slow-query log.
How to tune it
'ddl' is a cheap, valuable audit trail of schema changes in production. 'all' is for debugging or strict auditing only — it's high-volume. For finding slow queries, use log_min_duration_statement instead.