You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Difference between revisions of "User:Razzi/Triage Superset Dashboard Timeouts - T294768"

From Wikitech-static
Jump to navigation Jump to search
imported>Razzi
 
imported>Razzi
 
Line 20: Line 20:
Active Editors by Market YoY FY20/21 - FY21/22
Active Editors by Market YoY FY20/21 - FY21/22


wip
[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

Latest revision as of 20:41, 22 November 2021

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