jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: converting the .jtl to a summary report in non-gui mode
Date Thu, 30 Jul 2009 16:50:12 GMT
On 30/07/2009, Kenneth Cox <kenstir@gmail.com> wrote:
> I wrote a short script to do this which takes a CSV format JTL file and
> summarizes it in a similar way to the (slow) aggregate report listener.  It
> uses a local postgres instance to import and summarize the CSV, and it runs
> very fast even on huge JTL files.  If this fits your needs feel free to use
> and share.  It's short; I'll paste it below.  If anybody uses this script
> and enhances it to print 90th percentile, please share again.

Or add it to the JMeter Wiki ...

[Much easier to find later]

Thanks!
>  Regards,
>  Ken
>
>
>  On Wed, 29 Jul 2009 05:40:59 -0400, Jantien Sessink <jantiens@gx.nl> wrote:
>
> > The problem is that after running the tests we get a lot of .jtl files
> that have to be opened in the Summary Report Listener of the JMeter GUI one
> by one, then saved to .csv and then imported in MS Excel for further
> analyses. This is very time consuming and we would like to automated that
> step. Is it possible to convert the .jtl output to a summary report in .csv
> format without using the GUI?
> >
>
> ---------------------------jtlsummary.sh------------------------------------
>  #!/bin/sh -
>  # summarize results in one or more .jtl (csv) files
>  #
>  # by kenstir 2009-07-01
>
>  # could be an option
>  dbname=$LOGNAME
>
>  # build sql here
>  tmpfile=/tmp/jtlsummary.$$.sql
>
> > $tmpfile
> >
>
>  set -e
>
>  cat >>$tmpfile <<EOF
>     create temp table results (timeStamp bigint,elapsed int,label
> text,responseCode text,responseMessage text,threadName text,dataType
> text,success boolean,bytes int,Latency int);
>  EOF
>
>  for csvfile in "$@"; do
>     case "$csvfile" in
>     /*) ;;
>     *)  csvfile="$PWD/$csvfile";;
>     esac
>  cat >>$tmpfile <<EOF
>         copy results from '$csvfile' csv header;
>  EOF
>  done
>
>  cat >>$tmpfile <<EOF
>     --analyze results;
>     create temp table agg as
>     select label
>            ,count(*)
>            ,avg(elapsed)
>            ,min(elapsed)
>            ,max(elapsed)
>       from results
>       group by label
>       order by label;
>     copy agg to stdout csv header;
>  EOF
>
>  psql -q -f $tmpfile
>  rm $tmpfile
> -------------------------------------end---------------------------------------------
>
> ---------------------------------------------------------------------
>  To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
>  For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message