Regular Expressions 101

Group 1(.+?)

.+?any character (except for line terminators), repeated at least once

Character Class[ ]?

?matches at most one character from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

Group 2((?<=[ ])$cost=([\d\.]+)[ ]rows=(\d+)$)?

?repeats the group contents below at most once:

Positive Lookbehind(?<=[ ])

Character Class[ ]

the literal (32₁₀ / 40₈ / 20₁₆)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

cost=the literal text cost= (case sensitive)

Group 3([\d\.]+)

Character Class[\d\.]+

+matches at least one character from the set below:

\da digit

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Character Class[ ]

the literal (32₁₀ / 40₈ / 20₁₆)

rows=the literal text rows= (case sensitive)

Group 4(\d+)

\d+a digit, repeated at least once

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Character Class[ ]

the literal (32₁₀ / 40₈ / 20₁₆)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

actualthe literal text actual (case sensitive)

Character Class[ ]

the literal (32₁₀ / 40₈ / 20₁₆)

time=the literal text time= (case sensitive)

Group 5([\d\.]+)

Character Class[\d\.]+

+matches at least one character from the set below:

\da digit

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Character Class[ ]

the literal (32₁₀ / 40₈ / 20₁₆)

rows=the literal text rows= (case sensitive)

Group 6(\d+)

\d+a digit, repeated at least once

Character Class[ ]

the literal (32₁₀ / 40₈ / 20₁₆)

loops=the literal text loops= (case sensitive)

Group 7(\d+)

\d+a digit, repeated at least once

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(.+?)[ ]?((?<=[ ])\(cost=([\d\.]+)[ ]rows=(\d+)\))?[ ]\(actual[ ]time=([\d\.]+)[ ]rows=(\d+)[ ]loops=(\d+)\)

New

Single-row index lookup on using <auto_distinct_key> (actor_id=actor.actor_id) (cost=901.66 rows=5478) (actual time=0.001..0.001 rows=0 loops=200)

Single-row index lookup on using <auto_distinct_key> (actor_id=actor.actor_id) (actual time=0.001..0.001 rows=0 loops=200)

Regular Expression

Extraction