ステージングアプリのMiniプランのHeroku Postgresがいっぱいになりつつあるから昔のポスト消してみるね。
$ heroku pg:info
=== DATABASE_URL
Plan: Mini
Status: Available
Connections: 2/20
PG Version: 13.9
Created: 2021-11-23 02:52 UTC
Data Size: 18.0 MB/1.00 GB (In compliance)
Tables: 93
Rows: 8052/10000 (In compliance, close to row limit)
Fork/Follow: Unsupported
Rollback: Unsupported
Continuous Protection: Off
Add-on: postgresql-crystalline-90176
$ heroku run tootctl statuses remove
https://docs.joinmastodon.org/admin/tootctl/#statuses-remove
1個!?
Creating temporary database indices...
Extract the deletion target from statuses... This might take a while...
Removing temporary database indices to restore write performance...
Beginning statuses removal... This might take a while...
:
Done after 0.0806269645690918s, removed 1 out of 1 statuses.
Removing temporary database indices to restore write performance...
Run ANALYZE to statuses...
Beginning removal of now-orphaned media attachments to free up disk space...
:
Done after 0.010893106460571289s, removed 0 out of 0 media_attachments.
Creating temporary database indices...
Extract the deletion target from conversations... This might take a while...
Removing temporary database indices to restore write performance...
Beginning orphans removal... This might take a while...
:
Done after 0.0427398681640625s, removed 0 out of 0 conversations.
Removing temporary database indices to restore write performance...
Run ANALYZE to conversations...
$ heroku run tootctl statuses remove --days 30
:
Done after 0.10664033889770508s, removed 0 out of 0 statuses.
あー。リモートしか消さないのかな？
ドキュメントにunreferncedのものを消すって書いてあるね。