6 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 6 Robots: 0 Local: 0
3 https://launchpad.net/ubuntu-it/+index (Product:+index)
OOPS-1926E737, OOPS-1926G741, OOPS-1926G742
1 https://launchpad.net/glib/+index (Product:+index)
OOPS-1926H1059
1 https://launchpad.net/indicator-applet/+index (Product:+index)
OOPS-1926B1590
[1 other URLs]
6 SELECT ProductReleaseFile.date_uploaded, ProductReleaseFile.description, ProductReleaseFile.filet ... .productrelease IN ($INT ... $INT) AND ($INT=$INT) ORDER BY ProductReleaseFile.date_uploaded DESC:
GET: 6 Robots: 0 Local: 6
6 https://launchpad.net/rhythmbox/+index (Product:+index)
OOPS-1926C1169, OOPS-1926E1448, OOPS-1926G1357, OOPS-1926H1436, OOPS-1926H1439
slow SQL looking guessing at packaging
11706ms SQL-launchpad-main-slave SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdescriptions, DistributionSourcePackageCache.binpkgnames, DistributionSourcePackageCache.binpkgsummaries, DistributionSourcePackageCache.changelog, DistributionSourcePackageCache.distribution, DistributionSourcePackageCache.id, DistributionSourcePackageCache.name, DistributionSourcePackageCache.sourcepackagename, SourcePackageName.id, SourcePackageName.name, rank(fti, ftq('indicator-applet')) AS rank
FROM DistributionSourcePackageCache
JOIN SourcePackageName ON DistributionSourcePackageCache.sourcepackagename = SourcePackageName.id
JOIN SourcePackageRelease ON SourcePackageRelease.sourcepackagename = SourcePackageName.id
JOIN SourcePackagePublishingHistory ON SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id
WHERE DistributionSourcePackageCache.distribution = 1
AND DistributionSourcePackageCache.archive IN (1,
534)
AND (DistributionSourcePackageCache.fti @@ ftq('indicator-applet')
OR DistributionSourcePackageCache.name ILIKE '%' || 'indicator-applet' || '%')
AND NOT EXISTS
(SELECT 1
FROM Packaging
WHERE Packaging.sourcepackagename = SourcePackageName.id)
AND SourcePackagePublishingHistory.distroseries = 106
ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT 8
OFFSET 0
select count(*) from DistributionSou rcePackageCache ;
count
-------
96686