Operation 11601739
SELECT * FROM posts WHERE title LIKE ? AND content LIKE ? AND LOWER(title) LIKE ? AND UPPER(content) LIKE ?
- Operation Type
sql
- Duration
- 1.0 ms
- Request Impact
- 10.0% of total request time
- Occurred At
- Nov 22, 2026 9:12 AM
- 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.