About EDB Stat Monitor

EDB Stat Monitor (edb_stat_monitor) simplifies query observability by providing a more holistic view of query from performance, application and analysis perspectives. This is achieved by grouping data in configurable time buckets that allow capturing of load and performance information for smaller time windows. So performance issues and patterns can be identified based on time and workload.

• Time Interval Grouping: Instead of supplying one set of ever-increasing counts, edb_stat_monitor computes stats for a configured number of time intervals - time buckets. This allows for much better data accuracy, especially in the case of high resolution or unreliable networks.
• T-digest: EDB Stat Monitor uses the T-digest algorithm to provide a more accurate representation of query execution times. This is particularly useful for calculating percentiles and histograms, which can help identify performance bottlenecks.
• Sampling: EDB Stat Monitor can be configured to sample queries, which helps reduce the overhead of monitoring while still providing valuable insights into query performance.
• Multi-Dimensional Grouping: While pg_stat_statements groups counters by userid, dbid, queryid, edb_stat_monitor uses a more detailed group for higher precision. This allows a user to drill down into the performance of queries.
• Capture Actual Parameters in the Queries: edb_stat_monitor allows you to choose if you want to see queries with placeholders for parameters or actual parameter data. This simplifies debugging and analysis processes by enabling users to execute the same query.
• Query Plan: Each SQL query is now accompanied by its actual plan that was constructed for its execution. That’s a huge advantage if you want to understand why a particular query is slower than expected.
• Tables Access Statistics for a Statement: This allows us to easily identify all queries that accessed a given table. This set is at par with the information provided by the pg_stat_statements.
• Histogram: Visual representation is very helpful as it can help identify issues. With the help of the histogram function, one can now view a timing/calling data histogram in response to an SQL query. And yes, it even works in psql.

Read more about the features of EDB Stat Monitor and how to configure it.