Operation 11592875
SELECT * FROM posts WHERE title LIKE ? AND content LIKE ? AND LOWER(title) LIKE ? AND UPPER(content) LIKE ?
- Operation Type
sql
- Duration
- 27.0 ms
- Request Impact
- 65.9% of total request time
- Occurred At
- Nov 21, 2026 11:39 PM
- SQL Analysis
- Normal query (<100 ms)
- Performance Comparison
-
Average: 18.0ms
95th Percentile: 34.0ms
Based on 1000 recent operations - Optimization Tips
-
Add composite index: add_index :posts, ["title", "content"] - Efficient multi-column filteringSpecify only needed columns instead of SELECT * - Reduced memory usage and faster data transferIndex Optimization - Review indexes on the 'posts' table. Consider composite indexes for WHERE clauses.