diff options
| -rw-r--r-- | src/bot.rs | 20 | ||||
| -rw-r--r-- | src/db/mod.rs | 4 |
2 files changed, 16 insertions, 8 deletions
@@ -502,7 +502,7 @@ pub async fn run() -> anyhow::Result<()> { loop { ticker.tick().await; - tracing::debug!("running songbird info gc"); + tracing::trace!("running songbird info gc"); let Some(songbird) = ({ let data = client_data.read().await; @@ -535,11 +535,19 @@ pub async fn run() -> anyhow::Result<()> { result }); - tracing::debug!( - queued_tracks = active_uuids.len(), - n_gced = n_removed, - "songbird info gc done" - ); + if n_removed > 0 { + tracing::debug!( + queued_tracks = active_uuids.len(), + n_gced = n_removed, + "songbird info gc done" + ); + } else { + tracing::trace!( + queued_tracks = active_uuids.len(), + n_gced = n_removed, + "songbird info gc done" + ); + } } }); diff --git a/src/db/mod.rs b/src/db/mod.rs index a8d66e5..56a8190 100644 --- a/src/db/mod.rs +++ b/src/db/mod.rs @@ -340,12 +340,12 @@ pub async fn rare_meme( FROM meme_count RIGHT JOIN memes ON memes.id = meme_count.meme_id INNER JOIN metadata ON metadata.id = memes.metadata_id - WHERE memes.guild = $3 AND ((memes.audio_id IS NULL) = $1 OR $2) + WHERE (memes.audio_id IS NULL) = $1 OR $2 ), least_used AS ( SELECT meme_id, - TRUNC(time_diff / (ct + 1)) as play_prop + (TRUNC(time_diff / (ct + 1))::double precision) as play_prop FROM aggregate ) SELECT |