Back to Reports
RPT-008Analyzedmediummedium riskbug
Admin profile search is very slow
Reported by Richard · Apr 7, 2026, 05:00 PM · Planet Romance
Tester Report
Searching for profiles in admin takes 5-8 seconds. With 32K profiles this should be faster. Maybe missing index?
Details
- Page / Module
- Admin / Profile List
- Issue Type
- bug
- Priority
- medium
- Risk Level
- medium
- Status
- Analyzed
AI Analysis
Confidence: 90%Summary
Profile search query performs full table scan on 32K rows. Missing database index on searchable columns.
Category
Performance
Severity
medium
Suspected Area
Database query in admin profile list endpoint
Likely Cause
No index on first_name, last_name, or email columns. ILIKE query without GIN/trigram index.
Suggested Fix Strategy
1. CREATE EXTENSION pg_trgm 2. CREATE INDEX on relevant columns using gin_trgm_ops 3. Add 300ms debounce to search input
Validation Checklist
- Search responds < 500ms
- Results are accurate
- Partial matches work
- Index doesn't break writes
Follow-up Questions
- Is pg_trgm extension installed?
Developer Prompt
Add GIN trigram index for profile search. Add frontend debounce 300ms.
Internal Notes
Need to add GIN index on name columns.
Activity
Richard created
Apr 7, 2026, 05:00 PM
System ai analyzed
Apr 7, 2026, 05:05 PM