How to handle a user asking for 2FA reset? (Email sent by their correct @gmail address and is DKIM-signed by gmail.)

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

I recently upgraded my Mastodon instance to Debian Buster, so I now have both pgsql 9.6 and 11 installed. (Currently, Mastodon still uses 9.6.)
Which one should I use (and why)?

To all instance admins: you should suspend the instance pleroma.rareome.ga, it advertises itself as leaking private messages.

(CW n-word on that link and the image) pleroma.rareome.ga/notice/5511

Octodon

oc.todon.fr is a mostly French-speaking Mastodon instance with an active moderation. oc.todon.fr est une instance Mastodon principalement francophone et avec une modération active.