• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (beta1)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

Useful overviews

Useful links

log_line_prefix

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:

• PostgreSQL 10 and later: '%m [%p] '
• PostgreSQL 8.0 ~ 9.6: '' (empty string).

Change history

• PostgreSQL 14
  • %P parameter added to show the parallel group leader (commit b8fdee7d)
  • %Q parameter added to show the query ID if available, otherwise 0 (commit 4f0b0966)
• PostgreSQL 13
  • %b parameter added to show the backend type (commit 70a7b477)
• PostgreSQL 10
  • default changed from empty string to '%m [%p] ' (commit 7d3235ba)
• PostgreSQL 9.6
  • %n parameter added to show the Unix epoch (commit f828654e)
• PostgreSQL 9.4
  • printf-style padding specifications permitted (commit 4334639f)
• PostgreSQL 9.0
  • %e parameter added to show the current SQL state (commit f39df967)
• PostgreSQL 8.0
  • added (commit 2d3fe86b)

Examples

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;

References

Categories