Processing TestRunController#regression_report (for 129.34.20.19 at 2009-01-15 09:29:39) [GET]
  Parameters: {"host_name"=>"jalapeno.anu.edu.au", "action"=>"regression_report", "controller"=>"results/test_run", "test_run_variant"=>"sanity", "test_run_id"=>"7257"}
SystemSetting Load (0.000939)  SELECT * FROM system_settings WHERE (system_settings."name" = 'environment') LIMIT 1
Tdm::Host Load (0.001022)  SELECT * FROM hosts WHERE (hosts."name" = 'jalapeno.anu.edu.au') LIMIT 1
Tdm::TestRun Load (0.001239)  SELECT * FROM test_runs WHERE (test_runs.host_id = 13) AND (test_runs."id" = '7257' AND test_runs."variant" = 'sanity') LIMIT 1
Tdm::TestRun Load (0.002961)  SELECT * FROM test_runs WHERE (host_id = 13 AND start_time <= '2009-01-14 11:00:35.000000' AND variant = 'sanity') ORDER BY start_time DESC LIMIT 10
SQL (0.696266)  SELECT * FROM (SELECT
 build_configurations.name AS build_configuration_name,
 test_configurations.name AS test_configuration_name,
 groups.name AS group_name,
 test_cases.name AS test_case_name,
 test_case_executions.name AS test_case_execution_name,
 count(case when build_configurations.test_run_id = 7257 then 1 else NULL end) AS current_run,
 count(case when build_configurations.test_run_id = 7240 then 1 else NULL end) AS in_last_run,
 count(*) AS total_runs,
 count(case when build_configurations.test_run_id = 7257 AND test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS current_success,
 count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS total_successes,
 max(case when build_configurations.test_run_id = 7257 then test_cases.id else NULL end) AS test_case_id,
 max(case when build_configurations.test_run_id = 7257 then test_case_executions.result else NULL end) AS test_case_execution
FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
WHERE
 build_configurations.test_run_id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
GROUP BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name
) f
WHERE test_case_id IS NOT NULL AND current_success = 1 AND total_successes = 1
ORDER BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name

SQL (0.675262)  SELECT * FROM (SELECT
 build_configurations.name AS build_configuration_name,
 test_configurations.name AS test_configuration_name,
 groups.name AS group_name,
 test_cases.name AS test_case_name,
 test_case_executions.name AS test_case_execution_name,
 count(case when build_configurations.test_run_id = 7257 then 1 else NULL end) AS current_run,
 count(case when build_configurations.test_run_id = 7240 then 1 else NULL end) AS in_last_run,
 count(*) AS total_runs,
 count(case when build_configurations.test_run_id = 7257 AND test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS current_success,
 count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS total_successes,
 max(case when build_configurations.test_run_id = 7257 then test_cases.id else NULL end) AS test_case_id,
 max(case when build_configurations.test_run_id = 7257 then test_case_executions.result else NULL end) AS test_case_execution
FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
WHERE
 build_configurations.test_run_id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
GROUP BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name
) f
WHERE test_case_id IS NOT NULL AND current_success = 0 AND total_successes = 9
ORDER BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name

SQL (0.650266)  SELECT * FROM (SELECT
 build_configurations.name AS build_configuration_name,
 test_configurations.name AS test_configuration_name,
 groups.name AS group_name,
 test_cases.name AS test_case_name,
 test_case_executions.name AS test_case_execution_name,
 count(case when build_configurations.test_run_id = 7257 then 1 else NULL end) AS current_run,
 count(case when build_configurations.test_run_id = 7240 then 1 else NULL end) AS in_last_run,
 count(*) AS total_runs,
 count(case when build_configurations.test_run_id = 7257 AND test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS current_success,
 count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS total_successes,
 max(case when build_configurations.test_run_id = 7257 then test_cases.id else NULL end) AS test_case_id,
 max(case when build_configurations.test_run_id = 7257 then test_case_executions.result else NULL end) AS test_case_execution
FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
WHERE
 build_configurations.test_run_id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
GROUP BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name
) f
WHERE
 test_case_id IS NOT NULL AND
 (
 (current_success != 1 OR total_successes != 1) AND
 (current_success != 0 OR total_successes != 9) AND
 (total_successes != 0)
 ) AND total_successes != total_runs
ORDER BY build_configuration_name, test_configuration_name, group_name, test_case_name

SQL (0.650982)  SELECT * FROM (SELECT
 build_configurations.name AS build_configuration_name,
 test_configurations.name AS test_configuration_name,
 groups.name AS group_name,
 test_cases.name AS test_case_name,
 test_case_executions.name AS test_case_execution_name,
 count(case when build_configurations.test_run_id = 7257 then 1 else NULL end) AS current_run,
 count(case when build_configurations.test_run_id = 7240 then 1 else NULL end) AS in_last_run,
 count(*) AS total_runs,
 count(case when build_configurations.test_run_id = 7257 AND test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS current_success,
 count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS total_successes,
 max(case when build_configurations.test_run_id = 7257 then test_cases.id else NULL end) AS test_case_id,
 max(case when build_configurations.test_run_id = 7257 then test_case_executions.result else NULL end) AS test_case_execution
FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
WHERE
 build_configurations.test_run_id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
GROUP BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name
) f
WHERE test_case_id IS NOT NULL AND total_successes = 0
ORDER BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name

SQL (0.647587)  SELECT * FROM (SELECT
 build_configurations.name AS build_configuration_name,
 test_configurations.name AS test_configuration_name,
 groups.name AS group_name,
 test_cases.name AS test_case_name,
 test_case_executions.name AS test_case_execution_name,
 count(case when build_configurations.test_run_id = 7257 then 1 else NULL end) AS current_run,
 count(case when build_configurations.test_run_id = 7240 then 1 else NULL end) AS in_last_run,
 count(*) AS total_runs,
 count(case when build_configurations.test_run_id = 7257 AND test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS current_success,
 count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS total_successes,
 max(case when build_configurations.test_run_id = 7257 then test_cases.id else NULL end) AS test_case_id,
 max(case when build_configurations.test_run_id = 7257 then test_case_executions.result else NULL end) AS test_case_execution
FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
WHERE
 build_configurations.test_run_id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
GROUP BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name
) f
WHERE test_case_id IS NULL AND in_last_run = 1
ORDER BY build_configuration_name, test_configuration_name, group_name, test_case_name, test_case_execution_name

SQL (0.298858)  SELECT
 build_configuration_name,
 MAX(case when test_run_id = 7098 then value else NULL end) AS test_run_7098, MAX(case when test_run_id = 7113 then value else NULL end) AS test_run_7113, MAX(case when test_run_id = 7128 then value else NULL end) AS test_run_7128, MAX(case when test_run_id = 7151 then value else NULL end) AS test_run_7151, MAX(case when test_run_id = 7167 then value else NULL end) AS test_run_7167, MAX(case when test_run_id = 7186 then value else NULL end) AS test_run_7186, MAX(case when test_run_id = 7205 then value else NULL end) AS test_run_7205, MAX(case when test_run_id = 7222 then value else NULL end) AS test_run_7222, MAX(case when test_run_id = 7240 then value else NULL end) AS test_run_7240, MAX(case when test_run_id = 7257 then value else NULL end) AS test_run_7257
FROM
 (SELECT
 test_runs.id AS test_run_id,
 build_configurations.name AS build_configuration_name,
 CAST((CAST(count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS double precision)/count(*) * 100.0) AS int4) as value
 FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
 LEFT JOIN test_runs ON build_configurations.test_run_id = test_runs.id
 WHERE test_runs.id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
 GROUP BY test_runs.id, build_configurations.name) t
GROUP BY build_configuration_name
HAVING SUM(value) < 10 * 100
ORDER BY SUM(value), build_configuration_name

SQL (0.307023)  SELECT
 test_case_name,
 MAX(case when test_run_id = 7098 then value else NULL end) AS test_run_7098, MAX(case when test_run_id = 7113 then value else NULL end) AS test_run_7113, MAX(case when test_run_id = 7128 then value else NULL end) AS test_run_7128, MAX(case when test_run_id = 7151 then value else NULL end) AS test_run_7151, MAX(case when test_run_id = 7167 then value else NULL end) AS test_run_7167, MAX(case when test_run_id = 7186 then value else NULL end) AS test_run_7186, MAX(case when test_run_id = 7205 then value else NULL end) AS test_run_7205, MAX(case when test_run_id = 7222 then value else NULL end) AS test_run_7222, MAX(case when test_run_id = 7240 then value else NULL end) AS test_run_7240, MAX(case when test_run_id = 7257 then value else NULL end) AS test_run_7257
FROM
 (SELECT
 test_runs.id AS test_run_id,
 test_cases.name AS test_case_name,
 CAST((CAST(count(case when test_case_executions.result = 'SUCCESS' then 1 else NULL end) AS double precision)/count(*) * 100.0) AS int4) as value
 FROM test_case_executions
 LEFT JOIN test_cases ON test_case_executions.test_case_id = test_cases.id
 LEFT JOIN groups ON test_cases.group_id = groups.id
 LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
 LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
 LEFT JOIN test_runs ON build_configurations.test_run_id = test_runs.id
 WHERE test_runs.id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257)
 GROUP BY test_runs.id, test_cases.name) t
GROUP BY test_case_name
HAVING SUM(value) < 10 * 100
ORDER BY SUM(value), test_case_name

SQL (0.221581)   SELECT
 build_configuration_name,
 test_configuration_name,
 group_name,
 test_case_name,
 results.stat_name as name,
 MAX(case when test_run_id = 7098 then value else NULL end) AS test_run_7098, MAX(case when test_run_id = 7113 then value else NULL end) AS test_run_7113, MAX(case when test_run_id = 7128 then value else NULL end) AS test_run_7128, MAX(case when test_run_id = 7151 then value else NULL end) AS test_run_7151, MAX(case when test_run_id = 7167 then value else NULL end) AS test_run_7167, MAX(case when test_run_id = 7186 then value else NULL end) AS test_run_7186, MAX(case when test_run_id = 7205 then value else NULL end) AS test_run_7205, MAX(case when test_run_id = 7222 then value else NULL end) AS test_run_7222, MAX(case when test_run_id = 7240 then value else NULL end) AS test_run_7240, MAX(case when test_run_id = 7257 then value else NULL end) AS test_run_7257,
 case when less_is_more = true then 1 else 0 end as less_is_more,
 stddev(results.value) AS std_deviation,
 best_score
FROM
 (SELECT
 test_runs.id AS test_run_id,
 statistics_map.label AS stat_name,
 test_case_statistics.value AS value
FROM test_cases
LEFT JOIN test_case_statistics ON test_case_statistics.owner_id = test_cases.id
LEFT JOIN groups ON test_cases.group_id = groups.id
LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
LEFT JOIN test_runs ON build_configurations.test_run_id = test_runs.id
LEFT JOIN hosts ON test_runs.host_id = hosts.id
LEFT JOIN statistics_map ON (
 (test_runs.name = statistics_map.test_run_name OR statistics_map.test_run_name IS NULL) AND
 (build_configurations.name = statistics_map.build_configuration_name OR statistics_map.build_configuration_name IS NULL) AND
 (test_configurations.name = statistics_map.test_configuration_name OR statistics_map.test_configuration_name IS NULL) AND
 groups.name = statistics_map.group_name AND
 test_cases.name = statistics_map.test_case_name AND
 test_case_statistics.key = statistics_map.name
 )
WHERE
 test_runs.id IN (7098, 7113, 7128, 7151, 7167, 7186, 7205, 7222, 7240, 7257) AND
 statistics_map.label IN ('dacapo: antlr', 'dacapo: bloat', 'dacapo: chart', 'dacapo: eclipse', 'dacapo: fop', 'dacapo: hsqldb', 'dacapo: jython', 'dacapo: luindex', 'dacapo: lusearch', 'dacapo: pmd', 'dacapo: sunflow', 'dacapo: xalan', 'SPECjvm98', 'SPECjbb2000', 'SPECjbb2005')

) results,
 (SELECT
 build_configuration_name,
 test_configuration_name,
 group_name,
 test_case_name,
 stat_name,
 less_is_more,
 case when less_is_more = true then min_score else max_score end as best_score
FROM (
SELECT
 build_configurations.name as build_configuration_name,
 test_configurations.name as test_configuration_name,
 groups.name as group_name,
 test_cases.name as test_case_name,
 statistics_map.label as stat_name,
 statistics_map.less_is_more as less_is_more,
 MAX(test_case_statistics.value) as max_score,
 MIN(test_case_statistics.value) as min_score
FROM test_cases
LEFT JOIN test_case_statistics ON test_case_statistics.owner_id = test_cases.id
LEFT JOIN groups ON test_cases.group_id = groups.id
LEFT JOIN test_configurations ON groups.test_configuration_id = test_configurations.id
LEFT JOIN build_configurations ON test_configurations.build_configuration_id = build_configurations.id
LEFT JOIN test_runs ON build_configurations.test_run_id = test_runs.id
LEFT JOIN hosts ON test_runs.host_id = hosts.id
LEFT JOIN statistics_map ON (
 (test_runs.name = statistics_map.test_run_name OR statistics_map.test_run_name IS NULL) AND
 (build_configurations.name = statistics_map.build_configuration_name OR statistics_map.build_configuration_name IS NULL) AND
 (test_configurations.name = statistics_map.test_configuration_name OR statistics_map.test_configuration_name IS NULL) AND
 groups.name = statistics_map.group_name AND
 test_cases.name = statistics_map.test_case_name AND
 test_case_statistics.key = statistics_map.name
 )
WHERE
 hosts.name = 'jalapeno.anu.edu.au' AND
 test_runs.variant = 'sanity' AND
 test_runs.start_time <= 'Wed Jan 14 11:00:35 UTC 2009' AND
 test_runs.start_time >= timestamp 'Wed Jan 14 11:00:35 UTC 2009' - interval '75 days' AND
 statistics_map.label IN ('dacapo: antlr', 'dacapo: bloat', 'dacapo: chart', 'dacapo: eclipse', 'dacapo: fop', 'dacapo: hsqldb', 'dacapo: jython', 'dacapo: luindex', 'dacapo: lusearch', 'dacapo: pmd', 'dacapo: sunflow', 'dacapo: xalan', 'SPECjvm98', 'SPECjbb2000', 'SPECjbb2005')

GROUP BY statistics_map.label, statistics_map.less_is_more, build_configurations.name, test_configurations.name, groups.name, test_cases.name
) f
) best_scores
WHERE best_scores.stat_name = results.stat_name
GROUP BY results.stat_name, less_is_more, best_score, build_configuration_name, test_configuration_name, group_name, test_case_name
ORDER BY results.stat_name

Rendering  within layouts/application
Rendering results/test_run/regression_report
SystemSetting Load (0.000996)  SELECT * FROM system_settings WHERE (system_settings."name" = 'scm.url') LIMIT 1
Tdm::Host Load (0.000769)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000750)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000738)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000737)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000737)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000736)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000746)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000757)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000751)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::Host Load (0.000746)  SELECT * FROM hosts WHERE (hosts.id = 13) 
Tdm::TestCaseExecution Count (0.031248)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7098 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.026222)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7098) f
Tdm::TestCaseExecution Count (0.030178)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7113 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025613)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7113) f
Tdm::TestCaseExecution Count (0.029034)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7128 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025481)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7128) f
Tdm::TestCaseExecution Count (0.030224)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7151 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025853)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7151) f
Tdm::TestCaseExecution Count (0.029345)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7167 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025545)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7167) f
Tdm::TestCaseExecution Count (0.029863)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7186 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025808)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7186) f
Tdm::TestCaseExecution Count (0.029609)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7205 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025702)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7205) f
Tdm::TestCaseExecution Count (0.030670)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7222 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025926)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7222) f
Tdm::TestCaseExecution Count (0.030262)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7240 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025945)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7240) f
Tdm::TestCaseExecution Count (0.029804)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7257 AND test_case_executions.result = 'SUCCESS') f
Tdm::TestCaseExecution Count (0.025386)  SELECT COUNT(*) FROM (SELECT test_case_executions.* FROM test_runs
 RIGHT JOIN build_configurations ON build_configurations.test_run_id = test_runs.id
 RIGHT JOIN test_configurations ON test_configurations.build_configuration_id = build_configurations.id
 RIGHT JOIN groups ON groups.test_configuration_id = test_configurations.id
 RIGHT JOIN test_cases ON test_cases.group_id = groups.id
 RIGHT JOIN test_case_executions ON test_case_executions.test_case_id = test_cases.id
 WHERE test_runs.id = 7257) f
