Replace count(*) with count(1) in the subquery. It could help (?) to improve the performance.

Dennis Tobar Calderón
(Enviado desde un móvil)

El 30 dic. 2017 3:10 p. m., "John" <phoenixoverride@gmail.com> escribió:
I would also find the first log of 2017 and use that instead of the timestamp

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud