Show us how many posts are in our filtered Review Queues?

Question

I was thinking about some of the things said in this post regarding the Close View Queue size and how so many questions seem surmountable. You've already given us a way to break down that queue into smaller chunks by allowing us to filter it, but we have no idea if the section we're trying to "clean up" is 3 posts or 30,000.

Could you add a number somewhere to the Review screen showing us how many posts there are to review in our filtered Review Queue?

(Ideally, a date range filter option would be nice too, to allow us to further break down the queue into manageable sizes for a single person to clear on their own)

Edit: Based on the success and some of the comments on this event when the Close Vote Queue was temporarily reduced in size and a post created to list the top Tags and Count of posts, I think this would help increase participation of reviewers in the Close Vote Queue a lot.

Answer 1

I don't think you can call me a credible or official source but if you skip that I have an answer that shows that you can partly already achieve what you want.

On the DataExplorer we have Posts, Tags and Votes, including close votes (VoteTypeId=6). I created this query

select t.tagname , count(*) as cnt
from votes v
inner join posts p on p.id = v.postid
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where votetypeid = 6
and p.closeddate is null
-- and p.LastEditDate between '2014-01-01' and '2014-02-28'
group by t.tagname
order by 2 desc

that returns for each tag the number of close votes.

I commented out a line for restricting the results on editdates of the post to give you an idea how you could take dates into account.

Do notice that this query can't differentiate on the close vote reasons used in the filter (like off-topic, Too Broad etc) because that data only becomes available in SEDE as soon as the post is closed.

The SE DataExplorer is refreshed every monday at 03:00 UTC so at worst the counts you are looking at are 7 days old.