Optimizing queries in arewefastyet
Oct 11, 2022Florent Poinsard, Harshit Gangal

Summary
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.