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
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
