Query

event_store.db — agent_runs

SQL

CREATE TABLE agent_runs  (
  id                TEXT PRIMARY KEY,
  mission_id        TEXT,
  episode_id        TEXT,
  thread_id         TEXT,
  proposal_id       TEXT,
  approval_id       TEXT,
  source_event_id   TEXT,
  actor             TEXT,
  goal              TEXT NOT NULL,
  status            TEXT NOT NULL CHECK (status IN (
                      'pending','running','blocked','cancelled','succeeded','failed'
                    )),
  tick_count        INTEGER NOT NULL DEFAULT 0,
  last_outcome      TEXT,
  last_reason       TEXT,
  max_outer_steps   INTEGER NOT NULL DEFAULT 64,
  max_wall_time_s   INTEGER NOT NULL DEFAULT 3600,
  per_tick_wall_s   INTEGER NOT NULL DEFAULT 60,
  elapsed_wall_ms   INTEGER NOT NULL DEFAULT 0,
  total_outer_steps INTEGER NOT NULL DEFAULT 0,
  params_json       TEXT,
  cancel_requested  INTEGER NOT NULL DEFAULT 0,
  error             TEXT,
  started_at        TEXT,
  completed_at      TEXT,
  last_tick_at      TEXT,
  created_at        TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  updated_at        TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
mission_id TEXT ✓ Rename | Drop
episode_id TEXT ✓ Rename | Drop
thread_id TEXT ✓ Rename | Drop
proposal_id TEXT ✓ Rename | Drop
approval_id TEXT ✓ Rename | Drop
source_event_id TEXT ✓ Rename | Drop
actor TEXT ✓ Rename | Drop
goal TEXT Rename | Drop
status TEXT Rename | Drop
tick_count INTEGER Rename | Drop
last_outcome TEXT ✓ Rename | Drop
last_reason TEXT ✓ Rename | Drop
max_outer_steps INTEGER Rename | Drop
max_wall_time_s INTEGER Rename | Drop
per_tick_wall_s INTEGER Rename | Drop
elapsed_wall_ms INTEGER Rename | Drop
total_outer_steps INTEGER Rename | Drop
params_json TEXT ✓ Rename | Drop
cancel_requested INTEGER Rename | Drop
error TEXT ✓ Rename | Drop
started_at TEXT ✓ Rename | Drop
completed_at TEXT ✓ Rename | Drop
last_tick_at TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_agent_runs_episode
  • episode_id
  • status
  • updated_at
 SQL 
CREATE INDEX idx_agent_runs_episode
ON agent_runs (episode_id, status, updated_at DESC)
Drop
idx_agent_runs_mission mission_id SQL 
CREATE INDEX idx_agent_runs_mission
ON agent_runs (mission_id)
Drop
idx_agent_runs_status_updated
  • status
  • updated_at
 SQL 
CREATE INDEX idx_agent_runs_status_updated
ON agent_runs (status, updated_at DESC)
Drop
idx_agent_runs_thread
  • thread_id
  • status
  • updated_at
 SQL 
CREATE INDEX idx_agent_runs_thread
ON agent_runs (thread_id, status, updated_at DESC)
Drop
sqlite_autoindex_agent_runs_1 id ✓ SQL
-- no sql found --
 Drop