Elektrine lite

← Feed

@galaxis@mastodon.infra.de

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.