log_lock_waits is the cheapest lock-contention detector PostgreSQL ships, and through version 18 it is off by default. Turn it on. PostgreSQL 19 will do it for
Three parameters control what reaches your server log: a severity floor, whether to attach the triggering SQL, and how many fields each message prints.
PostgreSQL's log rotation has three parameters that only make sense together: one rotates at clock boundaries, one at file sizes, and one decides whether to…
All three of these do nothing unless logging_collector is on; they describe the files the collector writes. Where, what they’re called, and who can read them. T
PostgreSQL's logging collector is a small pipe-based daemon that prevents message loss and garbling—but turning it on requires a restart, which you'll want on…
log_lock_waits is the cheapest lock-contention detector PostgreSQL ships, and through version 18 it is off by default. Turn it on. PostgreSQL 19 will do it for
log_replication_commands is log_statement = all for walsenders, with the one difference that you should turn it on.
Aggregate query statistics hide the forest of cheap queries.
Control what bind parameters PostgreSQL logs alongside statements and errors.
Three parameters control what reaches your server log: a severity floor, whether to attach the triggering SQL, and how many fields each message prints.
`log_line_prefix` is where you attach session, transaction, and client context to every log line PostgreSQL emits.
PostgreSQL's log rotation has three parameters that only make sense together: one rotates at clock boundaries, one at file sizes, and one decides whether to…
All three of these do nothing unless logging_collector is on; they describe the files the collector writes. Where, what they’re called, and who can read them. T
PostgreSQL's logging collector is a small pipe-based daemon that prevents message loss and garbling—but turning it on requires a restart, which you'll want on…
PostgreSQL 18 adds granular connection logging.