Files
fail/tools/analysis/data-aggregator/variant-durations.sh
Horst Schirmeier 191219ad06 data-aggregator: variant-durations.sh w/o filter
Change-Id: I7a3164635fc2fbd65d99fc8bba66e956d505a515
2018-05-09 15:25:45 +02:00

17 lines
352 B
Bash
Executable File

#!/bin/bash
source $(dirname $0)/fail-analysis-common.inc.sh
$MYSQL << EOT
SET sql_mode = 'NO_UNSIGNED_SUBTRACTION';
SELECT v.benchmark, v.variant,
MAX(t.time2)-MIN(t.time1)+1 AS duration,
MAX(t.instr2)-MIN(t.instr1)+1 AS dyn_instr
FROM trace t
JOIN variant v
ON t.variant_id = v.id
WHERE $FILTER
GROUP BY v.id
ORDER BY v.benchmark, v.variant
EOT