| 2011-02-28 01:53:27 |
Robert Collins |
description |
29 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 29 Robots: 0 Local: 21
9 https://translations.launchpad.net/ubuntu/natty/+source/gtk+3.0/+pots/gtk/bs/+translate (POFile:+translate)
OOPS-1857C1191, OOPS-1857D1047, OOPS-1857E1009, OOPS-1857E1017, OOPS-1857F1052
5 https://translations.launchpad.net/ubuntu/maverick/+source/kdepim/+pots/korganizer/bs/+translate (POFile:+translate)
OOPS-1857E2149, OOPS-1857F1932, OOPS-1857K2035, OOPS-1857M1766, OOPS-1857O2137
3 https://translations.launchpad.net/ubuntu-tweak/0.6.x/+pots/ubuntu-tweak/uk/+translate (POFile:+translate)
OOPS-1857A1765, OOPS-1857C2332, OOPS-1857E2160
[10 other URLs]
OOPS-1857C1191 seems reasonably representative:
SQL time: 12125 ms
Non-sql time: 3575 ms
Total time: 15700 ms
Statement Count: 349
late evaluation for PotMsgSet, TranslationMessage, PoTranslation, PoTemplate, TranslationTemplateItem, Person, TranslationRelicensingAgreement, TranslationGroup, ProductSeries and Product |
35 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 33 POST: 2 Robots: 0 Local: 34
7 https://translations.launchpad.net/leechcraft/trunk/+pots/bittorrent/pl/+translate (POFile:+translate)
OOPS-1883C722, OOPS-1883D773, OOPS-1883E785, OOPS-1883G750, OOPS-1883O809
4 https://translations.launchpad.net/tortoisehg/stable/+pots/tortoisehg/pt_BR/+translate (POFile:+translate)
OOPS-1883D437, OOPS-1883E716, OOPS-1883K558, OOPS-1883L721
3 https://translations.launchpad.net/chive/trunk/+pots/chive/fi/+translate (POFile:+translate)
OOPS-1883D2125, OOPS-1883E2003, OOPS-1883L1714
[15 other URLs]
OOPS-1857C1191 seems reasonably representative:
SQL time: 12125 ms
Non-sql time: 3575 ms
Total time: 15700 ms
Statement Count: 349
late evaluation for PotMsgSet, TranslationMessage, PoTranslation, PoTemplate, TranslationTemplateItem, Person, TranslationRelicensingAgreement, TranslationGroup, ProductSeries and Product |
|
| 2011-02-28 02:07:38 |
Robert Collins |
description |
35 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 33 POST: 2 Robots: 0 Local: 34
7 https://translations.launchpad.net/leechcraft/trunk/+pots/bittorrent/pl/+translate (POFile:+translate)
OOPS-1883C722, OOPS-1883D773, OOPS-1883E785, OOPS-1883G750, OOPS-1883O809
4 https://translations.launchpad.net/tortoisehg/stable/+pots/tortoisehg/pt_BR/+translate (POFile:+translate)
OOPS-1883D437, OOPS-1883E716, OOPS-1883K558, OOPS-1883L721
3 https://translations.launchpad.net/chive/trunk/+pots/chive/fi/+translate (POFile:+translate)
OOPS-1883D2125, OOPS-1883E2003, OOPS-1883L1714
[15 other URLs]
OOPS-1857C1191 seems reasonably representative:
SQL time: 12125 ms
Non-sql time: 3575 ms
Total time: 15700 ms
Statement Count: 349
late evaluation for PotMsgSet, TranslationMessage, PoTranslation, PoTemplate, TranslationTemplateItem, Person, TranslationRelicensingAgreement, TranslationGroup, ProductSeries and Product |
35 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 33 POST: 2 Robots: 0 Local: 34
7 https://translations.launchpad.net/leechcraft/trunk/+pots/bittorrent/pl/+translate (POFile:+translate)
OOPS-1883C722, OOPS-1883D773, OOPS-1883E785, OOPS-1883G750, OOPS-1883O809
4 https://translations.launchpad.net/tortoisehg/stable/+pots/tortoisehg/pt_BR/+translate (POFile:+translate)
OOPS-1883D437, OOPS-1883E716, OOPS-1883K558, OOPS-1883L721
3 https://translations.launchpad.net/chive/trunk/+pots/chive/fi/+translate (POFile:+translate)
OOPS-1883D2125, OOPS-1883E2003, OOPS-1883L1714
[15 other URLs]
OOPS-1883C722
Branch: launchpad-rev-12460
Revno: 12460
SQL time: 12696 ms
Non-sql time: 1575 ms
Total time: 14271 ms
Statement Count: 268
late evaluation for PotMsgSet, TranslationMessage, PoTranslation, PoTemplate, TranslationTemplateItem, Person, TranslationRelicensingAgreement, TranslationGroup, ProductSeries and Product
Major time sink is
9 6 6837 1139 5698 SQL-launchpad-main-master
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0,
TranslationMessage.msgstr1,
TranslationMessage.msgstr2,
TranslationMessage.msgstr3,
TranslationMessage.msgstr4,
TranslationMessage.msgstr5,
TranslationMessage.origin,
TranslationMessage.potemplate,
TranslationMessage.potmsgset,
TranslationMessage.reviewer,
TranslationMessage.submitter,
TranslationMessage.validation_status,
TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT)) TranslationMessage.id
FROM TranslationMessage
WHERE (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE)
AND TranslationMessage.LANGUAGE = $INT
AND TranslationMessage.potmsgset <> $INT
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = $INT)
ORDER BY COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC)LIMIT $INT
10 6 3741 623 3118 SQL-launchpad-main-master
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0,
TranslationMessage.msgstr1,
TranslationMessage.msgstr2,
TranslationMessage.msgstr3,
TranslationMessage.msgstr4,
TranslationMessage.msgstr5,
TranslationMessage.origin,
TranslationMessage.potemplate,
TranslationMessage.potmsgset,
TranslationMessage.reviewer,
TranslationMessage.submitter,
TranslationMessage.validation_status,
TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT)) TranslationMessage.id
FROM TranslationMessage
WHERE (NOT (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE))
AND TranslationMessage.LANGUAGE = $INT
AND TranslationMessage.potmsgset <> $INT
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = $INT)
ORDER BY COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC)LIMIT $INT |
|
| 2011-02-28 02:20:24 |
Robert Collins |
description |
35 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 33 POST: 2 Robots: 0 Local: 34
7 https://translations.launchpad.net/leechcraft/trunk/+pots/bittorrent/pl/+translate (POFile:+translate)
OOPS-1883C722, OOPS-1883D773, OOPS-1883E785, OOPS-1883G750, OOPS-1883O809
4 https://translations.launchpad.net/tortoisehg/stable/+pots/tortoisehg/pt_BR/+translate (POFile:+translate)
OOPS-1883D437, OOPS-1883E716, OOPS-1883K558, OOPS-1883L721
3 https://translations.launchpad.net/chive/trunk/+pots/chive/fi/+translate (POFile:+translate)
OOPS-1883D2125, OOPS-1883E2003, OOPS-1883L1714
[15 other URLs]
OOPS-1883C722
Branch: launchpad-rev-12460
Revno: 12460
SQL time: 12696 ms
Non-sql time: 1575 ms
Total time: 14271 ms
Statement Count: 268
late evaluation for PotMsgSet, TranslationMessage, PoTranslation, PoTemplate, TranslationTemplateItem, Person, TranslationRelicensingAgreement, TranslationGroup, ProductSeries and Product
Major time sink is
9 6 6837 1139 5698 SQL-launchpad-main-master
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0,
TranslationMessage.msgstr1,
TranslationMessage.msgstr2,
TranslationMessage.msgstr3,
TranslationMessage.msgstr4,
TranslationMessage.msgstr5,
TranslationMessage.origin,
TranslationMessage.potemplate,
TranslationMessage.potmsgset,
TranslationMessage.reviewer,
TranslationMessage.submitter,
TranslationMessage.validation_status,
TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT)) TranslationMessage.id
FROM TranslationMessage
WHERE (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE)
AND TranslationMessage.LANGUAGE = $INT
AND TranslationMessage.potmsgset <> $INT
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = $INT)
ORDER BY COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC)LIMIT $INT
10 6 3741 623 3118 SQL-launchpad-main-master
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0,
TranslationMessage.msgstr1,
TranslationMessage.msgstr2,
TranslationMessage.msgstr3,
TranslationMessage.msgstr4,
TranslationMessage.msgstr5,
TranslationMessage.origin,
TranslationMessage.potemplate,
TranslationMessage.potmsgset,
TranslationMessage.reviewer,
TranslationMessage.submitter,
TranslationMessage.validation_status,
TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT)) TranslationMessage.id
FROM TranslationMessage
WHERE (NOT (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE))
AND TranslationMessage.LANGUAGE = $INT
AND TranslationMessage.potmsgset <> $INT
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = $INT)
ORDER BY COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC)LIMIT $INT |
35 SELECT TranslationMessage.comment, TranslationMessage.date_created, TranslationMessage.date_revie ... gstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC ) LIMIT $INT:
GET: 33 POST: 2 Robots: 0 Local: 34
7 https://translations.launchpad.net/leechcraft/trunk/+pots/bittorrent/pl/+translate (POFile:+translate)
OOPS-1883C722, OOPS-1883D773, OOPS-1883E785, OOPS-1883G750, OOPS-1883O809
4 https://translations.launchpad.net/tortoisehg/stable/+pots/tortoisehg/pt_BR/+translate (POFile:+translate)
OOPS-1883D437, OOPS-1883E716, OOPS-1883K558, OOPS-1883L721
3 https://translations.launchpad.net/chive/trunk/+pots/chive/fi/+translate (POFile:+translate)
OOPS-1883D2125, OOPS-1883E2003, OOPS-1883L1714
[15 other URLs]
OOPS-1883C722
Branch: launchpad-rev-12460
Revno: 12460
SQL time: 12696 ms
Non-sql time: 1575 ms
Total time: 14271 ms
Statement Count: 268
late evaluation for PotMsgSet, TranslationMessage, PoTranslation, PoTemplate, TranslationTemplateItem, Person, TranslationRelicensingAgreement, TranslationGroup, ProductSeries and Product
Major time sink is
9 6 6837 1139 5698 SQL-launchpad-main-master
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0,
TranslationMessage.msgstr1,
TranslationMessage.msgstr2,
TranslationMessage.msgstr3,
TranslationMessage.msgstr4,
TranslationMessage.msgstr5,
TranslationMessage.origin,
TranslationMessage.potemplate,
TranslationMessage.potmsgset,
TranslationMessage.reviewer,
TranslationMessage.submitter,
TranslationMessage.validation_status,
TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT)) TranslationMessage.id
FROM TranslationMessage
WHERE (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE)
AND TranslationMessage.LANGUAGE = $INT
AND TranslationMessage.potmsgset <> $INT
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = $INT)
ORDER BY COALESCE(msgstr0, -$INT), COALESCE(msgstr1, -$INT), COALESCE(msgstr2, -$INT), COALESCE(msgstr3, -$INT), COALESCE(msgstr4, -$INT), COALESCE(msgstr5, -$INT), date_created DESC)LIMIT $INT
plus a second slow repeated query.
10 6 3741 623 3118
6 instances of this - two look like:
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0, TranslationMessage.msgstr1, TranslationMessage.msgstr2, TranslationMessage.msgstr3, TranslationMessage.msgstr4, TranslationMessage.msgstr5, TranslationMessage.origin, TranslationMessage.potemplate, TranslationMessage.potmsgset, TranslationMessage.reviewer, TranslationMessage.submitter, TranslationMessage.validation_status, TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -1), COALESCE(msgstr1, -1), COALESCE(msgstr2, -1), COALESCE(msgstr3, -1), COALESCE(msgstr4, -1), COALESCE(msgstr5, -1)) TranslationMessage.id
FROM TranslationMessage
WHERE (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE)
AND TranslationMessage.LANGUAGE = 333
AND TranslationMessage.potmsgset <> 9699798
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = 277516)
ORDER BY COALESCE(msgstr0, -1), COALESCE(msgstr1, -1), COALESCE(msgstr2, -1), COALESCE(msgstr3, -1), COALESCE(msgstr4, -1), COALESCE(msgstr5, -1), date_created DESC)LIMIT 2001
SELECT TranslationMessage.COMMENT, TranslationMessage.date_created,
TranslationMessage.date_reviewed,
TranslationMessage.id,
TranslationMessage.is_current_ubuntu,
TranslationMessage.is_current_upstream,
TranslationMessage.LANGUAGE, TranslationMessage.msgstr0, TranslationMessage.msgstr1, TranslationMessage.msgstr2, TranslationMessage.msgstr3, TranslationMessage.msgstr4, TranslationMessage.msgstr5, TranslationMessage.origin, TranslationMessage.potemplate, TranslationMessage.potmsgset, TranslationMessage.reviewer, TranslationMessage.submitter, TranslationMessage.validation_status, TranslationMessage.was_obsolete_in_last_import
FROM TranslationMessage
WHERE TranslationMessage.id IN
(SELECT DISTINCT ON (COALESCE(msgstr0, -1), COALESCE(msgstr1, -1), COALESCE(msgstr2, -1), COALESCE(msgstr3, -1), COALESCE(msgstr4, -1), COALESCE(msgstr5, -1)) TranslationMessage.id
FROM TranslationMessage
WHERE (NOT (is_current_ubuntu IS TRUE
OR is_current_upstream IS TRUE))
AND TranslationMessage.LANGUAGE = 333
AND TranslationMessage.potmsgset <> 9699798
AND potmsgset IN
(SELECT POTMsgSet.id
FROM POTMsgSet
JOIN TranslationTemplateItem ON TranslationTemplateItem.potmsgset = POTMsgSet.id
JOIN SuggestivePOTemplate ON TranslationTemplateItem.potemplate = SuggestivePOTemplate.potemplate
WHERE msgid_singular = 277516)
ORDER BY COALESCE(msgstr0, -1), COALESCE(msgstr1, -1), COALESCE(msgstr2, -1), COALESCE(msgstr3, -1), COALESCE(msgstr4, -1), COALESCE(msgstr5, -1), date_created DESC)LIMIT 2001 |
|
