SQLite Web: event_store.db

Update row 14566 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

{"meta":{"action":"metrics","doctrine":"opia_executive_reliability"},"stats":{"approvals":{"applied":1,"rejected":2},"approvals_open":0,"deliveries":{"sending":2,"sent":96},"deliveries_failed":0,"deliveries_queued":0,"inbox":{"dismissed":6,"open":34},"inbox_actionable":34,"inbox_due":5,"inbox_open":34,"inbox_triaged":0,"jobs":{"done":109,"leased":1,"queued":1},"jobs_dead":0,"jobs_queued":1,"llm_usage_24h":{"input_tokens":6593307,"models":[{"calls":2888,"cost_usd":1.792881,"input_tokens":5875457,"model":"gpt-4o-mini","output_tokens":1519323,"priced_calls":2888,"total_tokens":7394780,"unpriced_calls":0},{"calls":1025,"cost_usd":0.539464,"input_tokens":717850,"model":"gpt-5.4-nano","output_tokens":316715,"priced_calls":1025,"total_tokens":1034565,"unpriced_calls":0}],"output_tokens":1836038,"priced_calls":3913,"since_iso":"2026-04-03T14:01:55.486501+00:00","total_calls":3913,"total_cost_usd":2.332345,"total_tokens":8429345,"unpriced_calls":0,"unpriced_ratio":0.0},"llm_value_24h":{"economics":{"cost_per_outcome_usd":0.00639,"cost_per_quality_adjusted_outcome_usd":0.00639,"outcomes_per_usd":156.494858,"quality_adjusted_outcomes_per_usd":156.494858},"governance":{"context_trim_rate":0.538,"context_trimmed_calls":2105,"coverage":1.0,"governed_calls":3913,"model_reroute_rate":0.2619,"model_rerouted_calls":1025,"output_cap_rate":0.9962,"output_capped_calls":3898},"llm_calls":3913,"outcomes":{"action_applied":0,"artifact_ready":364,"pending_resolved":1,"quality_adjusted_total":365,"total":365},"quality":{"incident_rate":0.0,"incidents":0},"since_iso":"2026-04-03T14:01:55.486501+00:00","total_cost_usd":2.332345},"reducer_lag":{"cursors":[{"cursor":14558,"lag":7,"max_pos":14565,"reducer":"memory_ingest:default","stream":"events","updated_at":"2026-04-04T13:57:00.355Z"},{"cursor":14562,"lag":3,"max_pos":14565,"reducer":"resolver_v3","stream":"events","updated_at":"2026-04-04T14:00:32.895Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-04T14:01:05.847Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-04T14:01:05.861Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-04T14:01:05.877Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-04T14:01:05.894Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"signal_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:05.910Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"signal_fp_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:05.925Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"signal_candidate_reducer_v2","stream":"events","updated_at":"2026-04-04T14:01:05.940Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"action_reducer_v2","stream":"events","updated_at":"2026-04-04T14:01:05.956Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"commitment_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:05.967Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"constraint_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:05.980Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"decision_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:05.994Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"approval_reducer_v2","stream":"events","updated_at":"2026-04-04T14:01:06.007Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"episode_reducer_v3","stream":"events","updated_at":"2026-04-04T14:01:06.024Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"conversation_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.037Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"watcher_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.051Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"inbox_reducer_v2","stream":"events","updated_at":"2026-04-04T14:01:06.064Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"pending_reducer_v6","stream":"events","updated_at":"2026-04-04T14:01:06.077Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"reminders_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.090Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"artifact_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.108Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"dead_letter_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.122Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"proposals_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.135Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"email_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.147Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"sms_reducer_v1","stream":"events","updated_at":"2026-04-04T14:01:06.160Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"portfolio_resolver_v3","stream":"events","updated_at":"2026-04-04T14:01:17.162Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"inbox_indexer_events_v3","stream":"events","updated_at":"2026-04-04T14:01:13.983Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"email_sender_verification_v2","stream":"events","updated_at":"2026-04-04T14:01:42.564Z"},{"cursor":14563,"lag":2,"max_pos":14565,"reducer":"sms_sender_verification_v1","stream":"events","updated_at":"2026-04-04T14:01:14.999Z"},{"cursor":5792,"lag":1,"max_pos":5793,"reducer":"opportunity_case_signals_v1","stream":"signals","updated_at":"2026-04-04T13:58:19.348Z"},{"cursor":5793,"lag":0,"max_pos":5793,"reducer":"inbox_indexer_signals_v3","stream":"signals","updated_at":"2026-04-04T13:58:25.903Z"}],"ignored_reducers":["relationship_autoclose_v1"],"max":{"events":14565,"signals":5793}},"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-04T14:01:55.486501+00:00","core_jobs":{"dead":0,"dead_letter_rate":0.0,"done":17,"failed":0,"job_types":["episode_route","context_build","cognition_think","proposal_materialize","execute_actions"],"terminal_count":17},"dead_letters":2,"execution":{"applied":0,"failed":0,"latency_m_p50":null,"latency_m_p95":null,"success_rate":1.0,"terminal_count":0},"llm_failures":4,"memory_repair":{"comparison_history_windows":3,"comparison_since":"2026-04-02T14:01:55.486501+00:00","comparison_until":"2026-04-03T14:01:55.486501+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-01T14:01:55.486501+00:00","pre_pre_comparison_since":"2026-03-31T14:01:55.486501+00:00","queued":1,"suppressed":0,"suppressed_without_queue":0,"suppression_rate":0.0,"suppression_reasons":{},"total_decisions":1,"zero_queue_risk":false},"pending":{"created":2,"latency_m_p50":231.85,"latency_m_p95":231.85,"resolution_rate":0.5,"resolved":1},"queue":{"due_now":0,"due_now_wait_m_p50":null,"due_now_wait_m_p95":null,"overdue":0,"overdue_grace_m":5.0,"overdue_wait_m_p50":null,"overdue_wait_m_p95":null,"queued":0},"since":"2026-04-03T14:01:55.486501+00:00","window_h":24},"runtime_coherence":{"cognition":{"direct_answer_action_violation":0,"direct_answer_action_violation_rate":0.0,"direct_answer_total":3,"proposal_total":4},"continuity":{"context_empty_transcript":4,"context_empty_transcript_rate":1.0,"context_total":4},"lineage":{"context_missing_turn_id":0,"context_missing_turn_id_rate":0.0,"context_total":4,"router_missing_lineage":0,"router_missing_lineage_rate":0.0,"router_total":3},"memory":{"english_normalization_gap_count":0,"english_normalization_gap_rate":0.0,"memory_total":1,"operational_memory_count":0,"operational_memory_rate":0.0,"personal_semantic_total":1},"ux":{"ack_like_intents":2,"ack_like_ratio":0.08,"consecutive_duplicate_replies":0,"duplicate_reply_rate":0.0,"thread_replies_total":46,"thread_reply_intents":25}},"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-04T13:55:04.362275+00:00","max_age_h":11.92,"missing_count":6,"missing_fraction":0.3,"types":{"discovery_crypto_extremes_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_earnings_calendar_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_ipo_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_new_listings_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_options_flow_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_sec_filings_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_sector_rotation_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"discovery_unusual_volume_snapshot":{"age_h":0.86,"last_at":"2026-04-04T13:10:32.466991+00:00","present":true},"geopolitics_events_snapshot":{"age_h":null,"last_at":null,"present":false},"macro_prices_snapshot":{"age_h":0.11,"last_at":"2026-04-04T13:55:04.362275+00:00","present":true},"macro_yield_curve_snapshot":{"age_h":0.11,"last_at":"2026-04-04T13:55:04.362275+00:00","present":true},"market_headlines_snapshot":{"age_h":0.45,"last_at":"2026-04-04T13:34:52.831275+00:00","present":true},"market_monthly_movers_snapshot":{"age_h":null,"last_at":null,"present":false},"market_prices_snapshot":{"age_h":0.12,"last_at":"2026-04-04T13:54:57.875351+00:00","present":true},"market_weekly_movers_snapshot":{"age_h":null,"last_at":null,"present":false},"news_headline_delta":{"age_h":0.22,"last_at":"2026-04-04T13:48:56.165156+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":11.92,"last_at":"2026-04-04T02:06:28.528034+00:00","present":true}}},"sources":{"degraded":1,"error":1,"ok":4},"sources_error":2},"subsystem":"observability","ts":"2026-04-04T14:01:57.056575+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