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) <bjor...@wikimedia.org > wrote: > On Sat, Dec 30, 2017 at 10:55 PM, Huji Lee <huji.h...@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 lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud >
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud