Comment 7 for bug 590708

18. 100 6485ms launchpad-main-master SELECT COUNT(*) FROM Archive, BinaryPackageBuild, BuildFarmJob, PackageBuild WHERE distro_arch_series IN (109, 110, 111, 112, 113, 114) AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.build_farm_job = BuildFarmJob.id AND (BuildFarmJob.status <> 1 OR BuildFarmJob.date_finished IS NOT NULL) AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.build_farm_job = BuildFarmJob.id AND BuildFarmJob.status=2 AND Archive.purpose IN (1,4) AND Archive.id = PackageBuild.archive AND (1=1)
19. 6585 6168ms launchpad-main-master SELECT BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release FROM Archive, BinaryPackageBuild, BuildFarmJob, PackageBuild WHERE distro_arch_series IN (109, 110, 111, 112, 113, 114) AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.build_farm_job = BuildFarmJob.id AND (BuildFarmJob.status <> 1 OR BuildFarmJob.date_finished IS NOT NULL) AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.build_farm_job = BuildFarmJob.id AND BuildFarmJob.status=2 AND Archive.purpose IN (1,4) AND Archive.id = PackageBuild.archive AND (1=1) ORDER BY BuildFarmJob.date_finished DESC LIMIT 50 OFFSET 0

are the two specific problemative queuries. I'm going to subscribe stub for insight.

I'm also told that lazr.restful is doing the count - we can save 50% of the SQL time (roughly) by not doing that - so subscribing leonard for input on that.