[Labs-l] query optimization

[Jaime Crespo]

https://phabricator.wikimedia.org/P2251

Sorry, no time to do a full profile, even if I would love to, but maybe
that is helpful :-(

On Wed, Oct 28, 2015 at 7:44 PM, Yetkin Sakal <superyetkin at yahoo.com> wrote:

> user_daily_contribs having been dropped, I am facing serious problems
> about a query. How to optimize this?
>
> SELECT
>     u.user_name,
>     COUNT(rev.rev_id) AS contribs
> FROM
>     user u
>     INNER JOIN user_groups ug
>     ON u.user_id = ug.ug_user
>     INNER JOIN revision_userindex rev
>     ON rev.rev_user = u.user_id
> WHERE
>     ug.ug_group IN ('sysop', 'bureaucrat', 'checkuser', 'oversight')
>     AND rev.rev_timestamp >= 20150928000000
> GROUP BY
>     u.user_name
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>


-- 
Jaime Crespo
<http://wikimedia.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20151028/bbf81806/attachment.html>