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