An replace to PlanetScale known as Insights Anomalies introduces good question monitoring to detect slower-than-expected queries in databases.

PlanetScale’s Insights Anomalies is designed to simplify the method of assessing a database’s well being and troubleshooting points, in response to the corporate in a weblog put up. The first aim is to supply a transparent overview of the database’s standing and to make the troubleshooting course of simple.

PlanetScale believes that it’s not solely essential to detect anomalies in a database but in addition to grasp their root causes. Insights presents related metrics for every anomaly, together with high-level question metrics comparable to rows learn and written per second, utilization metrics for database sources (comparable to CPU and disk utilization), and data on backups and deploy requests which may affect shared sources.

Insights information and retains exact question counts for each question sample in a database. This permits for a comparability between the execution fee of every question sample and the general well being metrics of the database, enabling the identification of extremely correlated queries. 

PlanetScale Insights supplies customers with an in depth examination of all lively queries operating in opposition to their database by an in-dashboard device. This device permits for the identification of queries exhibiting points comparable to extreme frequency, extended execution instances, massive knowledge returns, or errors. Customers can navigate a efficiency graph to pinpoint when a question was impacted and, when relevant, the related Deploy Request. The device additionally presents an inventory of all queries carried out within the final 24 hours, sortable by metrics like rows learn and time per question for thorough evaluation.

With this built-in device, customers can simply diagnose question points, streamlining the optimization of particular person queries with out in depth investigation. The Anomalies tab additional alerts customers to any lively points, flagging queries operating considerably slower than anticipated.