Tier-stalled T3 artifacts (no T4 promotion in 90d)

Details

query_kind: sql
severity_default: info
recommended_action_template: {n} artifact(s) have been at T3 for >90 days with no T4 promotion attempt. Review reproduction attestation and evidence trust scores for T4 eligibility. First items: {refs[:5]}.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

SELECT a.id::text AS ref, a.title
FROM artifacts a
WHERE a.epistemic_tier = 'T3'
  AND a.is_latest = 1
  AND COALESCE(
    (
      SELECT MAX(tt.proposed_at)
      FROM tier_transitions tt
      WHERE tt.artifact_ref = a.id::text
        AND tt.to_tier = 'T3'
    ),
    a.created_at
  ) < NOW() - INTERVAL '90 days'
  AND NOT EXISTS (
    SELECT 1 FROM tier_transitions tt2
    WHERE tt2.artifact_ref = a.id::text
      AND tt2.to_tier = 'T4'
  )

query_params

{}

threshold

{
  "warning_at": 1,
  "critical_at": 50
}

Tier-stalled T3 artifacts (no T4 promotion in 90d)

Details

Replication

Discussion