Comment 6 for bug 622668

Most of the transaction time is read time: calculating the relevant data. For each of the different counts we do a separate query over TranslationMessage table, and some of them are pretty complex (especially the unreviewed_count). I'd like us to investigate why has pofile-stats script runtime gone from 24h to 8 days for roughly the same data size (i.e. 1.2M POFiles on 70M TranslationMessage table compared to the old days and 900K POFiles on roughly 100M row table).

If it is indeed a slow query, we should look at pofile.updateStatistics().