Error Log Record Format
All parts of a log record are optional except for the message.
A log record has the following format:
[#][timestamp][PIDpid:][TIDtid:][SIDsid:][TXIDtxid:][QIDqid:][level:][facility:][file:line:]message
where:
#
The # sign prints for non-error level messages, per output.
timestamp
Timestamp (with time zone) of the error message, which can be in one of two formats: ISO and milliseconds from epoch.
pid
Logging process ID
tid
Thread ID
sid
x100 session ID
txid
Transaction ID
qid
Query ID (within session)
level:
The level of information logged. ERROR and WARN level messages are always logged.
facility:
Facility name
file:line
The source file and line that caused the message to be issued
message
The message text
Last modified date: 01/27/2026