Case Study: CounterPath accelerates Postgres queries up to 1000x with pganalyze

How CounterPath accelerates their Postgres queries up to 1000x using pganalyze

CounterPath, a provider of unified communications solutions, faced significant challenges in managing and scaling their heavy-use PostgreSQL databases. Manually logging in to analyze slow queries was inefficient, making it difficult to identify performance issues and forcing them to rely on customer complaints to discover problems. They turned to pganalyze to gain deep insights into their database performance.

By implementing pganalyze, CounterPath gained proactive monitoring and detailed query analysis. The solution provided specific recommendations, such as index improvements, which led to dramatic results. These optimizations, guided by pganalyze, accelerated queries by up to 1000x, reduced database CPU utilization by 16x, and cut database startup times by 4x, allowing the team to be proactive and significantly improve customer experience.

CounterPath

Jim O'Brien

VP Server Engineering, Operations and IT