log_line_prefix

A configuration parameter determining the format of the first part of each log line

log_line_prefix is a configuration parameter determining the format of the first part of each log line.

log_line_prefix was added in PostgreSQL 8.0.

Default value

The default value for log_line_prefix is:

Change history

Examples

Log output with log_line_prefix set to '%m [%p]  ' (the default in PostgreSQL 10 and later):

2020-12-11 10:17:18.405 CET [10070] LOG:  statement: SELECT error;
2020-12-11 10:17:18.406 CET [10070] ERROR:  column "error" does not exist at character 8
2020-12-11 10:17:18.406 CET [10070] STATEMENT:  SELECT error;

Categories

GUC configuration item, Logging