RoundSparrow @ BT@bulletintree.comM to Lemmy Project Priorities Observations@bulletintree.com · 1 year ago2023-08-18message-squaremessage-square13fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-square2023-08-18RoundSparrow @ BT@bulletintree.comM to Lemmy Project Priorities Observations@bulletintree.com · 1 year agomessage-square13fedilink
minus-squareRoundSparrow @ BT@bulletintree.comOPMlinkfedilinkarrow-up1·1 year ago hot_rank_now_minus1second_score_250 | current_now -------------------------------------+---------------------------- 6899 | 2023-08-18 19:02:54.807922 (1 row) hot_rank_now_minus1day_score_250 | current_now ----------------------------------+---------------------------- 68 | 2023-08-17 19:02:55.808032 (1 row) hot_rank_now_minus2day_score_250 | current_now ----------------------------------+---------------------------- 21 | 2023-08-16 19:02:55.808132 (1 row) hot_rank_now_minus3day_score_250 | current_now ----------------------------------+--------------------------- 10 | 2023-08-15 19:02:55.80823 (1 row) hot_rank_now_minus6day_score_250 | current_now ----------------------------------+---------------------------- 3 | 2023-08-12 19:02:55.808326 (1 row) hot_rank_now_minus9day_score_250 | current_now ----------------------------------+---------------------------- 1 | 2023-08-09 19:02:55.808419 (1 row) hot_rank_now_minus12day_score_250 | current_now -----------------------------------+---------------------------- 0 | 2023-08-06 19:02:55.808512 (1 row) hot_rank_now_minus22day_score_250 | current_now -----------------------------------+---------------------------- 0 | 2023-07-27 19:02:55.808606 (1 row) from executing this: -- when does hot_rank go flat like old soda? SELECT hot_rank(250::numeric, timezone('utc', now() - interval '1 second')) AS hot_rank_now_minus1second_score_250, timezone('utc', now() - interval '1 second') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '1 day')) AS hot_rank_now_minus1day_score_250, timezone('utc', now() - interval '1 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '2 day')) AS hot_rank_now_minus2day_score_250, timezone('utc', now() - interval '2 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '3 day')) AS hot_rank_now_minus3day_score_250, timezone('utc', now() - interval '3 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '6 day')) AS hot_rank_now_minus6day_score_250, timezone('utc', now() - interval '6 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '9 day')) AS hot_rank_now_minus9day_score_250, timezone('utc', now() - interval '9 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '12 day')) AS hot_rank_now_minus12day_score_250, timezone('utc', now() - interval '12 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '22 day')) AS hot_rank_now_minus22day_score_250, timezone('utc', now() - interval '22 day') AS current_now;
hot_rank_now_minus1second_score_250 | current_now -------------------------------------+---------------------------- 6899 | 2023-08-18 19:02:54.807922 (1 row) hot_rank_now_minus1day_score_250 | current_now ----------------------------------+---------------------------- 68 | 2023-08-17 19:02:55.808032 (1 row) hot_rank_now_minus2day_score_250 | current_now ----------------------------------+---------------------------- 21 | 2023-08-16 19:02:55.808132 (1 row) hot_rank_now_minus3day_score_250 | current_now ----------------------------------+--------------------------- 10 | 2023-08-15 19:02:55.80823 (1 row) hot_rank_now_minus6day_score_250 | current_now ----------------------------------+---------------------------- 3 | 2023-08-12 19:02:55.808326 (1 row) hot_rank_now_minus9day_score_250 | current_now ----------------------------------+---------------------------- 1 | 2023-08-09 19:02:55.808419 (1 row) hot_rank_now_minus12day_score_250 | current_now -----------------------------------+---------------------------- 0 | 2023-08-06 19:02:55.808512 (1 row) hot_rank_now_minus22day_score_250 | current_now -----------------------------------+---------------------------- 0 | 2023-07-27 19:02:55.808606 (1 row)
from
executing this:
-- when does hot_rank go flat like old soda? SELECT hot_rank(250::numeric, timezone('utc', now() - interval '1 second')) AS hot_rank_now_minus1second_score_250, timezone('utc', now() - interval '1 second') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '1 day')) AS hot_rank_now_minus1day_score_250, timezone('utc', now() - interval '1 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '2 day')) AS hot_rank_now_minus2day_score_250, timezone('utc', now() - interval '2 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '3 day')) AS hot_rank_now_minus3day_score_250, timezone('utc', now() - interval '3 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '6 day')) AS hot_rank_now_minus6day_score_250, timezone('utc', now() - interval '6 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '9 day')) AS hot_rank_now_minus9day_score_250, timezone('utc', now() - interval '9 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '12 day')) AS hot_rank_now_minus12day_score_250, timezone('utc', now() - interval '12 day') AS current_now; SELECT hot_rank(250::numeric, timezone('utc', now() - interval '22 day')) AS hot_rank_now_minus22day_score_250, timezone('utc', now() - interval '22 day') AS current_now;