Community Patterns

Community Library Entry

0

Regular Expression
Created·2017-03-21 05:41
Flavor·PCRE (Legacy)

/
^(?<timestamp>[^ ]*)\.(?<time_microseconds>\d*)\+[^ ]+ (?<host>[^ ]*) postgres\[(?<pid>\d*)\]: \[(?<groupid>[^ ]\d*)-(?<lineid>[^ ]\d*)\](?<message>.*)$
/
gm
Open regex in editor

Description

Extracts information from PostgreSQL logs.

Submitted by Glenn Stewart