From 617c2415a93bdb4c30716bb932ab5ae1aa6234e5 Mon Sep 17 00:00:00 2001 From: Ian Jackson Date: Fri, 18 Jul 2014 18:00:05 +0100 Subject: [PATCH] wip --- .gitignore | 2 ++ jobs.runes | 8 ++++++++ psql2gnuplot | 7 +++++++ 3 files changed, 17 insertions(+) create mode 100644 .gitignore create mode 100644 jobs.runes create mode 100755 psql2gnuplot diff --git a/.gitignore b/.gitignore new file mode 100644 index 0000000..00204f0 --- /dev/null +++ b/.gitignore @@ -0,0 +1,2 @@ +*~ +*.data diff --git a/jobs.runes b/jobs.runes new file mode 100644 index 0000000..fb591ea --- /dev/null +++ b/jobs.runes @@ -0,0 +1,8 @@ +# select count(*), flight, branch, started from jobs join flights using (flight) where branch='xen-unstable' and blessing='real' and started >=1374166076 group by flight, branch, started order by flight desc \g jobs.data + +set yrange [0:*] +set xtics 5000000 +set xdata time +set timefmt "%s" +set term x11 persist +plot 'jobs.gnuplot' using 4:1 title 'jobs in xen-unstable' diff --git a/psql2gnuplot b/psql2gnuplot new file mode 100755 index 0000000..f8e7150 --- /dev/null +++ b/psql2gnuplot @@ -0,0 +1,7 @@ +#!/usr/bin/perl -wp +use strict; +$_="" if $.==1; +$_="" unless m/[^-+ \t\n]/; +$_="" if m/^\(\d+ rows\)$/; +s/\|//g; +s/\S*[^0-9. \t\n]\S*/"$&"/g; -- 2.39.5