https://bugzilla.wikimedia.org/show_bug.cgi?id=68396
Bug ID: 68396 Summary: Add index on event_action, event_isAnon and event_namespaceId to NavigationTiming tables Product: Analytics Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: Unprioritized Component: EventLogging Assignee: wikibugs-l@lists.wikimedia.org Reporter: gti...@wikimedia.org CC: bugwatc...@sb-mail.wmflabs.org, christ...@quelltextlich.at, dtarabore...@wikimedia.org, kle...@wikimedia.org, nu...@wikimedia.org, o...@wikimedia.org, sp...@wikimedia.org, swall...@wikimedia.org, tneg...@wikimedia.org Web browser: --- Mobile Platform: --- I would like to use the NavigationTiming tables to make a dashboard of image loading speeds by filtering on the action, anon and namespace fields (the patch is at https://gerrit.wikimedia.org/r/#/c/148021 ) which will probably be slow without indexes on the relevant columns. (I don't need it, but in general event_isHttps also seems like a good candidate for an index.) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l