sessions

1 row where parent_session_id = "20260526_103814_ebdef3"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ source user_id model model_config system_prompt parent_session_id started_at ended_at end_reason message_count tool_call_count input_tokens output_tokens cache_read_tokens cache_write_tokens reasoning_tokens billing_provider billing_base_url billing_mode estimated_cost_usd actual_cost_usd cost_status cost_source pricing_version title api_call_count handoff_state handoff_platform handoff_error
20260526_110013_67bc1d cli   openai/gpt-oss-120b:free {"max_iterations": 90, "reasoning_config": {"enabled": true, "effort": "medium"}, "max_tokens": null}   Reprise du service Caddy avec JWT #2 20260526_103814_ebdef3 1779789613.2620528 1779791192.140174 compression 67 31 113777 17908 960128 0 0 openrouter https://openrouter.ai/api/v1   0.0   unknown provider_models_api   Reprise du service Caddy avec JWT #3 30      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE sessions (
    id TEXT PRIMARY KEY,
    source TEXT NOT NULL,
    user_id TEXT,
    model TEXT,
    model_config TEXT,
    system_prompt TEXT,
    parent_session_id TEXT,
    started_at REAL NOT NULL,
    ended_at REAL,
    end_reason TEXT,
    message_count INTEGER DEFAULT 0,
    tool_call_count INTEGER DEFAULT 0,
    input_tokens INTEGER DEFAULT 0,
    output_tokens INTEGER DEFAULT 0,
    cache_read_tokens INTEGER DEFAULT 0,
    cache_write_tokens INTEGER DEFAULT 0,
    reasoning_tokens INTEGER DEFAULT 0,
    billing_provider TEXT,
    billing_base_url TEXT,
    billing_mode TEXT,
    estimated_cost_usd REAL,
    actual_cost_usd REAL,
    cost_status TEXT,
    cost_source TEXT,
    pricing_version TEXT,
    title TEXT,
    api_call_count INTEGER DEFAULT 0,
    handoff_state TEXT,
    handoff_platform TEXT,
    handoff_error TEXT, "session_key" TEXT, "chat_id" TEXT, "chat_type" TEXT, "thread_id" TEXT, "display_name" TEXT, "origin_json" TEXT, "expiry_finalized" INTEGER DEFAULT 0, "cwd" TEXT, "git_branch" TEXT, "git_repo_root" TEXT, "compression_failure_cooldown_until" REAL, "compression_failure_error" TEXT, "compression_fallback_streak" INTEGER NOT NULL DEFAULT 0, "profile_name" TEXT, "rewind_count" INTEGER NOT NULL DEFAULT 0, "archived" INTEGER NOT NULL DEFAULT 0, "compression_ineffective_count" INTEGER NOT NULL DEFAULT 0, "pinned" INTEGER NOT NULL DEFAULT 0, "system_prompt_hash" TEXT, "git_metadata_generation" INTEGER NOT NULL DEFAULT 0, "title_source" TEXT, "last_activity_at" REAL, "last_activity_description" TEXT, "last_activity_provenance" TEXT, "hidden" INTEGER NOT NULL DEFAULT 0, "last_read_at" REAL,
    FOREIGN KEY (parent_session_id) REFERENCES sessions(id)
);
CREATE INDEX idx_sessions_source ON sessions(source);
CREATE INDEX idx_sessions_parent ON sessions(parent_session_id);
CREATE INDEX idx_sessions_started ON sessions(started_at DESC);
CREATE UNIQUE INDEX idx_sessions_title_unique ON sessions(title) WHERE title IS NOT NULL;