For anyone who might find it useful, here's some stats on the note (posts) table from two real-world Sharkey instances:
Instance A (3 years old, 12 users (2 active), 472 pub and 491 sub connections):
+---------------+------------+--------+------------------------------+
|Metric |Value |Percent |Metric |
+---------------+------------+--------+------------------------------+
|total | 25,326,479| 100.00%|All notes |
|isSilencedUser | 604,310| 2.39%|Notes by a silenced user |
|isSilencedHost | 2,940,100| 11.61%|Notes from a silenced instance|
|isSuspendedUser| 282,627| 1.12%|Notes by a suspended user |
|isSuspendedHost| 85,733| 0.34%|Notes from a blocked instance |
|isPublic | 11,910,305| 47.03%|Public notes |
|isHome | 10,244,218| 40.45%|Home-only / unlisted notes |
|isFollowers | 3,155,757| 12.46%|Followers-only notes |
|isSpecified | 16,199| 0.06%|Specified / DM notes |
|isPoll | 53,258| 0.21%|Polls |
|isMedia | 2,382,441| 9.41%|Notes w/ media |
|isReply | 9,541,477| 37.67%|Replies |
|isReplyToSelf | 2,058,518| 8.13%|Self-replies |
|isBoost | 6,192,622| 24.45%|Boosts |
|isBoostOfSelf | 190,660| 0.75%|Self-boosts |
|isQuote | 225,201| 0.89%|Quotes |
|isQuoteOfSelf | 70,205| 0.28%|Self-quotes |
|isChannel | 2| 0.00%|Notes in a channel |
|isRemote | 25,259,313| 99.73%|Remote notes |
|isLocal | 67,166| 0.27%|Local notes |
|isLocalOnly | 311| 0.00%|Local-only (defederated) notes|
+---------------+------------+--------+------------------------------+
Instance B (3 years old, 2,731 users (130 active), 1,872 pub and 2,149 sub connections):
+---------------+------------+--------+------------------------------+
|Metric |Value |Percent |Metric |
+---------------+------------+--------+------------------------------+
|total | 87,276,701| 100.00%|All notes |
|isSilencedUser | 1,018,657| 1.17%|Notes by a silenced user |
|isSilencedHost | 13,408,299| 15.36%|Notes from a silenced instance|
|isSuspendedUser| 414,901| 0.48%|Notes by a suspended user |
|isSuspendedHost| 819,842| 0.94%|Notes from a blocked instance |
|isPublic | 40,977,139| 46.95%|Public notes |
|isHome | 28,991,756| 33.22%|Home-only / unlisted notes |
|isFollowers | 17,205,922| 19.71%|Followers-only notes |
|isSpecified | 101,884| 0.12%|Specified / DM notes |
|isPoll | 298,023| 0.34%|Polls |
|isMedia | 9,727,324| 11.15%|Notes w/ media |
|isReply | 26,004,182| 29.80%|Replies |
|isReplyToSelf | 5,551,978| 6.36%|Self-replies |
|isBoost | 32,734,600| 37.51%|Boosts |
|isBoostOfSelf | 577,841| 0.66%|Self-boosts |
|isQuote | 398,429| 0.46%|Quotes |
|isQuoteOfSelf | 133,203| 0.15%|Self-quotes |
|isChannel | 34| 0.00%|Notes in a channel |
|isRemote | 86,199,472| 98.77%|Remote notes |
|isLocal | 1,077,229| 1.23%|Local notes |
|isLocalOnly | 2,009| 0.00%|Local-only (defederated) notes|
+---------------+------------+--------+------------------------------+
#FediDev #Fedi #ActivityPub #AP #Sharkey
