Canonical work items unfunded ≥3 periods

Details

query_kind: sql
severity_default: critical
recommended_action_template: {n} canonical work items have gone unfunded for ≥3 consecutive allocation periods. Re-review their EV scores or adjust the LLM cap via senate.resource.budget. First items: {refs[:5]}.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

WITH recent_allocations AS (
  SELECT content
  FROM artifacts
  WHERE artifact_type = 'resource_allocation'
    AND is_latest = 1
  ORDER BY created_at DESC
  LIMIT 3
),
funded_refs AS (
  SELECT DISTINCT (alloc->>'target_ref') AS ref
  FROM recent_allocations ra,
       LATERAL jsonb_array_elements(
         COALESCE(ra.content->'allocations', '[]'::jsonb)
       ) AS alloc
)
SELECT a.id::text AS ref, a.title
FROM artifacts a
WHERE a.lifecycle_state = 'canonical'
  AND a.is_latest = 1
  AND a.artifact_type IN ('task', 'hypothesis', 'knowledge_gap',
                          'gap', 'mission', 'challenge')
  AND a.id NOT IN (
    SELECT ref FROM funded_refs WHERE ref IS NOT NULL
  )
  AND COALESCE(a.lifecycle_state, '') = 'canonical'

query_params

{}

threshold

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

Canonical work items unfunded ≥3 periods

Details

Replication

Discussion