Company
Date Published
Author
Rob Kiefer
Word count
1455
Language
English
Hacker News points
None

Summary

The newly released `Insights` feature by Timescale allows users to deeply observe the queries running in their database over a given time period, providing useful statistics on timing/latency, memory usage, and more. This complements existing tools like pg_stat_statements, which provides a complementary but limited form of database observability. Insights offers a scalable query collection system, storing sanitized statistics on every query running in the cloud service, and providing graphs and stats to power its functionality. The feature is available in all regions as part of Timescale's Cloud Week, and can be accessed through the service view of the Timescale service. It provides a user-friendly interface for users to explore relationships between system resources and query latency, identify problematic queries, and track performance over time. With Insights, users can save precious time and effort optimizing their queries, and unlock a new understanding of their database's performance.