[Labs-l] Optimizing a query

[Huji Lee]

Hi,

I am trying to optimize a query which aims to do this: find the latest 100
blocks performed by a certain user (in this case, the Abuse filter
account), and figure out if any of them were later unblocked by any user.

My attempts so far have lead to https://quarry.wmflabs.org/query/15158
which is still not efficient. I tried including the log_namespace in the
join conditions to encourage the use of page_time index, but that wasn't
helpful.

Does anyone have a better idea on how to optimize this query?

Thanks,

Huji
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20170528/effe8997/attachment.html>