JGonera has uploaded a new change for review. https://gerrit.wikimedia.org/r/58305
Change subject: Add Rendering time graph (in new Performance tab) ...................................................................... Add Rendering time graph (in new Performance tab) This shows the rendering value daily average from http://meta.wikimedia.org/wiki/Schema:NavigationTiming Change-Id: Ic9d7c53d12c4e42a1be5711eace51c79051a0a79 --- M dashboards/reportcard.json A datasources/performance-rendering.json A graphs/performance-rendering.json M mobile/config.yaml A mobile/performance-rendering.sql 5 files changed, 161 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data refs/changes/05/58305/1 diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json index 5315306..6b1a750 100644 --- a/dashboards/reportcard.json +++ b/dashboards/reportcard.json @@ -13,6 +13,12 @@ "successful-logins", "error-uploads" ] + }, + { + "name": "Performance", + "graph_ids": [ + "performance-rendering" + ] } ] } diff --git a/datasources/performance-rendering.json b/datasources/performance-rendering.json new file mode 100644 index 0000000..4180395 --- /dev/null +++ b/datasources/performance-rendering.json @@ -0,0 +1,26 @@ +{ + "name": "Rendering time (ms)", + "timespan": { + "start": "2013/02/18", + "step": "1d", + "end": "2013/03/19" + }, + "url": "http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/performance-rendering.csv";, + "notes": "", + "format": "csv", + "slug": null, + "shortName": "performance-rendering", + "type": "timeseries", + "id": "performance-rendering", + "columns": [ + { + "type": "date", + "label": "date" + }, + { + "type": "int", + "label": "Rendering" + } + ], + "desc": "" +} diff --git a/graphs/performance-rendering.json b/graphs/performance-rendering.json new file mode 100644 index 0000000..31e7a9b --- /dev/null +++ b/graphs/performance-rendering.json @@ -0,0 +1,119 @@ +{ + "graph_version": "0.6.0", + "name": "Rendering time (ms)", + "notes": "", + "slug": "performance-rendering", + "shortName": "", + "root": { + "scaling": "linear", + "nodeType": "canvas", + "minWidth": 750, + "minHeight": 500, + "height": 500, + "disabled": false, + "width": "auto", + "children": [ + { + "disabled": false, + "nodeType": "axis", + "options": { + "tickFormat": "MMM YY", + "dimension": "x", + "orient": "bottom" + } + }, + { + "disabled": false, + "nodeType": "axis", + "options": { + "tickFormat": "MMM YY", + "dimension": "y", + "orient": "left" + } + }, + { + "disabled": false, + "nodeType": "grid", + "options": { + "ticks": 10, + "dimension": "x" + } + }, + { + "disabled": false, + "nodeType": "grid", + "options": { + "ticks": 10, + "dimension": "y" + } + }, + { + "disabled": false, + "nodeType": "zoom-brush", + "options": { + "allowY": true, + "allowX": true + } + }, + { + "nodeType": "callout", + "target": "latest", + "disabled": false, + "steps": [ + "1y", + "1M" + ], + "metricRef": 0, + "options": { + "deltaPercent": true, + "dateFormat": "MMM YYYY", + "colorDelta": true + } + }, + { + "disabled": false, + "nodeType": "legend", + "options": { + "valueFormat": ",.2s", + "dateFormat": "MMM YYYY" + }, + "label": "Aug 2012" + }, + { + "disabled": false, + "nodeType": "line-group", + "options": { + "palette": "wmf_projects", + "scale": "log", + "stroke": { + "opacity": 1, + "width": 2 + }, + "dateFormat": "MMM YYYY" + }, + "children": [ + { + "disabled": false, + "index": 0, + "metric": { + "source_id": "performance-rendering", + "type": "int", + "source_col": 1 + }, + "nodeType": "line", + "options": { + "stroke": { + "width": 2 + }, + "label": "Rendering", + "noLegend": false, + "dateFormat": "MMM YYYY" + } + } + ] + } + ] + }, + "id": "performance-rendering", + "desc": "" +} diff --git a/mobile/config.yaml b/mobile/config.yaml index 613caff..dc419d8 100644 --- a/mobile/config.yaml +++ b/mobile/config.yaml @@ -14,6 +14,7 @@ login_attempts: MobileAppLoginAttempts_5257721 share_attempts: MobileAppShareAttempts_5346170 upload_web: MobileWebUploads_5281063 + navigation_timing: NavigationTiming_5336845 intervals: running_average: 30 output: @@ -39,3 +40,6 @@ title: Mobile Uploads vs Commons Edit count alltime-numbers: title: All time numbers + + performance-rendering: + title: Rendering time (ms) diff --git a/mobile/performance-rendering.sql b/mobile/performance-rendering.sql new file mode 100644 index 0000000..90cdc5c --- /dev/null +++ b/mobile/performance-rendering.sql @@ -0,0 +1,6 @@ +SELECT + DATE(timestamp) AS Date, + AVG(event_rendering) AS Rendering +FROM {{ tables.navigation_timing }} +GROUP BY Date +LIMIT 31; -- To view, visit https://gerrit.wikimedia.org/r/58305 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ic9d7c53d12c4e42a1be5711eace51c79051a0a79 Gerrit-PatchSet: 1 Gerrit-Project: analytics/limn-mobile-data Gerrit-Branch: master Gerrit-Owner: JGonera <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
