depesz

PostgreSQL 19 introduces a new capability allowing `log_min_messages` to be configured per process type rather than as a single global setting. The syntax uses a comma-separated list of `type:level` pairs alongside a default level, making it fully backwards-compatible. This enables DBAs and developers to target verbose debug logging at specific backend processes—such as autovacuum, archiver, walreceiver, or bgwriter—without flooding logs from all processes. A practical example shows setting `log_min_messages = 'warning,autovacuum:debug5'` to isolate autovacuum debug output. The feature covers 15 distinct process types including postmaster, checkpointer, walsender, and ioworker (new in PG18). While primarily useful for PostgreSQL developers diagnosing internal behavior, it can also help DBAs investigate issues like unexpected autovacuum skips.

messages to be set per process type – select * from depesz;