Slow-Query Queue
Captured user workloads ranked by explain evidence — blocking sort, collection scan, and over-scan ratio, not wall-clock. Pick one to diagnose.
| sev | query | signal | over-scan | keys | caused by | |
|---|---|---|---|---|---|---|
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Phone · age 55–75 · sort saleDate ↓phone_seniors | blocking SORT | 100,377/15 (6,692×) | 100,377 | Dev Trivedi | |
| high | method=Online · age 18–35 · sort saleDate ↓online_recent | blocking SORT | 100,073/25 (4,003×) | 100,073 | Aakash Singh | |
| high | method=Online · age 18–35 · sort saleDate ↓online_recent | blocking SORT | 100,073/25 (4,003×) | 100,073 | Aakash Singh | |
| high | method=Online · age 18–35 · sort saleDate ↓online_recent | blocking SORT | 100,073/25 (4,003×) | 100,073 | Aakash Singh | |
| high | method=Online · age 18–35 · sort saleDate ↓online_recent | blocking SORT | 100,073/25 (4,003×) | 100,073 | Aakash Singh | |
| high | method=Online · age 18–35 · sort saleDate ↓online_recent | blocking SORT | 100,073/25 (4,003×) | 100,073 | Aakash Singh | |
| high | method=Online · age 18–35 · sort saleDate ↓online_recent | blocking SORT | 100,073/25 (4,003×) | 100,073 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Denver · age 30–50 · sort saleDate ↓denver_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Dev Trivedi | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh | |
| high | store=Seattle · age 25–45 · sort saleDate ↓seattle_recent | blocking SORT | 50,000/20 (2,500×) | 50,000 | Aakash Singh |