hot_rank: 1728,
hot_rank_active: 1728,
-- Note: 1728 is the result of the hot_rank function, with a score of 1, posted now
-- hot_rank = 10000*log10(1 + 3)/Power(2, 1.8)
lemmy@lemmy_alpha LOG: duration: 50.220 ms execute : WITH batch AS (SELECT a.id
FROM post_aggregates a
WHERE a.published > $1 AND (a.hot_rank != 0 OR a.hot_rank_active != 0)
ORDER BY a.published
LIMIT $2
FOR UPDATE SKIP LOCKED)
UPDATE post_aggregates a SET hot_rank = hot_rank(a.score, a.published),
hot_rank_active = hot_rank(a.score, a.newest_comment_time_necro)
FROM batch WHERE a.id = batch.id RETURNING a.published;
2023-08-18 09:00:34.578 MST [1877420] lemmy@lemmy_alpha DETAIL:
parameters: $1 = '2023-08-16 23:40:31.149267', $2 = '1000'
Difference between hot_rank and hot_rank_active