regex101: Python Match Workspace

Pro

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Group ts(?P<ts>\d{4}-\d\d-\d\dT\d\d:\d\d:\d\dZ)

\d{4}a Unicode decimal digit, repeated exactly 4 times

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\da Unicode decimal digit

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\da Unicode decimal digit

Tthe literal T (84₁₀ / 124₈ / 54₁₆) (case sensitive)

\da Unicode decimal digit

:the literal : (58₁₀ / 72₈ / 3A₁₆)

\da Unicode decimal digit

:the literal : (58₁₀ / 72₈ / 3A₁₆)

\da Unicode decimal digit

Zthe literal Z (90₁₀ / 132₈ / 5A₁₆) (case sensitive)

Positive Lookahead(?=.*?\bdb=(?P<db>\S*))

.*?any Unicode character (except for line terminators), repeated any number of times

\ba Unicode word boundary

db=the literal text db= (case sensitive)

Group db(?P<db>\S*)

\S*any character that is not Unicode whitespace, repeated any number of times

Positive Lookahead(?=.*?\buser=(?P<user>\S*))

.*?any Unicode character (except for line terminators), repeated any number of times

\ba Unicode word boundary

user=the literal text user= (case sensitive)

Group user(?P<user>\S*)

\S*any character that is not Unicode whitespace, repeated any number of times

.*?any Unicode character (except for line terminators), repeated any number of times

LOG:the literal text LOG: (case sensitive)

\s+a Unicode whitespace character, repeated at least once

Group query(?P<query>.*?)

.*?any Unicode character (except for line terminators), repeated any number of times

;?optionally matches the literal ; (59₁₀ / 73₈ / 3B₁₆)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

'(?P<ts>\d{4}-\d\d-\d\dT\d\d:\d\d:\d\dZ)(?=.*?\bdb=(?P<db>\S*))(?=.*?\buser=(?P<user>\S*)).*?LOG:\s+(?P<query>.*?);?$

New

'2022-05-08T04:18:43Z UTC [ user=test db=dev pid=1073922359 userid=100 xid=2063 ]' LOG: alter table my_table alter column string type varchar(16);

'2022-05-08T04:18:43Z UTC [ user=test db=dev pid=1073922359 userid=100 xid=2063 ]' LOG: alter table my_table alter column string type varchar(16);