SQLite Web: event_store.db

Update row 34428 in events

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"artifact_id":"art_reliability_slo_report_2026-04-07","created_at":"2026-04-07T00:03:17.189697+00:00","kind":"reliability_slo_report","meta":{"day":"2026-04-07","doctrine":"opia_executive_reliability","source":"observability"},"output_json":{"alerts":[{"count":70,"level":"warn","remediation":"Actionable inbox load is high; improve triage throughput and reduce unresolved operational backlog.","type":"inbox_actionable"},{"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-07T00:03:17.189697+00:00","deliveries":{"failed":2,"sending":4,"sent":194},"jobs":{"done":75,"leased":1,"queued":3},"llm_usage_24h":{"input_tokens":3952400,"models":[{"calls":1733,"cost_usd":1.258138,"input_tokens":3554688,"model":"gpt-4o-mini","output_tokens":1208268,"priced_calls":1733,"total_tokens":4762956,"unpriced_calls":0},{"calls":571,"cost_usd":0.304356,"input_tokens":397712,"model":"gpt-5.4-nano","output_tokens":179865,"priced_calls":571,"total_tokens":577577,"unpriced_calls":0}],"output_tokens":1388133,"priced_calls":2304,"since_iso":"2026-04-06T00:03:16.493278+00:00","total_calls":2304,"total_cost_usd":1.562494,"total_tokens":5340533,"unpriced_calls":0,"unpriced_ratio":0.0},"llm_value_24h":{"economics":{"cost_per_outcome_usd":0.004678,"cost_per_quality_adjusted_outcome_usd":0.004678,"outcomes_per_usd":213.760821,"quality_adjusted_outcomes_per_usd":213.760821},"governance":{"context_trim_rate":0.5898,"context_trimmed_calls":1359,"coverage":1.0,"governed_calls":2304,"model_reroute_rate":0.2478,"model_rerouted_calls":571,"output_cap_rate":1.0,"output_capped_calls":2304},"llm_calls":2304,"outcomes":{"action_applied":0,"artifact_ready":334,"pending_resolved":0,"quality_adjusted_total":334,"total":334},"quality":{"incident_rate":0.0,"incidents":0},"since_iso":"2026-04-06T00:03:16.493278+00:00","total_cost_usd":1.562494},"reducer_lag":{"cursors":[{"cursor":13705,"lag":1,"max_pos":13706,"reducer":"opportunity_case_signals_v1","stream":"signals","updated_at":"2026-04-06T23:50:13.857Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"memory_ingest:default","stream":"events","updated_at":"2026-04-07T00:01:19.963Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-07T00:00:24.574Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-07T00:00:24.632Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-07T00:00:24.690Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-07T00:00:24.738Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"signal_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:24.768Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"signal_fp_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:24.804Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"signal_candidate_reducer_v2","stream":"events","updated_at":"2026-04-07T00:00:24.834Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"action_reducer_v2","stream":"events","updated_at":"2026-04-07T00:00:24.888Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"commitment_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:24.925Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"constraint_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:24.930Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"decision_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:24.956Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"approval_reducer_v2","stream":"events","updated_at":"2026-04-07T00:00:25.003Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"episode_reducer_v3","stream":"events","updated_at":"2026-04-07T00:00:25.058Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"conversation_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.092Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"watcher_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.123Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"inbox_reducer_v2","stream":"events","updated_at":"2026-04-07T00:00:25.181Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"pending_reducer_v6","stream":"events","updated_at":"2026-04-07T00:00:25.189Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"reminders_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.196Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"artifact_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.394Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"dead_letter_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.523Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"proposals_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.739Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"email_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.850Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"sms_reducer_v1","stream":"events","updated_at":"2026-04-07T00:00:25.873Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"portfolio_resolver_v3","stream":"events","updated_at":"2026-04-07T00:00:34.676Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"resolver_v3","stream":"events","updated_at":"2026-04-07T00:02:10.424Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"inbox_indexer_events_v3","stream":"events","updated_at":"2026-04-07T00:00:27.636Z"},{"cursor":13706,"lag":0,"max_pos":13706,"reducer":"inbox_indexer_signals_v3","stream":"signals","updated_at":"2026-04-07T00:00:10.588Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"email_sender_verification_v2","stream":"events","updated_at":"2026-04-07T00:00:52.403Z"},{"cursor":34425,"lag":0,"max_pos":34425,"reducer":"sms_sender_verification_v1","stream":"events","updated_at":"2026-04-07T00:00:53.474Z"}],"ignored_reducers":["relationship_autoclose_v1"],"max":{"events":34425,"signals":13706}},"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-07T00:03:16.493278+00:00","core_jobs":{"dead":0,"dead_letter_rate":0.0,"done":1,"failed":0,"job_types":["episode_route","context_build","cognition_think","proposal_materialize","execute_actions"],"terminal_count":1},"dead_letters":1,"execution":{"applied":0,"failed":0,"latency_m_p50":null,"latency_m_p95":null,"success_rate":1.0,"terminal_count":0},"llm_failures":8,"memory_repair":{"comparison_history_windows":3,"comparison_since":"2026-04-05T00:03:16.493278+00:00","comparison_until":"2026-04-06T00:03:16.493278+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-04T00:03:16.493278+00:00","pre_pre_comparison_since":"2026-04-03T00:03:16.493278+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":3,"due_now_wait_m_p50":58.46,"due_now_wait_m_p95":59.78,"overdue":2,"overdue_grace_m":5.0,"overdue_wait_m_p50":58.46,"overdue_wait_m_p95":59.78,"queued":3},"since":"2026-04-06T00:03:16.493278+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-06T23:46:33.826070+00:00","max_age_h":3.35,"missing_count":6,"missing_fraction":0.3,"types":{"discovery_crypto_extremes_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_earnings_calendar_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_ipo_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_new_listings_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_options_flow_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_sec_filings_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_sector_rotation_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"discovery_unusual_volume_snapshot":{"age_h":1.48,"last_at":"2026-04-06T22:34:24.540865+00:00","present":true},"geopolitics_events_snapshot":{"age_h":null,"last_at":null,"present":false},"macro_prices_snapshot":{"age_h":2.22,"last_at":"2026-04-06T21:50:13.543824+00:00","present":true},"macro_yield_curve_snapshot":{"age_h":0.28,"last_at":"2026-04-06T23:46:33.826070+00:00","present":true},"market_headlines_snapshot":{"age_h":0.28,"last_at":"2026-04-06T23:46:29.835666+00:00","present":true},"market_monthly_movers_snapshot":{"age_h":null,"last_at":null,"present":false},"market_prices_snapshot":{"age_h":0.52,"last_at":"2026-04-06T23:32:04.016785+00:00","present":true},"market_weekly_movers_snapshot":{"age_h":null,"last_at":null,"present":false},"news_headline_delta":{"age_h":3.35,"last_at":"2026-04-06T20:42:08.359757+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":1.81,"last_at":"2026-04-06T22:14:34.425823+00:00","present":true}}},"sources":{"degraded":1,"error":1,"ok":4},"window_h":24},"ready_at":"2026-04-07T00:03:17.189697+00:00","status":"ready","summary":"Reliability severity: medium","title":"Reliability SLO Report","updated_at":"2026-04-07T00:03:17.189697+00:00"}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

Cancel