List:General Discussion« Previous MessageNext Message »
From:Brad Eacker Date:April 13 2004 2:06pm
Subject:Re: sql bench problems
View as plain text  
Yonah Russ writes:
>here is a sample output line:
>Time for alter_table_drop (91): 19 wallclock secs ( 0.02 usr  0.00 sys +  
0.00 cusr  0.00 csys =  0.02 CPU)
>here is the regexp:
>/^(estimated |)time (to|for) ([^\s:]*)\s*\((\d*)(:\d*)*\)[^:]*:\s*([\d.]+) 
.*secs \(\s*([^\s]*) usr\s*\+*\s*([^\s]*) sys.*=\s+([\d.]*)\s+cpu/i

     It appears that the source has been modified from the original regexp.
Primary changes are:
	time -> Time
	cpu -> CPU

You may want to run the output thru
	tr '[A-Z]' '[a-z]'
to change upper case to lower case to allow the regexp to work properly.

Brad Eacker (beacker@stripped)

sql bench problemsYonah Russ13 Apr
Re: sql bench problemsBrad Eacker13 Apr