[Wikidata-bugs] [Maniphest] T274407: Retrieve metric "Median time of loading the Wikidata item and property data from Wikidata database"

[Silvan_WMDE]

Silvan_WMDE added a comment.


    SELECT
      percentile_approx(time_firstbyte, 0.5) as median_time
    FROM
      wmf.webrequest
    WHERE
      uri_host = 'www.wikidata.org'
      AND namespace_id IN (0,120)
      AND http_status = 200
      AND is_pageview = TRUE
      AND cache_status = 'miss'
      AND year = 2021
      AND month = 5
      AND day = 3
      AND hour = 13;

TASK DETAIL
  https://phabricator.wikimedia.org/T274407

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Silvan_WMDE
Cc: Aklapper, darthmon_wmde, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, Manuel, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Mbch331

_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org