Company
Date Published
Author
Ryan Booz
Word count
2704
Language
English
Hacker News points
None

Summary

We're excited to announce that the `pg_stat_statements` PostgreSQL extension is now enabled by default in all Timescale Cloud services. This powerful tool allows you to quickly identify problematic queries and gain instant visibility into your database performance. With `pg_stat_statements`, you can query the number of times a query has been called, execution time, hit cache ratio, and other helpful statistics such as standard deviation of query execution time. By using these metrics, you can narrow down which queries to focus on improving and optimize your database for better performance. We'll show you how to filter data by user ID and use common table expressions to make the most out of this valuable tool. Additionally, we'll explore how to identify long-running queries, queries with high standard deviation, and hit cache ratio, providing insights into potential performance bottlenecks in your TimescaleDB database.