Thought it'd be useful or at least somewhat interesting to run the numbers just to visualize the scale of the queue.
All the following numbers are based on the range id:6850000.. id:..8400000
Reason being that this is just over a years worth (368 days) of posts counting back from today, and using date ranges gets a bit fuzzy because of timezones.
Note that the numbers can shift a little bit after this post because of changes in post status but they should still be in the correct range.
First of all, while there should be 1550000 entries between these two points, id:6850000.. id:..8400000 status:any only returns 1547430. This probably is because of permadeleted entries, 2570 of them. But this is less than 0.2% of the data which shouldn't matter too much. So we can just continue.
ACTIVE | | | DELETED
| | |
| +-------V-------+ |
| | INCOMING | |
| +---------------+ |
ACTIVE | | 1547430 posts | | DELETED
| | 4205.0 / day | |
| | 100 % | |
| +-------+-------+ |
| | |
Now Contributors+ have the option to bypass the queue which has happened to about 946289 posts and are still active to this day without any flags. I'll get back to FLAG IN QUEUE in a moment.
| | |
ACTIVE | | | DELETED
| +--------------+ | |
| | CONTRIBUTOR+ | | +-------+ |
| +--------------+ | |FLAG IN| |
<---+ 946289 posts |<---+----------->| QUEUE | |
ACTIVE | | 2571.4 / day | | +-------+ | DELETED
| | 61.2 % | | |
| +--------------+ | |
Now we get to the first moderation queue. These are posts that go through the queue and are either accepted or rejected after three days.
515888 posts were approved and 66503 posts were unapproved. We can then add these together to calculate the size of the FIRST QUEUE.
| | |
ACTIVE | +------V-------+ | DELETED
| | FIRST QUEUE | |
| +--------------+ |
| | 582391 posts | |
| | 1582.6 / day | |
ACTIVE | | 37.6 % | | DELETED
| +---+------+---+ |
| | | |
| +--------------+ | | +-------------+ |
| | APPROVED | | | | THREE DAYS | |
ACTIVE | +--------------+ | | +-------------+ | DELETED
<--+ 515888 posts |<-+ +->| 66503 posts +--->
| | 1401.9 / day | | 180.7 / day | |
| | 33.3 % | | 4.3 % | |
| +--------------+ +-------------+ |
Now we get to the APPEAL QUEUE where deleted posts get a second chance. Note that posts that have been appealed multiple times count per appeal. *cough*
There have been 22681 appeals (1134 pages of 20 + 1). 11009 posts were accepted, 11672 were again deleted.
| |
| +--------------+ |
| | APPEAL QUEUE | |
| +--------------+<---------------+
ACTIVE | | 22681 posts | | DELETED
| | 61.6 / day | |
| | 1.5 % | |
| +---+------+---+ |
| | | |
ACTIVE | +-------------+ | | +-------------+ | DELETED
| | SUCCEEDED | | | | REJECTED | |
| +-------------+ | | +-------------+ |
<---+ 11009 posts |<-+ +->| 11672 posts +--->
| | 29.9 / day | | 31.7 / day | |
ACTIVE | | 0.7 % | | 0.8 % | | DELETED
| +-------------+ +-------------+ |
| |
Now the FLAG QUEUE where posts are checked again. Note that posts that have been flagged multiple times are counted per flag.
This is where FLAG IN QUEUE comes back. I cannot differentiate between posts that have bypassed the queue and were then flagged, and posts that were flagged in the queue before they reached the 3 day mark (like AI uploads and super trash) because there is no way to filter by userlevel of the uploader, so I'll have to combine them here.
There have been 8963 flags in this period. 6960 posts were deleted after the flag. 1979 were reapproved after the flag. And a few are currently pending at this moment, so they are excluded which is why the numbers don't add up precisely.
| |
| +------------+ |
ACTIVE | | FLAG QUEUE | | DELETED
| +------------+ |
+---------+------>| 8962 posts | |
| | | 24.4 / day | |
| +---+---+ | 0.6 % | |
ACTIVE | |FLAG IN| +--+------+--+ | DELETED
| | QUEUE | | | |
| +-------+ | | |
| | | |
| +------------+ | | +------------+ |
ACTIVE | | REJECTED | | | | SUCCEEDED | | DELETED
| +------------+ | | +------------+ |
<---+ 1979 posts |<--+ +-->| 6960 posts +--->
| | 5.4 / day | | 18.9 / day | |
| | 0.1 % | | 0.4 % | |
ACTIVE | +------------+ +------------+ | DELETED
Adding the numbers of the queues together, and we get 614034 posts that passed through a queue in some way with multiple flag/appeal instances counting separately.
This comes to 1668.6 posts per day.
For a worst case scenario: assume that our 71 approvers have to do all the queue cleaning work without the help of moderators/admins/evazion. That results in 23.5 posts per person per day.