[Labs-l] Empty Cat query

[Huji Lee]

Hi all,

I have a query [1] which I run weekly to identify empty categories; those
that don't have interwiki links and stay empty for a while are then deleted
by a sysop.

The query ran just fine every week until Sep 2nd. [2] Since then, the query
times out and the page doesn't get updated.

The query is no that complex (a SELECT with five JOINs) and used to finish
in about 3-5 minutes. I don't have EXPLAIN access on Labs so I cannot tell
what is slowing it down. Can someone kindly take a look and advise why this
suddenly stopped working?

Thanks,

Huji

[1] https://quarry.wmflabs.org/query/3760
[2]
https://fa.wikipedia.org/w/index.php?title=%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4_%D8%AF%DB%8C%D8%AA%D8%A7%D8%A8%DB%8C%D8%B3/%D8%B1%D8%AF%D9%87%E2%80%8C%D9%87%D8%A7%DB%8C_%D8%AE%D8%A7%D9%84%DB%8C&action=history&uselang=en
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20160923/5dc55384/attachment.html>