sessions

1 row where parent_session_id = "93fa9fead9d6"

✎ 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
20260517_104624_281dcc webui   nvidia/nemotron-3-super-120b-a12b:free {"max_iterations": 90, "reasoning_config": {"enabled": true, "effort": "medium"}, "max_tokens": null}   None 93fa9fead9d6 1779014784.3338945     34 12 589305 8934 0 0 0 openrouter https://openrouter.ai/api/v1   0.0   estimated provider_models_api     14      

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;