X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fpgbench_looper;a=blobdiff_plain;f=pgbench_looper.p;fp=pgbench_looper.p;h=f9bacaa290861ec634db5b4f8cbc0c74fabc0bd0;hp=0000000000000000000000000000000000000000;hb=0c3d1bf902ba8091341ab2736fa8a6ce48656b1b;hpb=cf47597c2e09855d66c86bbc234a9aa62f1177d0 diff --git a/pgbench_looper.p b/pgbench_looper.p new file mode 100644 index 0000000..f9bacaa --- /dev/null +++ b/pgbench_looper.p @@ -0,0 +1,23 @@ +# Gnuplot script file for plotting pgbench data in csv file pgbench_looper.sh +# Filename: pgbench_looper.p +# Usage: gnuplot -e "filename='test-20130407_16-26.csv'" pgbench_looper.p -persist +# gnuplot -e "filename='test-20130407_16-26.csv' outfilename='test-20130407_16-26.png'" pgbench_looper.p + +if (!exists("filename")) filename='pgbench_looper.csv' +if (exists("outfilename")) set terminal png truecolor giant; set output outfilename +set datafile separator "," +set logscale y +set mxtics 10 +set mytics 10 +set grid xtics mxtics ytics mytics +set style line 11 lc rgb '#808080' lt 1 +set border 3 back ls 11 +set tics nomirror +set style line 12 lc rgb '#808080' lt 0 lw 1 +set grid back ls 12 +set style line 1 lc rgb '#8b1a0e' pt 1 ps 1 lt 1 lw 2 # --- red +set style line 2 lc rgb '#5e9c36' pt 6 ps 1 lt 1 lw 2 # --- green +set style line 3 lc rgb '#003399' pt 1 ps 1 lt 1 lw 2 # --- blue +plot filename every ::2::97 using 5:7 smooth unique with lines title 'Read Only', \ +filename every ::98::193 using 5:7 smooth unique with lines title 'Read Write', \ +filename every ::194::298 using 5:7 smooth unique with lines title 'Custom'