state_2
Tables
async_delegations
delegation_id, origin_session, origin_ui_session_id, parent_session_id, state, dispatched_at, completed_at, updated_at, event_json, result_json, delivery_state, delivery_attempts, delivered_at, owner_pid, owner_started_at, task_json, delivery_claim, delivery_claimed_at, origin_session_id
0 rows
delivery_obligations
obligation_id, session_key, platform, chat_id, thread_id, content, state, attempts, created_at, updated_at, owner_pid, owner_started_at, last_error
1 row
messages
id, session_id, role, content, tool_call_id, tool_calls, tool_name, timestamp, token_count, finish_reason, reasoning, reasoning_content, reasoning_details, codex_reasoning_items, codex_message_items, effect_disposition, platform_message_id, observed, active, compacted, api_content, display_kind, display_metadata
10,816 rows
session_model_usage
session_id, model, billing_provider, billing_base_url, billing_mode, task, api_call_count, input_tokens, output_tokens, cache_read_tokens, cache_write_tokens, reasoning_tokens, estimated_cost_usd, actual_cost_usd, cost_status, cost_source, first_seen, last_seen
281 rows
sessions
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, session_key, chat_id, chat_type, thread_id, display_name, origin_json, expiry_finalized, cwd, git_branch, git_repo_root, compression_failure_cooldown_until, compression_failure_error, compression_fallback_streak, profile_name, rewind_count, archived, compression_ineffective_count, pinned, system_prompt_hash, git_metadata_generation, title_source, last_activity_at, last_activity_description, last_activity_provenance, hidden, last_read_at
292 rows
... and 12 hidden tables
Download SQLite DB: state_2.db 110.1 MB