max / goingson

455 B · 11 lines History Blame Raw

1	-- Partial indexes for focus mode and waiting-for-response query patterns.
2
3	CREATE INDEX IF NOT EXISTS idx_tasks_focus_set_at
4	ON tasks(focus_set_at DESC) WHERE is_focus = 1;
5
6	CREATE INDEX IF NOT EXISTS idx_tasks_waiting_response
7	ON tasks(expected_response_date ASC, waiting_since ASC) WHERE waiting_for_response = 1;
8
9	CREATE INDEX IF NOT EXISTS idx_emails_waiting_response
10	ON emails(expected_response_date ASC) WHERE waiting_for_response = 1;
11