This is a printf-style string that is output at the beginning of each log line.
% characters begin escape sequences that are replaced with status information as outlined below. Unrecognized escapes are ignored. Other characters are copied straight to the log line. Some escapes are only recognized by session processes, and will be treated as empty by background processes such as the main server process. Status information may be aligned either left or right by specifying a numeric literal after the % and before the option. A negative value will cause the status information to be padded on the right with spaces to give it a minimum width, whereas a positive value will pad on the left. Padding can be useful to aid human readability in log files.
This parameter can only be set in the postgresql.conf file or on the server command line. The default is
'%m [%p] ' which logs a time stamp and the process ID.
%rRemote host name or IP address, and remote portyes
%hRemote host name or IP addressyes
%tTime stamp without millisecondsno
%mTime stamp with millisecondsno
%nTime stamp with milliseconds (as a Unix epoch)no
%iCommand tag: type of session's current commandyes
%eSQLSTATE error codeno
%cSession ID: see belowno
%lNumber of the log line for each session or process, starting at 1no
%sProcess start time stampno
%vVirtual transaction ID (backendID/localXID)no
%xTransaction ID (0 if none is assigned)no
%qProduces no output, but tells non-session processes to stop at this point in the string; ignored by session processesno
The backend type corresponds to the column backend_type in the view , but additional types can appear in the log that don't show in that view.
%c escape prints a quasi-unique session identifier, consisting of two 4-byte hexadecimal numbers (without leading zeros) separated by a dot. The numbers are the process start time and the process ID, so
%c can also be used as a space saving way of printing those items. For example, to generate the session identifier from
pg_stat_activity, use this query:SELECT to_hex(trunc(EXTRACT(EPOCH FROM backend_start))::integer) || '.' || to_hex(pid)FROM pg_stat_activity;
If you set a nonempty value for
log_line_prefix, you should usually make its last character be a space, to provide visual separation from the rest of the log line. A punctuation character can be used too.
Syslog produces its own time stamp and process ID information, so you probably do not want to include those escapes if you are logging to syslog.
%q escape is useful when including information that is only available in session (backend) context like user or database name. For example:log_line_prefix = '%m [%p] %q%u@%d/%a '
- Azure DB for PostgreSQL - changes to log_line_prefix parameter not implemented
- Postgres: How to convert SQL result into column name &amp; value
- pgBadger - generated report is empty but postgres log has events
- What is empty statement record in PostgreSQL log?
- What is the correct pattern for pgbadger to match RDS logs?
- Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
- Re: Proposal: Save user's original authenticated identity for logging
- Re: A modest proposal: let's add PID to assertion failure messages
- Re: PG 14 release notes, first draft
- Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?