After a few months, the Close Votes queue's large backlog is slowly climbing down, but in the short term we still see regular upward spikes.
I'm curious, when it reaches a manageable size, how manageable will it probably be? Will it ever reach a manageable size?
I ran a naïve-and-slow-as-hell query on the Data Explorer. It tries to fetch the daily amount of questions in and out of the queue, and shows that the number of questions entering the queue each day is usually larger than the number of closed questions on the same day. That means the queue would never empty.
But my query does not account for close vote aging, or questions leaving the queue for gathering enough "do not close" votes. I'm not even sure that data is available on SEDE. So my conclusion is probably not true.
Does anyone have reliable statistics on that?