| 2010-08-02 21:18:06 |
Robert Collins |
description |
Launchpad needs to increase it's bandwidth.
The connection has timed out.
Happening a lot. |
https://lp-oops.canonical.com/oops.py/?oopsid=1655M676
https://bugs.launchpad.net/ubuntu/+source/k3b/+filebug/11305b3c-8e71-11df-8a2d-0025b3df357a
SQL time: 20293 ms
Non-sql time: 96 ms
Total time: 20389 ms
Statement Count: 31
27. 351 20005ms launchpad-main-master SELECT PublishedPackage.archive, PublishedPackage.binarypackagedescription, PublishedPackage.binarypackagename, PublishedPackage.binarypackagerelease, PublishedPackage.binarypackagesummary, PublishedPackage.binarypackageversion, PublishedPackage.build, PublishedPackage.component, PublishedPackage.datebuilt, PublishedPackage.distribution, PublishedPackage.distroarchseries, PublishedPackage.distroseries, PublishedPackage.distroseriesname, PublishedPackage.id, PublishedPackage.packagepublishingstatus, PublishedPackage.processorfamily, PublishedPackage.processorfamilyname, PublishedPackage.section, PublishedPackage.sourcepackagename, PublishedPackage.sourcepackagerelease, PublishedPackage.sourcepackagereleaseversion FROM PublishedPackage WHERE PublishedPackage.sourcepackagename = 'k3b' AND PublishedPackage.binarypackagename = 'k3b' AND PublishedPackage.distribution = 1 AND PublishedPackage.archive IN (1, 534) ORDER BY PublishedPackage.id DESC LIMIT 1
Limit (cost=35779.49..35779.50 rows=1 width=577) (actual time=12651.332..12651.333 rows=1 loops=1)
-> Sort (cost=35779.49..35779.50 rows=1 width=577) (actual time=12651.328..12651.328 rows=1 loops=1)
Sort Key: securebinarypackagepublishinghistory.id
Sort Method: top-N heapsort Memory: 25kB
-> Nested Loop (cost=0.00..35779.48 rows=1 width=577) (actual time=4202.014..12650.884 rows=122 loops=1)
-> Nested Loop (cost=0.00..35779.09 rows=1 width=545) (actual time=4202.003..12650.097 rows=122 loops=1)
-> Nested Loop (cost=0.00..35772.66 rows=1 width=541) (actual time=4201.982..12648.822 rows=122 loops=1)
Join Filter: (distroarchseries.distroseries = distroseries.id)
-> Nested Loop (cost=0.00..35772.34 rows=1 width=537) (actual time=331.019..12630.048 rows=1586 loops=1)
-> Nested Loop (cost=0.00..35771.42 rows=1 width=509) (actual time=331.004..12620.385 rows=1586 loops=1)
Join Filter: (sourcepackagerelease.sourcepackagename = sourcepackagename.id)
-> Nested Loop (cost=0.00..35760.56 rows=14 width=496) (actual time=330.974..12606.370 rows=1586 loops=1)
Join Filter: (securebinarypackagepublishinghistory.section = section.id)
-> Nested Loop (cost=0.00..13124.74 rows=1925 width=480) (actual time=11.666..8416.509 rows=662805 loops=1)
-> Index Scan using sourcepackagename_name_key on sourcepackagename (cost=0.00..6.27 rows=1 width=17) (actual time=0.045..0.048 rows=1 loops=1)
Index Cond: (name = 'k3b'::text)
-> Nested Loop (cost=0.00..13099.22 rows=1925 width=463) (actual time=11.615..7521.058 rows=662805 loops=1)
-> Nested Loop (cost=0.00..722.74 rows=1925 width=463) (actual time=11.591..2640.987 rows=662805 loops=1)
-> Nested Loop (cost=0.00..649.24 rows=35 width=453) (actual time=11.577..1234.444 rows=12051 loops=1)
-> Index Scan using distrorelease_distro_release_unique on distroseries (cost=0.00..6.27 rows=1 width=40) (actual time=8.125..8.171 rows=13 loops=1)
Index Cond: (distribution = 1)
-> Nested Loop (cost=0.00..642.62 rows=35 width=413) (actual time=0.314..92.627 rows=927 loops=13)
-> Nested Loop (cost=0.00..627.27 rows=35 width=405) (actual time=0.042..6.105 rows=927 loops=13)
-> Index Scan using binarypackagename_name_key on binarypackagename (cost=0.00..6.29 rows=1 width=28) (actual time=0.016..0.018 rows=1 loops=13)
Index Cond: (name = 'k3b'::text)
-> Index Scan using binarypackagerelease_binarypackagename_key on binarypackagerelease (cost=0.00..618.06 rows=233 width=385) (actual time=0.022..4.486 rows=927 loops=13)
Index Cond: (binarypackagerelease.binarypackagename = binarypackagename.id)
-> Index Scan using binarypackagebuild_pkey on binarypackagebuild (cost=0.00..0.43 rows=1 width=12) (actual time=0.090..0.090 rows=1 loops=12051)
Index Cond: (binarypackagebuild.id = binarypackagerelease.build)
-> Seq Scan on section (cost=0.00..1.55 rows=55 width=10) (actual time=0.002..0.040 rows=55 loops=12051)
-> Index Scan using packagebuild_pkey on packagebuild (cost=0.00..6.42 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=662805)
Index Cond: (packagebuild.id = binarypackagebuild.package_build)
-> Index Scan using securebinarypackagepublishinghistory_binarypackagerelease_idx on binarypackagepublishinghistory securebinarypackagepublishinghistory (cost=0.00..11.73 rows=2 width=28) (actual time=0.005..0.005 rows=0 loops=662805)
Index Cond: (securebinarypackagepublishinghistory.binarypackagerelease = binarypackagerelease.id)
Filter: ((securebinarypackagepublishinghistory.dateremoved IS NULL) AND (securebinarypackagepublishinghistory.archive = ANY ('{1,534}'::integer[])))
-> Index Scan using sourcepackagerelease_pkey on sourcepackagerelease (cost=0.00..0.76 rows=1 width=25) (actual time=0.005..0.005 rows=1 loops=1586)
Index Cond: (sourcepackagerelease.id = binarypackagebuild.source_package_release)
-> Index Scan using component_pkey on component (cost=0.00..0.91 rows=1 width=36) (actual time=0.002..0.003 rows=1 loops=1586)
Index Cond: (component.id = securebinarypackagepublishinghistory.component)
-> Index Scan using distroarchrelease_pkey on distroarchseries (cost=0.00..0.30 rows=1 width=12) (actual time=0.009..0.009 rows=1 loops=1586)
Index Cond: (distroarchseries.id = securebinarypackagepublishinghistory.distroarchseries)
-> Index Scan using buildfarmjob_pkey on buildfarmjob (cost=0.00..6.42 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=122)
Index Cond: (buildfarmjob.id = packagebuild.build_farm_job)
-> Index Scan using processorfamily_pkey on processorfamily (cost=0.00..0.38 rows=1 width=36) (actual time=0.002..0.003 rows=1 loops=122)
Index Cond: (processorfamily.id = distroarchseries.processorfamily)
Total runtime: 12651.862 ms
|
|
