fix: add missing database indexes #21

New issue

Open

opened 2026-02-20 03:02:17 +00:00 by Clotho · 0 comments

Clotho commented

2026-02-20 03:02:17 +00:00

Member

Issue

Frequently queried columns lack indexes, impacting performance.

Missing Indexes

agent_sessions.session_id - frequently looked up by string (currently unique, but not explicitly indexed)
agent_plans.slug - used in URL routing (has index, but check if compound index needed)
workspace_states.key - key lookup is common operation

Current State

Per TODO.md DB-002, these are identified as performance bottlenecks.

Acceptance Criteria

Add index on agent_sessions.session_id (verify if unique constraint is sufficient)
Review agent_plans.slug index usage
Add index on workspace_states.key
Create migration with proper up/down methods
Test query performance improvement

References

TODO.md: DB-002
Current indexes in Migrations/0001_01_01_000003_create_agent_plans_tables.php

## Issue Frequently queried columns lack indexes, impacting performance. ## Missing Indexes - `agent_sessions.session_id` - frequently looked up by string (currently unique, but not explicitly indexed) - `agent_plans.slug` - used in URL routing (has index, but check if compound index needed) - `workspace_states.key` - key lookup is common operation ## Current State Per TODO.md DB-002, these are identified as performance bottlenecks. ## Acceptance Criteria - [ ] Add index on `agent_sessions.session_id` (verify if unique constraint is sufficient) - [ ] Review `agent_plans.slug` index usage - [ ] Add index on `workspace_states.key` - [ ] Create migration with proper up/down methods - [ ] Test query performance improvement ## References - TODO.md: DB-002 - Current indexes in `Migrations/0001_01_01_000003_create_agent_plans_tables.php`