SQL

CREATE TABLE pipe_executions  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  pipe_name TEXT NOT NULL,
  status TEXT NOT NULL DEFAULT 'queued',
  trigger_type TEXT NOT NULL DEFAULT 'manual',
  pid INTEGER,
  model TEXT,
  provider TEXT,
  started_at TEXT,
  finished_at TEXT,
  stdout TEXT DEFAULT '',
  stderr TEXT DEFAULT '',
  exit_code INTEGER,
  error_type TEXT,
  error_message TEXT,
  duration_ms INTEGER,
  session_path TEXT
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
pipe_name TEXT read-only
status TEXT read-only
trigger_type TEXT read-only
pid INTEGER ✓ read-only
model TEXT ✓ read-only
provider TEXT ✓ read-only
started_at TEXT ✓ read-only
finished_at TEXT ✓ read-only
stdout TEXT ✓ read-only
stderr TEXT ✓ read-only
exit_code INTEGER ✓ read-only
error_type TEXT ✓ read-only
error_message TEXT ✓ read-only
duration_ms INTEGER ✓ read-only
session_path TEXT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_pipe_exec_name_status
  • pipe_name
  • status
 SQL 
CREATE INDEX idx_pipe_exec_name_status
ON pipe_executions(pipe_name, status)
read-only
idx_pipe_exec_name_time
  • pipe_name
  • id
 SQL 
CREATE INDEX idx_pipe_exec_name_time
ON pipe_executions(pipe_name, id DESC)
read-only
idx_pipe_exec_running status SQL 
CREATE INDEX idx_pipe_exec_running
ON pipe_executions(status) WHERE status = 'running'
read-only