Page MenuHomePhabricator

Slow query in getDeletionTrend
Open, MediumPublic

Description

This was seen at, https://logstash.wikimedia.org/app/kibana?#/doc/logstash-*/logstash-2017.04.25/hhvm?id=AVulrcV-Ocgc5w4JrDyE&_g=(refreshInterval:(display:Off,pause:!f,value:0),time:(from:now-24h,mode:quick,to:now))

SlowTimer [33005ms] at runtime/ext_mysql: slow query: SELECT /* ContentTranslation\Translation::getDeletionTrend  */  ar_timestamp,count(ar_page_id) as count  FROM change_tag,archive    WHERE ct_tag = 'contenttranslation' AND (ar_rev_id = ct_rev_id)  GROUP BY YEARWEEK(ar_timestamp, 3)

Maybe we should remove Deletion trend and move it to Dashiki or other analysis dashboard(s) for CX.