PlanetScale

Optimizing queries in arewefastyet

Oct 11, 2022Florent Poinsard, Harshit Gangal
Optimizing queries in arewefastyet
SummaryAI, from the source post

This post details the process of using PlanetScale Insights to identify and resolve two slow queries in the Arewefastyet benchmarking tool. The identified queries were missing indexes on `finished_at` and `status` (for the OLTP/TPCC query) and `started_at` (for the benchmark comparison query). Adding these indexes via PlanetScale's deploy request workflow led to a significant reduction in query latency.

More from the Database Benchmarking Best Practices trail