Jump to content

User:Razzi/Triage Superset Dashboard Timeouts - T294768

From Wikitech

https://phabricator.wikimedia.org/T294768

> Based on the spreadsheet provided by product analytics, this task involves running the specific dashboards in Superset and finding out which SQL statements time out (exceeded the Superset designated timeout), based on the Presto query table.

https://docs.google.com/spreadsheets/d/1YqYDEDNXpBPMjG_WUoNB8iHF9rO4yu1kJMHddIatn58/edit?usp=sharing

3 issues

editors metrics

IP Masking Dashboard

Edit_topics_dashboard

Editors Metrics

Active Editors YoY FY19/20 - FY21/22

New and Returning Active Editors YoY FY19/20 - FY21/22

Active Editors by Market YoY FY20/21 - FY21/22

[no timeouts]

IP Masking Dashboard (24 charts)

Blocks Excluding Wikidata - timeout error

Protected Pages - timeout error

Protected Pages Excluding Wikidata - timeout error

Top Deleted Pages By Project - timeout error

Top 5 Check User Requests by Projects - timeout error

Top Active Admins by Projects - timeout error


more timeouts

Suggestions

Split dashboards into multiple

Edits/Admin Ratio

Top Edits/Admin Ratio By Project