> WITH deliveries AS (
SELECT
id, (updated_at - created_at) as delay,
text,
uri,
substring(uri from '.*://([^/]*)') as host
FROM statuses
WHERE
uri IS NOT NULL AND
updated_at > current_timestamp + '-1 hour'
)
SELECT delay, uri FROM deliveries WHERE host = 'mastodon.zunda.ninja'
ORDER BY delay DESC LIMIT 1;
delay | 00:38:30.788266
uri | https://mastodon.zunda.ninja/users/zundan/statuses/100404194581416397
ブーストとかファボかでupdated_atが更新されるんだな、きっと。