[Labs-l] query optimization
Jaime Crespo
jcrespo at wikimedia.org
Wed Oct 28 18:54:27 UTC 2015
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>
More information about the Labs-l
mailing list