Major changes

Victoria Metrics integration (bbe4c8d)

Replaced standard Prometheus with Victoria Metrics for time-series data storage, delivering substantial performance and efficiency improvements:

• Better compression: Reduced storage footprint for long-term metric retention (from 2 GiB/day to >0.4 GiB/day/instance)
• Lower memory usage: More efficient resource utilization for large-scale deployments
• Enhanced performance: Faster query execution for dashboard rendering and analysis
• Full compatibility: Maintains complete Prometheus query language compatibility
• Increased capacity: Supports higher cardinality metrics without performance degradation

The migration is seamless with no changes required to existing Grafana dashboards or queries.

Optimized query analysis

• Improved pg_stat_statements metric collection for more accurate and useful query performance data:

  • Query-level aggregation: Metrics now aggregate by queryid across all users and databases
  • Simplified analysis: Removed per-user ranking in favor of database-wide query patterns
  • Consistent metrics: Unified view of query performance regardless of executing user
  • Better trending: More reliable historical data for query performance analysis

• Added stats_reset metric which allows to check the last time statistics were reset

New metrics (6a76444)

Added StatIO metric for indexes

Made retention period 2 weeks instead of 8 days (72c65cd)

Bug Fixes

• Fixed bug of redundant/unused indexes metrics by adding a clause of granting pg_index to monitoring user (e59fbbd)
• Fixed incorrect display of blk_write_time on the 1st dashboard (b958fa0,444343e)
• Fixed a bug of not filtering top_k for aggregated table stats (6a76444)
• statement_timeout_seconds is now set to 15 seconds for all metrics (6a76444)