Debugging & Developer Tools

private func openRecordingsFolder() {
    performAfterMenuDismiss {
        let directory = StorageManager.shared.recordingsRoot
        NSWorkspace.shared.open(directory)
    }
}

~/Library/Application Support/Dayflow/recordings/

yyyyMMdd_HHmmssSSS.mp4
yyyyMMdd_HHmmssSSS.jpg

~/Library/Application Support/Dayflow/chunks.sqlite

sqlite3 ~/Library/Application\ Support/Dayflow/chunks.sqlite

--- Timeline cards (latest 50) ---
1. [2026-03-03] 2:30 PM-3:45 PM | Writing documentation | Work / Development | created 2026-03-03 14:30:00
   Summary: Drafted advanced debugging documentation for Dayflow
   Details: Created comprehensive guide covering recordings access, batch inspection, and troubleshooting

--- LLM calls (latest 50) ---  
1. 2026-03-03 14:35:12 | gemini | gemini-2.0-flash-exp | generate_cards | success | 1847ms | HTTP 200
   batch 42, group abc123, attempt 1
   POST https://generativelanguage.googleapis.com/v1beta/...

--- Analysis batches (latest 50) ---
1. id=42 | status=completed | created 2026-03-03 14:30:00
   window: 2026-03-03 14:00:00 → 2026-03-03 14:30:00
   reason: scheduled_interval

log stream --predicate 'processImagePath contains "Dayflow"' --level debug

# Deep-link events
log stream --predicate 'processImagePath contains "Dayflow"' | grep DeepLink

# Database operations  
log stream --predicate 'processImagePath contains "Dayflow"' | grep "DB write"

# Slow queries (>100ms)
log stream --predicate 'processImagePath contains "Dayflow"' | grep "SLOW"

~/Library/Logs/DiagnosticReports/Dayflow_*.crash

# Check current resource usage
top -pid $(pgrep Dayflow)

# Sample for 10 seconds to identify hot code paths
sample Dayflow 10 -f ~/Desktop/dayflow_sample.txt

# Check for completed but unprocessed chunks
sqlite3 ~/Library/Application\ Support/Dayflow/chunks.sqlite \
  "SELECT COUNT(*) FROM chunks WHERE status='completed' AND id NOT IN (SELECT chunk_id FROM batch_chunks);"

# Check for pending batches
sqlite3 ~/Library/Application\ Support/Dayflow/chunks.sqlite \
  "SELECT COUNT(*) FROM analysis_batches WHERE status='pending';"

#if DEBUG
try? db.write { db in
    db.trace { event in
        if case .profile(let statement, let duration) = event, duration > 0.1 {
            print("📊 SLOW SQL (\(Int(duration * 1000))ms): \(statement)")
        }
    }
}
#endif

SELECT day, start, end, title, category 
FROM timeline_cards 
WHERE is_deleted = 0 
ORDER BY start_ts DESC 
LIMIT 20;

SELECT provider, operation, status, COUNT(*) as count, AVG(latency_ms) as avg_ms
FROM llm_calls
GROUP BY provider, operation, status
ORDER BY count DESC;

SELECT day, COUNT(*) as card_count, SUM(end_ts - start_ts) as total_seconds
FROM timeline_cards
WHERE is_deleted = 0
GROUP BY day
ORDER BY day DESC
LIMIT 30;

cp ~/Library/Application\ Support/Dayflow/chunks.sqlite \
   ~/Desktop/dayflow_backup_$(date +%Y%m%d).sqlite

~/Library/Application Support/Dayflow/backups/