Follow
big SQL query
I just wrote an SQL query to find which accounts use the most storage space:
select * from (
select accounts.username, accounts.domain, sum(media_attachments.file_file_size) as media_size
from media_attachments
inner join accounts on (media_attachments.account_id=accounts.id)
group by accounts.id order by media_size desc
) as t
where t.media_size is not null
limit 10;
to run it: "su postgres", then "psql mastodon_production", then type it in the shell
