Function count_needing_attention 

pub async fn count_needing_attention(
    conn: &mut PgConnection,
    thresholds: &StuckThresholds,
    too_many_attempts: i32,
) -> ModelResult<Option<AttentionRegistration>>

The whole queue’s totals: how many rows need a human, and how many of them each detector picked.

The canonical “needs a human” count. Every surface that shows one — the Overview tile, the tab badge, the Errors queue — reads this, so none can disagree. None when the queue is empty.