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

Reply via email to