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.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 25 2017, 5:24 PM
KartikMistry triaged this task as Medium priority.Apr 27 2017, 3:17 AM
Amire80 moved this task from Needs Triage to Bugs on the ContentTranslation board.Jun 25 2017, 9:07 PM
Arrbee moved this task from Bugs to Check & Move on the ContentTranslation board.Jul 22 2019, 1:56 PM
Arrbee added a subscriber: Arrbee.

To be revisited during CXStats page rework