SQLite Web: event

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":"tick"},"stats":{"analyze":{"hours_since":6.0,"last_at":"2026-04-04T14:47:52.397459+00:00","ran":false,"reason":"not_due"},"archived":{"events":0,"events_by_kind":{}},"backup":null,"db_sizes_after":{"db_bytes":157782016,"db_path":"/etc/opia/event_store.db","shm_bytes":0,"total_bytes":157782016,"wal_bytes":0},"db_sizes_before":{"db_bytes":157782016,"db_path":"/etc/opia/event_store.db","shm_bytes":0,"total_bytes":157782016,"wal_bytes":0},"deleted":{"artifacts":0,"dead_letters":0,"deliveries":0,"events":0,"events_archive":0,"events_by_kind":{},"inbox_items":0,"opportunity_memory":0,"pending_interactions":0,"reminders":0,"signal_candidates":228,"signal_candidates_done":228,"signal_candidates_failed":0,"signal_fps":0,"signals":0},"events_catalog":{"categories":{"audit":29,"ephemeral":14,"state_transition":72,"user_history":4},"prunable_kinds":14,"prune_rules":[{"kind":"episode_context_built","retention_days":30},{"kind":"llm_usage","retention_days":90},{"kind":"notification_sent","retention_days":180},{"kind":"nudge_proposed","retention_days":30},{"kind":"nudge_sent","retention_days":180},{"kind":"nudge_suppressed","retention_days":30},{"kind":"planner_tick","retention_days":7},{"kind":"router_routed","retention_days":30},{"kind":"signal_emitted","retention_days":14},{"kind":"signal_ingest","retention_days":1},{"kind":"system","retention_days":30},{"kind":"watcher_eval","retention_days":1},{"kind":"watcher_fired","retention_days":30},{"kind":"web_search_performed","retention_days":30}],"total_kinds":119},"events_prune_control":{"batch_per_kind":500,"loops_by_kind":{},"max_batches_per_kind":8,"max_total_archives":15000,"max_total_deletes":15000,"remaining_archive_budget":15000,"remaining_delete_budget":15000},"rollups":{},"row_counts_after_prune":{"actions":5,"approvals":3,"deliveries":111,"episodes":13,"events":16569,"events_archive":0,"inbox_items":44,"jobs":79,"opportunity_memory":0,"pending_interactions":6,"reminders":2,"signal_fps":6720,"signals":6720},"row_counts_before":{"actions":5,"approvals":3,"deliveries":111,"episodes":13,"events":16569,"events_archive":0,"inbox_items":44,"jobs":79,"opportunity_memory":0,"pending_interactions":6,"reminders":2,"signal_fps":6720,"signals":6720},"row_counts_final":{"actions":5,"approvals":3,"deliveries":111,"episodes":13,"events":16569,"events_archive":0,"inbox_items":44,"jobs":79,"opportunity_memory":0,"pending_interactions":6,"reminders":2,"signal_fps":6720,"signals":6720},"size_delta_bytes":0,"sqlite_pages_after_prune":{"db_estimated_bytes":157782016,"free_estimated_bytes":90112,"free_ratio":0.0006,"freelist_count":22,"page_count":38521,"page_size":4096,"used_pages":38499},"sqlite_pages_before":{"db_estimated_bytes":157782016,"free_estimated_bytes":0,"free_ratio":0.0,"freelist_count":0,"page_count":38521,"page_size":4096,"used_pages":38521},"sqlite_pages_final":{"db_estimated_bytes":157782016,"free_estimated_bytes":90112,"free_ratio":0.0006,"freelist_count":22,"page_count":38521,"page_size":4096,"used_pages":38499},"vacuum":{"page_stats":{"db_estimated_bytes":157782016,"free_estimated_bytes":90112,"free_ratio":0.0006,"freelist_count":22,"page_count":38521,"page_size":4096,"used_pages":38499},"ran":false,"reason":"not_worth_it"},"wal_checkpoint":{"mode":"PASSIVE","ok":true,"result":[0,0,0]}},"subsystem":"data_lifecycle","ts":"2026-04-04T20:47:54.120074+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')

event_store.db — events

Update row 16571 in events