Distribution:+assignments is showing up on https://devpad.canonical.com/~stub/ppr/lpnet/latest-daily-timeout-candidates.html as taking a very long time 20% of the time. At only 5 hits a day, and with most hits < 1 second, its likely not going to show on our top-oops reports, but it is still timing out consistently. I wonder about contention - we should dig up an oops for it and investigate.
SQL time: 6799 ms
Non-sql time: 11123 ms
Total time: 17922 ms
Statement Count: 208
1 187 6132 32 6100 launchpad-main-slave SELECT ValidPersonCache.id FROM ValidPersonCache WHERE ValidPersonCache.id = %s LIMIT 1
is the most duplicated query, and seems to be most of the sql time.