Alright, now that I've unearthed the page I was looking for, a fuller
answer.
The wiki replicas have to do a lot of database magic to remove
private/deleted data, which means that the normal tables can be slow.
For your logging query, logging_logindex makes things faster because
log_action is
You should use the un(der)-documented `logging_logindex` view instead of
`logging`.
On Wed, Apr 15, 2020 at 17:56 Maciej Jaros wrote:
> Not sure if this is an appropriate place to discuss this but I'm not able
> to run this query:
> https://quarry.wmflabs.org/query/24267
>
> Even a minor part
Also note that I have a similar query that kind of works but takes much
longer to complete then it used to.
https://quarry.wmflabs.org/query/41680
Executed in 46.22 seconds as of Wed Jan 29 2020.
Resultset (1480 rows)
Executed in 188.32 seconds as of Wed Apr 15 2020.
Resultset (1480 rows)
So
Not sure if this is an appropriate place to discuss this but I'm not
able to run this query:
https://quarry.wmflabs.org/query/24267
Even a minor part of this query like below needs a significant time to
complete.
SELECT count(*) as review_count, log_actor
FROM logging
WHERE
