Review Queue statistics

Question

Is there any way that someone can determine the stats for the review queues and how they compare to other sites on the Stack Exchange network? I was wondering about some of the following stats.

1. Amount of items in the queue
2. Amount of items in the queue completed
3. Amount of items that age out of the queue
4. Average time that an item spends in the queue (either to completion or age out)
5. How the site compares for the stats against other sites

I remember seeing something in the past that gave some information on how long items where in the queues but I am unable to find it again.

Answer 1

You can use The Stack Exchange Data Explorer to get those per site statistics. The following query gives you the asked stats for a site.

select rtt.name
     , sum( case 
            when rt.reviewtaskstateid = 1 then 1
            else 0
            end ) as [Active]
     , sum( case 
            when rt.reviewtaskstateid = 2 then 1
            else 0
            end ) as [Completed]
     , sum( case 
            when rt.reviewtaskstateid = 3 then 1
            else 0
            end ) as [Invalidated]
     , min(datediff(hh, creationdate, deletiondate)) as [Minhours]
     , Max(datediff(hh, creationdate, deletiondate)) as [Maxhours]
     , avg(datediff(hh, creationdate, deletiondate)) as [Avghours]
from reviewtasks rt
inner join reviewtasktypes rtt on rtt.id = rt.reviewtasktypeid
group by rtt.name

I'm not sure how you think comparing these against other sites will be useful so I didn't provide an instant solution for that. You can run this query against other sites at will and then make the comparison yourself.

Do know that the SEDE databases are refreshed once per week, on Sunday around 03:00 UTC. At the day of posting for Stack Overflow the results showed this: