Builder history timing out

Stuart is going to analyse the query and I'll look at an option to simply return all builds (rather than filtering private ones out via complex queries), and displaying 'Private build' in the history where appropriate.

I can't reproduce this on production as the data is different.

I'd be interested in seeing how the following rewritten query performs on dogfood:

explain analyze SELECT COUNT(*) FROM BuildFarmJob
JOIN PackageBuild ON PackageBuild.build_farm_job = BuildFarmJob.id
JOIN Archive ON PackageBuild.archive = Archive.id
WHERE BuildFarmJob.builder = 106;

The rewritten query is fast. Looks like the odd join syntax was forcing a bad query plan.

Here's an oops when accessing the history page as a non-dogfood admin: https://pastebin.canonical.com/35735/

Just FTR, the remainder of the pre-imp. discussion:

{{{
17:01 < stub> explain analyze
17:01 < stub> SELECT COUNT(DISTINCT BuildFarmJob.id)
17:01 < stub> FROM BuildFarmJob
17:01 < stub> LEFT OUTER JOIN PackageBuild ON PackageBuild.build_farm_job = BuildFarmJob.id
17:01 < stub> LEFT OUTER JOIN Archive ON PackageBuild.archive = Archive.id
17:01 < stub> LEFT OUTER JOIN TeamParticipation ON TeamParticipation.team = Archive.owner
17:01 < stub> WHERE
17:01 < stub> BuildFarmJob.builder = 106
17:01 < stub> AND (Archive.private IS FALSE OR TeamParticipation.person = 1)
17:01 < stub> (I'm not sure of who a suitable owner would be, so using '1')
17:01 < jtv> (note to self: I was talking nonsense earlier)
17:02 < bigjools> noodles775: I am guessing that we won't be able to make a branch for this in the next few minutes.
17:02 < noodles775> Thanks stub: I'll try the storm equivalent.
17:02 < noodles775> bigjools: no.
17:02 < bigjools> noodles775: ok, we'll have to release with this broken, and do a re-roll or CP
}}}

I've applied the linked branch on dogfood and verified that the history now displays fine:

https://dogfood.launchpad.net/builders/rubidium/+history

Tweaked priority as per zero-oops-policy ( I know its being worked on :))

Fixed in stable r11321 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11321>.