Evolution of review time over time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Show how long reviews take on average, sorted by review type. The review durations are averaged over a calendar week and shown in minutes. WARNING: this query is probably buggy! http://data.stackexchange.com/cs/query/199807/suggested-edit-weekly-statistics has a more correct-looking query for suggested edits only.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  Convert(varchar(10), DateAdd(Day, Coalesce(SE.week, Closure.week) * 7, '1900-01-01'), 126) AS [Week from],
  Count(SE.duration) AS [#SE],
  Round(Avg(SE.duration / 60.0), 1) AS [ΔSE],
  Count(Closure.duration) AS [#Close],
  Round(Avg(Closure.duration / 60.0), 1) AS [ΔClose]
FROM (
  SELECT
    DateDiff(Day, 0, RT.CreationDate) / 7 AS [week],
    DateDiff(Second, RT.CreationDate, RT.DeletionDate) AS [duration]
  FROM ReviewTasks RT
  WHERE RT.ReviewTaskTypeId = 1
) SE
FULL OUTER JOIN (
  SELECT
    DateDiff(Day, 0, RT.CreationDate) / 7 AS [week],
    DateDiff(Second, RT.CreationDate, RT.DeletionDate) AS [duration]
  FROM ReviewTasks RT
  WHERE RT.ReviewTaskTypeId = 2
) Closure ON Closure.week = SE.week
GROUP BY Coalesce(SE.week, Closure.week)
ORDER BY [Week from] ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results