head	1.2;
access;
symbols;
locks; strict;
comment	@# @;


1.2
date	91.10.08.22.16.13;	author mao;	state Exp;
branches;
next	1.1;

1.1
date	91.06.13.13.46.58;	author kemnitz;	state Exp;
branches;
next	;


desc
@Generate "per query" results from the Wisconsin output file
@


1.2
log
@fix up awk expression to work with nawk
@
text
@#!/bin/sh

egrep 'x = "|elapse' > /tmp/foo$$

awk 'BEGIN { x = 0; y = 0; z = 0; a = 0; } \
     /.*elapse.*/ {x = $2 + x; y = $4 + y; z = $6 + z;} \
     /.*x = ".*/ { \
	 printf "query %2d: %7.3f real %7.3f user %7.3f sys\n", a, x, y, z; \
	 x = 0; y = 0; z = 0; a = a + 1; } \
     END {printf("query %2d: %7.3f real %7.3f user %7.3f sys\n", a, x, y, z);}' \
	 < /tmp/foo$$
	 
@


1.1
log
@Initial revision
@
text
@d5 2
a6 1
awk '/.*elapse.*/ {x = $2 + x} {y = $4 + y} {z = $6 + z} \
d8 3
a10 3
	 printf "query %2d: %7.3f real %7.3f user %7.3f sys\n", a, x, y, z;
	 x = 0; y = 0; z = 0; a = a + 1} 
	 END {printf "query %2d: %7.3f real %7.3f user %7.3f sys\n", a, x, y, z}' \
@
