Back

弊ぼっちに配送していただいているポストの遅延のサーバごとの中央値です。misskey.ioさんからは現状11時間弱とのこと。
https://data.heroku.com/dataclips/cwobvrrnubmzdovlnddwrtavhjts

WITH delays AS (
SELECT
CONCAT('https://', substring(uri from '.*://([^/]*)'), '/') AS server,
EXTRACT(EPOCH FROM updated_at) - EXTRACT(EPOCH FROM created_at) AS delay
FROM statuses
WHERE updated_at > now() - interval '1 hour' AND NOT local
)
SELECT
server,
ROUND(CAST(percentile_disc(0.5) within GROUP (ORDER BY delay) AS NUMERIC), 2) as median_delay_sec,
COUNT(1) as posts
FROM delays
GROUP BY server HAVING COUNT(1) > 2
ORDER BY median_delay_sec DESC;