cronscripts/rosetta-pofile-stats.py script is simply too slow, especially with message sharing switchover code.
We've got around 685k POFiles, and in 26h we managed to process only around 182759 files. Optimizations will have to happen in POFile.updateStatistics() method, and might need to be a bit more creative. It's likely slower due to the fix of bug 172780 at the same time, but it's also migrated to use existing code as provided by POFile filtering methods (so we have less code to maintain).
This means that queries can do with more optimizations, but also that we can be a bit more creative in optimizing this: in general, there should not be any need to run full pofile update statistics across entire DB: we can run the full version once a month or so, and only run each day update over files which have been touched in the last 2 or 5 or 7 days.
Not yet fixed, we should check up on how's it doing.