Sorry Brad, I had missed your email.

Putting log_timestamp back in and restricting the query to a shorter time period made it work under 20 minutes: https://quarry.wmflabs.org/query/23829

Thank you all for your assistance!

On Sun, Dec 31, 2017 at 1:44 PM, Brad Jorsch (Anomie) <bjorsch@wikimedia.org> wrote:
On Sat, Dec 30, 2017 at 10:55 PM, Huji Lee <huji.huji@gmail.com> wrote:
and log_id > 9406768;

As I said earlier, it was bad advice to use log_id rather than log_timestamp for this query.


--
Brad Jorsch (Anomie)
Senior Software Engineer
Wikimedia Foundation

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud