I noticed that one day had significantly (like, 10x) more posts recorded in the last month on the admin panel and dug into it as we need to report such stats and would be asked what had caused it.
This is the output from the forum DB:
post_type | count
1 | 94
2 | 12
3 | 935
It looks like type 3 is causing the issue here but I’m not sure what that is.
I’ve checked and it really doesn’t look like there were a gazillion posts on that day, but if I can figure out what post_type 3 is then we can maybe work out what’s causing the issue. For now, I’ve just used 106 as the number of posts (ie excluding type 3 entirely) but ideally I’d have more confidence on that decision!
Edited to add
Just found this:
I think system actions probably ought not to be counted in posts? Unsure about mod actions either really… Maybe only regular posts should be counted for the post count?