nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpq2f7r2gjj0ch84wdh5kg03gkmjyskya6zlxq70cxlk5qm5sysjhuq9wjlkz (nprofile…jlkz) It would be helpful to know which tables are using the most space here.
`tootctl accounts cull` and `toolctl statuses remove` should help here I guess.
Also you should do a `VACUUM FULL` on the tables after any cleanup, as pg will not reclaim the used space.
I would love to have equivalents to those commands in scheduled jobs within Mastodon, but this requires making them much more robust to be able to do it confidently in an automatic manner
nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqq6t97anxs8daua93npvy4kua7kpxaxfqcqgxhgd7p88hw705aqts29a8ww (nprofile…a8ww)
Renaud Chaput
npub1qw…hwsmk
2026-07-09 19:48:11 UTC
in reply to nevent1q…c7ys
Author Public Key
npub1qwpfjy8caugpj782cv45tmx2gdjn47jky6m0mkpruy3zr4llu4jsahwsmkSeen on
wss://relay.ditto.pubPublished at
2026-07-09 19:48:11 UTCEvent JSON
{
"id": "a14e512c5bc631b45cf6d97e796b860ef313f873b028f0dfd29e2077b52f8526",
"pubkey": "03829910f8ef101978eac32b45ecca43653afa5626b6fdd823e12221d7ffe565",
"created_at": 1783626491,
"kind": 1,
"tags": [
[
"p",
"527c3522527e2e7ab9b7a590f8a2db9121627742f981e7e0dfb501ba409095f8",
"wss://relay.ditto.pub"
],
[
"p",
"06965f766681dbde74b198584adb9df5826e9920c0106ba1be09cf7779f4e817",
"wss://relay.ditto.pub"
],
[
"p",
"155c7af498274a045ba66b5bc073ed110382fed7401a11e2334ce3b749dc8629",
"wss://relay.ditto.pub"
],
[
"p",
"6bb7e8dec6c76009a0223b99b2430c5ca3e8f2a265555efdf1a8f4b4dc2bfa8e",
"wss://relay.ditto.pub"
],
[
"e",
"3ba24b3289e3e23b4b9ffeb99322e7b30763c419e6fc049cc95525c115437cd3",
"wss://relay.ditto.pub",
"reply"
],
[
"proxy",
"https://oisaur.com/users/renchap/statuses/116891745733363457",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpq2f7r2gjj0ch84wdh5kg03gkmjyskya6zlxq70cxlk5qm5sysjhuq9wjlkz It would be helpful to know which tables are using the most space here. \n\n`tootctl accounts cull` and `toolctl statuses remove` should help here I guess.\n\nAlso you should do a `VACUUM FULL` on the tables after any cleanup, as pg will not reclaim the used space.\n\nI would love to have equivalents to those commands in scheduled jobs within Mastodon, but this requires making them much more robust to be able to do it confidently in an automatic manner\n\nnostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqq6t97anxs8daua93npvy4kua7kpxaxfqcqgxhgd7p88hw705aqts29a8ww",
"sig": "7f63dd7c80707c0c4c80eb86796a331998cd61855409dcd560f3e66f0ef834f2406b23ad15f92670a1bcddc50ff8848ae457725445fc440ee98354e71a9eb24d"
}