Case Study: Atlassian optimizes Postgres query performance with pganalyze

How Atlassian and pganalyze are optimizing Postgres query performance

Atlassian, a major software company, faced significant challenges in optimizing the performance of its extensive Postgres databases which power products like Jira and Bitbucket. Their engineers struggled to identify problematic queries due to a lack of historical data and restricted access to production environments, leading to time-consuming manual debugging processes. This inefficiency prompted their search for a solution, which they found with pganalyze.

By implementing pganalyze's Postgres monitoring platform, Atlassian gained a unified dashboard for performance analysis, including detailed query statistics and automated index checks. The solution provided immediate visibility into database performance without requiring production access. This enabled engineers to quickly pinpoint and resolve issues, saving at least a day of forensic analysis per problem and ensuring a better experience for their end-users.

Atlassian

Sam Dupont

Senior Developer