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 5 in events
seq
Primary key.
INTEGER
id
evt_0e43aa159a2c
TEXT NOT NULL
kind
artifact_upsert
TEXT NOT NULL
ts
2026-04-03T10:34:35.128767+00:00
TEXT NOT NULL
actor
observability
TEXT
subject_entity_ids
[]
TEXT
payload
{"artifact_id":"art_reliability_slo_report_2026-04-03","created_at":"2026-04-03T10:34:35.128767+00:00","kind":"reliability_slo_report","meta":{"day":"2026-04-03","doctrine":"opia_executive_reliability","source":"observability"},"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},"ready_at":"2026-04-03T10:34:35.128767+00:00","status":"ready","summary":"Reliability severity: high","title":"Reliability SLO Report","updated_at":"2026-04-03T10:34:35.128767+00:00"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
artifact_upsert:reliability_slo_report:2026-04-03
TEXT
episode_id
NULL
TEXT
created_at
2026-04-03T10:34:35.284655+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel