下記のをsqlを実行したら過去の負債を消せるかも
未検証
CREATE OR REPLACE FUNCTION public.aid_to_timestamp(aid text) RETURNS timestamptz AS $$
DECLARE
time_part text;
num bigint;
BEGIN
time_part := left(aid, 8);
num := 0;
FOR i IN 1..length(time_part) LOOP
num := num * 36 + strpos('0123456789abcdefghijklmnopqrstuvwxyz', substr(time_part, i, 1)) - 1;
END LOOP;
num := num + 946684800000;
RETURN TO_TIMESTAMP(num / 1000.0);
END;
$$ LANGUAGE plpgsql;
DELETE FROM note
WHERE public.aid_to_timestamp(id) < 'yyyy-mm-dd 00:00:00.000 +0900'
AND "renoteCount" = 0
AND "repliesCount" = 0
AND "reactions" = '{}'
AND "userHost" IS NOT NULL;