vladpurga/postgresql-log-line-prefix.md

Created September 6, 2019 05:51

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vladpurga/670f62d63e79d92809d3ca5add6a7c35.js"></script>
Save vladpurga/670f62d63e79d92809d3ca5add6a7c35 to your computer and use it in GitHub Desktop.

Download ZIP

[postgresql log_line_prefix] #postgresql

Raw

postgresql-log-line-prefix.md

log_line_prefix = '%m (%p:%h:%d:%u:%a:%v:%x) '

2019-08-16 05:08:57.939 GMT (62842:host:database:user:[application]:16/36976788:3643551317) LOG: process 62842 still waiting for ExclusiveLock on tuple (113892,1) of relation 14028231 of database 12345 after 1000.098 ms

%p = 62842
%v = 16/36976788
%x = 3643551317

# special values:
#   %p = process ID
#   %v = virtual transaction ID
#   %x = transaction ID (0 if none)