Rendered /common/_flash_messages (0.00056)
SystemSetting Load (0.000963)  SELECT * FROM system_settings WHERE (system_settings."name" = 'minor.version') LIMIT 1
SQL (0.000642)  SELECT version FROM schema_info
Completed in 5.02443 (0 reqs/sec) | Rendering: 0.27535 (5%) | DB: 4.72177 (93%) | 200 OK [http://jikesrvm.anu.edu.au/results/jalapeno.anu.edu.au/sanity/7257/regression_report]
SQL (0.000616)  SET client_encoding TO 'UTF8'
SQL (0.007827)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = 'system_settings'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum

SystemSetting Indexes (0.004666)   SELECT i.relname, d.indisunique, a.attname
 FROM pg_class t, pg_class i, pg_index d, pg_attribute a
 WHERE i.relkind = 'i'
 AND d.indexrelid = i.oid
 AND d.indisprimary = 'f'
 AND t.oid = d.indrelid
 AND t.relname = 'system_settings'
 AND a.attrelid = t.oid
 AND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum
 OR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum
 OR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum
 OR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum
 OR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )
 ORDER BY i.relname

SystemSetting Indexes (0.001677)   SELECT c2.relname, i.indisunique, pg_catalog.pg_get_indexdef(i.indexrelid, 0, true)
 FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i
 WHERE c.relname = 'system_settings'
 AND c.oid = i.indrelid AND i.indexrelid = c2.oid
 AND i.indisprimary = 'f'
 AND i.indexprs IS NOT NULL
 ORDER BY 1

SystemSetting Load (0.002383)  SELECT * FROM system_settings WHERE (system_settings."name" = 'session.timeout') LIMIT 1
CGI::Session::ActiveRecordStore::Session Load (0.001493)  SELECT * FROM sessions WHERE (updated_on < '2009-01-14 20:30:03.558679')