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)
This is the bulk of the sql time:
time Average time Saving Database id Statement 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" .defaultmembers hipperiod, "_prejoin1" .defaultrenewal period, "_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" .subscriptionpo licy, "_prejoin1" .teamdescriptio n, "_prejoin1" .teamowner, "_prejoin1" .verbose_ bugnotification s, "_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
1 328 6439 19 6420 launchpad-
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)