# Omni Analytics: Slow Queries

- Impact (vendor’s label): major
- Status: resolved
- Started: 2024-04-08 16:55 UTC · Resolved: 2024-04-08 17:05 UTC · Duration: 11 min
- Updates: 2 · Affected components: EastUsa
- [Vendor status page: https://stspg.io/xksfh2yjkkv4](https://stspg.io/xksfh2yjkkv4)
- [Company: Omni Analytics](https://rewindex.com/company/omni-analytics.md)

## Summary

Omni Analytics reported major query degradation in EastUsa from 2024-04-08 16:55 UTC to 2024-04-08 17:05 UTC, lasting 10 min. Queries were slow or delayed because an information-schema query spike after cache expiration triggered a thundering herd, compounded by missing autoscaling logic; the incident was resolved, with autoscaling improvements planned. _(machine-written, sol)_
## Timeline of updates

- **investigating** 2024-04-08 16:55 UTC: Queries in the EastUsa region are slow and/or delayed.
- **resolved** 2024-04-08 17:05 UTC: For approximately 10 minutes starting around 9:55am US/Pacific time, queries in the EastUsa region ran slower than normal.  A spike of queries against an information schema where the cache had expired triggered a thundering herd effect.  That combined with some missing logic in our auto scaling caused queues to back up.  We will be working to address the issue in the auto scaling logic in the next few days and will also work to change our caching logic to avoid any further thundering herd effects.

## Rewindex changes for this incident

- 2024-04-08 16:55 UTC: [Major incident: Slow Queries](https://rewindex.com/change/i7c871b8b90996d.md)


---
Canonical: https://rewindex.com/company/omni-analytics/incidents/xvrf44y9g26t · Markdown: https://rewindex.com/company/omni-analytics/incidents/xvrf44y9g26t.md · JSON: https://rewindex.com/api/v1/companies/omni-analytics/incidents/xvrf44y9g26t · Generated 2026-10-18T11:44:23.542Z