2026-10-14 20:06 UTC
@jaz@toot.wales Also sometimes use this to find out who most media in the cache is from:
select sum(m.file_file_size)/1024/1024 as media_size_mb, a.domain, a.username
from media_attachments m, accounts a
where m.file_file_name is not null and m.account_id=a.id and a.domain is not null
group by a.username, a.domain order by media_size_mb desc limit 10;
(change to "a.domain is null" for local users)
Replies (0)
No replies.