Create
Query
event_store.db
—
artifacts
actions
approvals
artifacts
commitments
constraints
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row art_reliability_slo_report_2026-04-03 in artifacts
id
art_reliability_slo_report_2026-04-03
Primary key.
TEXT
kind
reliability_slo_report
TEXT NOT NULL
status
ready
TEXT NOT NULL
title
Reliability SLO Report
TEXT
summary
Reliability severity: high
TEXT
meta
{"day":"2026-04-03","doctrine":"opia_executive_reliability","source":"observability"}
TEXT
output_json
{"alerts": [{"due_now": 19, "grace_m": 5.0, "level": "warn", "overdue": 19, "remediation": "Operational queues have overdue work; restore throughput and reduce stuck work units.", "type": "queue_overdue"}, {"level": "critical", "overdue": 19, "remediation": "Queue wait time is elevated; inspect backpressure, concurrency, and lease contention.", "type": "queue_wait_p95", "wait_m_p95": 466.8}], "approvals": {}, "as_of": "2026-04-03T10:34:35.128767+00:00", "deliveries": {}, "jobs": {"done": 8, "leased": 2, "queued": 19}, "llm_usage_24h": {"input_tokens": 0, "models": [], "output_tokens": 0, "priced_calls": 0, "since_iso": "2026-04-02T10:34:34.982788+00:00", "total_calls": 0, "total_cost_usd": 0.0, "total_tokens": 0, "unpriced_calls": 0, "unpriced_ratio": 0.0}, "llm_value_24h": {"economics": {"cost_per_outcome_usd": 0.0, "cost_per_quality_adjusted_outcome_usd": 0.0, "outcomes_per_usd": null, "quality_adjusted_outcomes_per_usd": null}, "governance": {"context_trim_rate": 0.0, "context_trimmed_calls": 0, "coverage": 0.0, "governed_calls": 0, "model_reroute_rate": 0.0, "model_rerouted_calls": 0, "output_cap_rate": 0.0, "output_capped_calls": 0}, "llm_calls": 0, "outcomes": {"action_applied": 0, "artifact_ready": 1, "pending_resolved": 0, "quality_adjusted_total": 1, "total": 1}, "quality": {"incident_rate": 0.0, "incidents": 0}, "since_iso": "2026-04-02T10:34:34.982788+00:00", "total_cost_usd": 0.0}, "reducer_lag": {"cursors": [{"cursor": 2, "lag": 0, "max_pos": 2, "reducer": "memory_ingest:default", "stream": "events", "updated_at": "2026-04-03T10:34:18.966Z"}], "ignored_reducers": ["relationship_autoclose_v1"], "max": {"events": 2, "signals": 0}}, "reliability_slo": {"approval_execution": {"latency_m_p50": null, "latency_m_p95": null, "pending_after_approval": 0, "terminal_count": 0}, "approvals": {"decided": 0, "latency_m_p50": null, "latency_m_p95": null}, "as_of": "2026-04-03T10:34:34.982788+00:00", "core_jobs": {"dead": 0, "dead_letter_rate": 0.0, "done": 0, "failed": 0, "job_types": ["episode_route", "context_build", "cognition_think", "proposal_materialize", "execute_actions"], "terminal_count": 0}, "dead_letters": 0, "execution": {"applied": 0, "failed": 0, "latency_m_p50": null, "latency_m_p95": null, "success_rate": 1.0, "terminal_count": 0}, "llm_failures": 0, "memory_repair": {"comparison_history_windows": 3, "comparison_since": "2026-04-01T10:34:34.982788+00:00", "comparison_until": "2026-04-02T10:34:34.982788+00:00", "comparison_window_h": 24, "hotspot_max_delta": 0, "hotspot_new_count": 0, "hotspot_previous_history_ready": false, "hotspot_previous_history_window_pair_counts": {"pre_previous_pairs": 0, "previous_pairs": 0}, "hotspot_previous_max_delta": 0, "hotspot_previous_new_count": 0, "hotspot_previous_streak_consistent_reason_count": 0, "hotspot_previous_streak_count": 0, "hotspot_previous_streak_history_ready": false, "hotspot_previous_streak_history_window_pair_counts": {"pre_pre_previous_pairs": 0, "pre_previous_pairs": 0, "previous_pairs": 0}, "hotspot_previous_streak_max_delta": 0, "hotspot_previous_streaks": [], "hotspot_previous_trends": [], "hotspot_previous_worsening_count": 0, "hotspot_recoveries": [], "hotspot_recovery_count": 0, "hotspot_recovery_max_delta": 0, "hotspot_recovery_to_zero_count": 0, "hotspot_streak_consistent_reason_count": 0, "hotspot_streak_count": 0, "hotspot_streak_max_delta": 0, "hotspot_streaks": [], "hotspot_trends": [], "hotspot_worsening_count": 0, "hotspots": [], "pre_comparison_since": "2026-03-31T10:34:34.982788+00:00", "pre_pre_comparison_since": "2026-03-30T10:34:34.982788+00:00", "queued": 0, "suppressed": 0, "suppressed_without_queue": 0, "suppression_rate": 0.0, "suppression_reasons": {}, "total_decisions": 0, "zero_queue_risk": false}, "pending": {"created": 0, "latency_m_p50": null, "latency_m_p95": null, "resolution_rate": 1.0, "resolved": 0}, "queue": {"due_now": 19, "due_now_wait_m_p50": 466.8, "due_now_wait_m_p95": 466.8, "overdue": 19, "overdue_grace_m": 5.0, "overdue_wait_m_p50": 466.8, "overdue_wait_m_p95": 466.8, "queued": 19}, "since": "2026-04-02T10:34:34.982788+00:00", "window_h": 24}, "severity": "high", "signals": {"available_types": 0, "expected_count": 20, "expected_types": ["market_prices_snapshot", "market_headlines_snapshot", "news_headline_delta", "macro_prices_snapshot", "macro_yield_curve_snapshot", "geopolitics_events_snapshot", "real_estate_listing_delta", "real_estate_macro_delta", "market_weekly_movers_snapshot", "market_monthly_movers_snapshot", "discovery_ipo_snapshot", "discovery_new_listings_snapshot", "discovery_unusual_volume_snapshot", "discovery_options_flow_snapshot", "discovery_sector_rotation_snapshot", "discovery_crypto_extremes_snapshot", "discovery_sec_filings_snapshot", "discovery_earnings_calendar_snapshot", "real_estate_discovery_snapshot", "technical_indicator_signal"], "latest_at": null, "max_age_h": null, "missing_count": 20, "missing_fraction": 1.0, "types": {"discovery_crypto_extremes_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_earnings_calendar_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_ipo_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_new_listings_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_options_flow_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_sec_filings_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_sector_rotation_snapshot": {"age_h": null, "last_at": null, "present": false}, "discovery_unusual_volume_snapshot": {"age_h": null, "last_at": null, "present": false}, "geopolitics_events_snapshot": {"age_h": null, "last_at": null, "present": false}, "macro_prices_snapshot": {"age_h": null, "last_at": null, "present": false}, "macro_yield_curve_snapshot": {"age_h": null, "last_at": null, "present": false}, "market_headlines_snapshot": {"age_h": null, "last_at": null, "present": false}, "market_monthly_movers_snapshot": {"age_h": null, "last_at": null, "present": false}, "market_prices_snapshot": {"age_h": null, "last_at": null, "present": false}, "market_weekly_movers_snapshot": {"age_h": null, "last_at": null, "present": false}, "news_headline_delta": {"age_h": null, "last_at": null, "present": false}, "real_estate_discovery_snapshot": {"age_h": null, "last_at": null, "present": false}, "real_estate_listing_delta": {"age_h": null, "last_at": null, "present": false}, "real_estate_macro_delta": {"age_h": null, "last_at": null, "present": false}, "technical_indicator_signal": {"age_h": null, "last_at": null, "present": false}}}, "sources": {}, "window_h": 24}
TEXT
output_mrkdwn
NULL
TEXT
evidence_event_ids
[]
TEXT
confidence
REAL
episode_id
NULL
TEXT
thread_id
NULL
TEXT
error
NULL
TEXT
attempt_count
INTEGER (default 0
created_at
2026-04-03T10:34:35.128767+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
updated_at
2026-04-03T10:34:35.128767+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
claimed_at
NULL
TEXT
claim_id
NULL
TEXT
ready_at
2026-04-03T10:34:35.128767+00:00
TEXT
discarded_at
NULL
TEXT
Update
Cancel