Comment 7 for bug 447418

Robert Collins (lifeless) wrote :

This is the bulk of the sql time:

time Average time Saving Database id Statement
1 328 6439 19 6420 launchpad-main-slave SELECT BugSubscription.bug, BugSubscription.date_created, BugSubscription.id, BugSubscription.person, BugSubscription.subscribed_by, "_prejoin1".account, "_prejoin1".creation_comment, "_prejoin1".creation_rationale, "_prejoin1".datecreated, "_prejoin1".defaultmembershipperiod, "_prejoin1".defaultrenewalperiod, "_prejoin1".displayname, "_prejoin1".hide_email_addresses, "_prejoin1".homepage_content, "_prejoin1".icon, "_prejoin1".id, "_prejoin1".logo, "_prejoin1".mailing_list_auto_subscribe_policy, "_prejoin1".merged, "_prejoin1".mugshot, "_prejoin1".name, "_prejoin1".personal_standing, "_prejoin1".personal_standing_reason, "_prejoin1".registrant, "_prejoin1".renewal_policy, "_prejoin1".subscriptionpolicy, "_prejoin1".teamdescription, "_prejoin1".teamowner, "_prejoin1".verbose_bugnotifications, "_prejoin1".visibility FROM BugSubscription LEFT JOIN Person AS "_prejoin1" ON BugSubscription.person = "_prejoin1".id WHERE BugSubscription.bug = %s AND (1=1) ORDER BY BugSubscription.id

which is, if I read it right, a lookup for subscribers of a single bug (and this would explain the private bug correlation with the issue)