Create
Query
event_store.db
—
events
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 9185 in events
seq
Primary key.
INTEGER
id
evt_02ecdd8c81cc
TEXT NOT NULL
kind
system
TEXT NOT NULL
ts
2026-04-04T01:00:24.457231+00:00
TEXT NOT NULL
actor
observability
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":79},"deliveries_failed":0,"deliveries_queued":0,"inbox":{"dismissed":6,"open":30},"inbox_actionable":30,"inbox_due":5,"inbox_open":30,"inbox_triaged":0,"jobs":{"done":183,"leased":2},"jobs_dead":0,"jobs_queued":0,"llm_usage_24h":{"input_tokens":4174540,"models":[{"calls":1768,"cost_usd":1.081526,"input_tokens":3613995,"model":"gpt-4o-mini","output_tokens":899052,"priced_calls":1768,"total_tokens":4513047,"unpriced_calls":0},{"calls":810,"cost_usd":0.40355,"input_tokens":560545,"model":"gpt-5.4-nano","output_tokens":233148,"priced_calls":810,"total_tokens":793693,"unpriced_calls":0}],"output_tokens":1132200,"priced_calls":2578,"since_iso":"2026-04-03T01:00:24.051110+00:00","total_calls":2578,"total_cost_usd":1.485076,"total_tokens":5306740,"unpriced_calls":0,"unpriced_ratio":0.0},"llm_value_24h":{"economics":{"cost_per_outcome_usd":0.006401,"cost_per_quality_adjusted_outcome_usd":0.006401,"outcomes_per_usd":156.220961,"quality_adjusted_outcomes_per_usd":156.220961},"governance":{"context_trim_rate":0.4957,"context_trimmed_calls":1278,"coverage":1.0,"governed_calls":2578,"model_reroute_rate":0.3142,"model_rerouted_calls":810,"output_cap_rate":0.976,"output_capped_calls":2516},"llm_calls":2578,"outcomes":{"action_applied":5,"artifact_ready":223,"pending_resolved":4,"quality_adjusted_total":232,"total":232},"quality":{"incident_rate":0.0,"incidents":0},"since_iso":"2026-04-03T01:00:24.051110+00:00","total_cost_usd":1.485076},"reducer_lag":{"cursors":[{"cursor":9123,"lag":61,"max_pos":9184,"reducer":"memory_ingest:default","stream":"events","updated_at":"2026-04-04T00:57:42.540Z"},{"cursor":3442,"lag":27,"max_pos":3469,"reducer":"opportunity_case_signals_v1","stream":"signals","updated_at":"2026-04-04T00:56:39.608Z"},{"cursor":9164,"lag":20,"max_pos":9184,"reducer":"resolver_v3","stream":"events","updated_at":"2026-04-04T00:59:07.808Z"},{"cursor":9174,"lag":10,"max_pos":9184,"reducer":"sms_sender_verification_v1","stream":"events","updated_at":"2026-04-04T00:59:48.271Z"},{"cursor":9177,"lag":7,"max_pos":9184,"reducer":"email_sender_verification_v2","stream":"events","updated_at":"2026-04-04T00:59:56.012Z"},{"cursor":9179,"lag":5,"max_pos":9184,"reducer":"portfolio_resolver_v3","stream":"events","updated_at":"2026-04-04T01:00:01.956Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"entity_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-04T01:00:15.571Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"entity_alias_reducer_v2","stream":"events","updated_at":"2026-04-04T01:00:15.597Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"event_subjects_reducer_v2","stream":"events","updated_at":"2026-04-04T01:00:15.612Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"fact_reducer_v2_deterministic","stream":"events","updated_at":"2026-04-04T01:00:15.630Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"signal_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.657Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"signal_fp_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.675Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"signal_candidate_reducer_v2","stream":"events","updated_at":"2026-04-04T01:00:15.693Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"action_reducer_v2","stream":"events","updated_at":"2026-04-04T01:00:15.709Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"commitment_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.724Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"constraint_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.740Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"decision_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.755Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"approval_reducer_v2","stream":"events","updated_at":"2026-04-04T01:00:15.769Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"episode_reducer_v3","stream":"events","updated_at":"2026-04-04T01:00:15.783Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"conversation_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.798Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"watcher_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.814Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"inbox_reducer_v2","stream":"events","updated_at":"2026-04-04T01:00:15.842Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"pending_reducer_v6","stream":"events","updated_at":"2026-04-04T01:00:15.856Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"reminders_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.871Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"artifact_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.886Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"dead_letter_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.900Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"proposals_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.913Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"email_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.926Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"sms_reducer_v1","stream":"events","updated_at":"2026-04-04T01:00:15.939Z"},{"cursor":9181,"lag":3,"max_pos":9184,"reducer":"inbox_indexer_events_v3","stream":"events","updated_at":"2026-04-04T01:00:15.566Z"},{"cursor":3468,"lag":1,"max_pos":3469,"reducer":"inbox_indexer_signals_v3","stream":"signals","updated_at":"2026-04-04T01:00:01.103Z"}],"ignored_reducers":["relationship_autoclose_v1"],"max":{"events":9184,"signals":3469}},"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-04T01:00:24.051110+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":3,"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-02T01:00:24.051110+00:00","comparison_until":"2026-04-03T01:00:24.051110+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-01T01:00:24.051110+00:00","pre_pre_comparison_since":"2026-03-31T01:00:24.051110+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":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-03T01:00:24.051110+00:00","window_h":24},"runtime_coherence":{"cognition":{"direct_answer_action_violation":0,"direct_answer_action_violation_rate":0.0,"direct_answer_total":9,"proposal_total":17},"continuity":{"context_empty_transcript":17,"context_empty_transcript_rate":1.0,"context_total":17},"lineage":{"context_missing_turn_id":0,"context_missing_turn_id_rate":0.0,"context_total":17,"router_missing_lineage":0,"router_missing_lineage_rate":0.0,"router_total":13},"memory":{"english_normalization_gap_count":0,"english_normalization_gap_rate":0.0,"memory_total":9,"operational_memory_count":0,"operational_memory_rate":0.0,"personal_semantic_total":9},"ux":{"ack_like_intents":5,"ack_like_ratio":0.1111,"consecutive_duplicate_replies":0,"duplicate_reply_rate":0.0,"thread_replies_total":64,"thread_reply_intents":45}},"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-04T00:53:40.317292+00:00","max_age_h":0.99,"missing_count":6,"missing_fraction":0.3,"types":{"discovery_crypto_extremes_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_earnings_calendar_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_ipo_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_new_listings_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_options_flow_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_sec_filings_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_sector_rotation_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"discovery_unusual_volume_snapshot":{"age_h":0.99,"last_at":"2026-04-04T00:01:02.719481+00:00","present":true},"geopolitics_events_snapshot":{"age_h":null,"last_at":null,"present":false},"macro_prices_snapshot":{"age_h":0.37,"last_at":"2026-04-04T00:38:05.971552+00:00","present":true},"macro_yield_curve_snapshot":{"age_h":0.37,"last_at":"2026-04-04T00:38:05.971552+00:00","present":true},"market_headlines_snapshot":{"age_h":0.34,"last_at":"2026-04-04T00:40:02.697428+00:00","present":true},"market_monthly_movers_snapshot":{"age_h":null,"last_at":null,"present":false},"market_prices_snapshot":{"age_h":0.17,"last_at":"2026-04-04T00:50:02.800530+00:00","present":true},"market_weekly_movers_snapshot":{"age_h":null,"last_at":null,"present":false},"news_headline_delta":{"age_h":0.11,"last_at":"2026-04-04T00:53:40.317292+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.89,"last_at":"2026-04-04T00:06:46.083058+00:00","present":true}}},"sources":{"degraded":1,"error":1,"ok":4},"sources_error":2},"subsystem":"observability","ts":"2026-04-04T01:00:24.457231+00:00"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
observability_metrics:2026-04-04T01
TEXT
episode_id
NULL
TEXT
created_at
2026-04-04T01:00:24.457334+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel