Company
Date Published
Author
Rafer Hazen
Word count
963
Language
English
Hacker News points
None

Summary

Introducing Insights Anomalies`: PlanetScale has launched a new feature in its database monitoring tool called Insights Anomalies, designed to simplify troubleshooting and ensure database health. The feature provides a graph representing the database's health over time, highlighting periods of performance anomalies with a red icon. Clicking on an anomaly reveals detailed information to help understand the causes of the issue. A threshold is calculated based on query response times exceeding two standard deviations above the mean for queries with similar patterns, providing a reliable indicator of when the database is pushed beyond its limits. The feature also includes troubleshooting metrics such as query counts, utilization, and backup requests, making it easier to identify bottlenecks. Additionally, correlated queries can be identified by calculating the Pearson correlation coefficient between execution rates and overall database health metrics.