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-04 in artifacts
id
art_reliability_slo_report_2026-04-04
Primary key.
TEXT
kind
reliability_slo_report
TEXT NOT NULL
status
ready
TEXT NOT NULL
title
Reliability SLO Report
TEXT
summary
Reliability severity: medium
TEXT
meta
{"day":"2026-04-04","doctrine":"opia_executive_reliability","source":"observability"}
TEXT
output_json
{"alerts": [{"count": 2, "level": "warn", "remediation": "Connected sources are degraded or unauthenticated; repair credentials and reduce dependency blast radius.", "type": "sources_error"}], "approvals": {"applied": 1, "rejected": 2}, "as_of": "2026-04-04T00:00:18.223421+00:00", "deliveries": {"sending": 2, "sent": 78}, "jobs": {"done": 180, "leased": 2, "queued": 2}, "llm_usage_24h": {"input_tokens": 3368464, "models": [{"calls": 1426, "cost_usd": 0.905632, "input_tokens": 2940230, "model": "gpt-4o-mini", "output_tokens": 774336, "priced_calls": 1426, "total_tokens": 3714566, "unpriced_calls": 0}, {"calls": 610, "cost_usd": 0.297676, "input_tokens": 428234, "model": "gpt-5.4-nano", "output_tokens": 169613, "priced_calls": 610, "total_tokens": 597847, "unpriced_calls": 0}], "output_tokens": 943949, "priced_calls": 2036, "since_iso": "2026-04-03T00:00:17.380816+00:00", "total_calls": 2036, "total_cost_usd": 1.203308, "total_tokens": 4312413, "unpriced_calls": 0, "unpriced_ratio": 0.0}, "llm_value_24h": {"economics": {"cost_per_outcome_usd": 0.005899, "cost_per_quality_adjusted_outcome_usd": 0.005899, "outcomes_per_usd": 169.532655, "quality_adjusted_outcomes_per_usd": 169.532655}, "governance": {"context_trim_rate": 0.5201, "context_trimmed_calls": 1059, "coverage": 1.0, "governed_calls": 2036, "model_reroute_rate": 0.2996, "model_rerouted_calls": 610, "output_cap_rate": 0.9695, "output_capped_calls": 1974}, "llm_calls": 2036, "outcomes": {"action_applied": 5, "artifact_ready": 195, "pending_resolved": 4, "quality_adjusted_total": 204, "total": 204}, "quality": {"incident_rate": 0.0, "incidents": 0}, "since_iso": "2026-04-03T00:00:17.380816+00:00", "total_cost_usd": 1.203308}, "reducer_lag": {"cursors": [{"cursor": 7998, "lag": 61, "max_pos": 8059, "reducer": "memory_ingest:default", "stream": "events", "updated_at": "2026-04-03T23:58:14.991Z"}, {"cursor": 2988, "lag": 47, "max_pos": 3035, "reducer": "opportunity_case_signals_v1", "stream": "signals", "updated_at": "2026-04-03T23:56:45.313Z"}, {"cursor": 8026, "lag": 33, "max_pos": 8059, "reducer": "resolver_v3", "stream": "events", "updated_at": "2026-04-03T23:58:51.349Z"}, {"cursor": 8050, "lag": 9, "max_pos": 8059, "reducer": "portfolio_resolver_v3", "stream": "events", "updated_at": "2026-04-03T23:59:55.550Z"}, {"cursor": 8050, "lag": 9, "max_pos": 8059, "reducer": "email_sender_verification_v2", "stream": "events", "updated_at": "2026-04-03T23:59:52.612Z"}, {"cursor": 8050, "lag": 9, "max_pos": 8059, "reducer": "sms_sender_verification_v1", "stream": "events", "updated_at": "2026-04-03T23:59:41.110Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "entity_reducer_v2_deterministic", "stream": "events", "updated_at": "2026-04-04T00:00:12.780Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "entity_alias_reducer_v2", "stream": "events", "updated_at": "2026-04-04T00:00:12.870Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "event_subjects_reducer_v2", "stream": "events", "updated_at": "2026-04-04T00:00:12.890Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "fact_reducer_v2_deterministic", "stream": "events", "updated_at": "2026-04-04T00:00:12.921Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "signal_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:12.954Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "signal_fp_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:12.976Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "signal_candidate_reducer_v2", "stream": "events", "updated_at": "2026-04-04T00:00:12.994Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "action_reducer_v2", "stream": "events", "updated_at": "2026-04-04T00:00:13.011Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "commitment_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.028Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "constraint_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.044Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "decision_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.061Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "approval_reducer_v2", "stream": "events", "updated_at": "2026-04-04T00:00:13.071Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "episode_reducer_v3", "stream": "events", "updated_at": "2026-04-04T00:00:13.094Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "conversation_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.112Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "watcher_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.127Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "inbox_reducer_v2", "stream": "events", "updated_at": "2026-04-04T00:00:13.158Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "pending_reducer_v6", "stream": "events", "updated_at": "2026-04-04T00:00:13.180Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "reminders_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.199Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "artifact_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.328Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "dead_letter_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.354Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "proposals_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.489Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "email_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.497Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "sms_reducer_v1", "stream": "events", "updated_at": "2026-04-04T00:00:13.504Z"}, {"cursor": 8059, "lag": 0, "max_pos": 8059, "reducer": "inbox_indexer_events_v3", "stream": "events", "updated_at": "2026-04-04T00:00:17.167Z"}, {"cursor": 3035, "lag": 0, "max_pos": 3035, "reducer": "inbox_indexer_signals_v3", "stream": "signals", "updated_at": "2026-04-04T00:00:17.182Z"}], "ignored_reducers": ["relationship_autoclose_v1"], "max": {"events": 8059, "signals": 3035}}, "reliability_slo": {"approval_execution": {"latency_m_p50": 0.05, "latency_m_p95": 0.05, "pending_after_approval": 0, "terminal_count": 1}, "approvals": {"decided": 3, "latency_m_p50": 1.86, "latency_m_p95": 2.41}, "as_of": "2026-04-04T00:00:17.380816+00:00", "core_jobs": {"dead": 0, "dead_letter_rate": 0.0, "done": 74, "failed": 0, "job_types": ["episode_route", "context_build", "cognition_think", "proposal_materialize", "execute_actions"], "terminal_count": 74}, "dead_letters": 2, "execution": {"applied": 5, "failed": 0, "latency_m_p50": 0.08, "latency_m_p95": 0.79, "success_rate": 1.0, "terminal_count": 5}, "llm_failures": 4, "memory_repair": {"comparison_history_windows": 3, "comparison_since": "2026-04-02T00:00:17.380816+00:00", "comparison_until": "2026-04-03T00:00:17.380816+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-04-01T00:00:17.380816+00:00", "pre_pre_comparison_since": "2026-03-31T00:00:17.380816+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": 5, "latency_m_p50": 1.7, "latency_m_p95": 231.85, "resolution_rate": 0.8, "resolved": 4}, "queue": {"due_now": 2, "due_now_wait_m_p50": 0.03, "due_now_wait_m_p95": 0.05, "overdue": 0, "overdue_grace_m": 5.0, "overdue_wait_m_p50": null, "overdue_wait_m_p95": null, "queued": 2}, "since": "2026-04-03T00:00:17.380816+00:00", "window_h": 24}, "severity": "medium", "signals": {"available_types": 14, "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": "2026-04-03T23:57:35.699542+00:00", "max_age_h": 1.0, "missing_count": 6, "missing_fraction": 0.3, "types": {"discovery_crypto_extremes_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_earnings_calendar_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_ipo_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_new_listings_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_options_flow_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_sec_filings_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_sector_rotation_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "discovery_unusual_volume_snapshot": {"age_h": 1.0, "last_at": "2026-04-03T23:00:10.064372+00:00", "present": true}, "geopolitics_events_snapshot": {"age_h": null, "last_at": null, "present": false}, "macro_prices_snapshot": {"age_h": 0.42, "last_at": "2026-04-03T23:35:00.829622+00:00", "present": true}, "macro_yield_curve_snapshot": {"age_h": 0.42, "last_at": "2026-04-03T23:35:00.829622+00:00", "present": true}, "market_headlines_snapshot": {"age_h": 0.39, "last_at": "2026-04-03T23:36:57.001822+00:00", "present": true}, "market_monthly_movers_snapshot": {"age_h": null, "last_at": null, "present": false}, "market_prices_snapshot": {"age_h": 0.04, "last_at": "2026-04-03T23:57:35.699542+00:00", "present": true}, "market_weekly_movers_snapshot": {"age_h": null, "last_at": null, "present": false}, "news_headline_delta": {"age_h": 0.16, "last_at": "2026-04-03T23:50:25.333459+00:00", "present": true}, "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": 0.22, "last_at": "2026-04-03T23:46:57.072156+00:00", "present": true}}}, "sources": {"degraded": 1, "error": 1, "ok": 4}, "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-04T00:00:18.223421+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
updated_at
2026-04-04T00:00:18.223421+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-04T00:00:18.223421+00:00
TEXT
discarded_at
NULL
TEXT
Update
Cancel