PostgreSQL Monitoring Tool - PostgreSQL Performance Monitoring 24x7

DBTuna is a comprehensive 24x7 deep-dive monitoring tool used to monitor versions 8 and 9 of PostgreSQL. It is designed to be simple to deploy and very low overhead, therefore is ideally suited to busy production sites or testing environments.

Core Features of DBTuna Include:

• Monitor all your PostgreSQL Servers throughout the enterprise
• Find and fix performance bottlenecks whenever they occur
• Analyze performance trends over time
• Set customized alerts and notifications
• Quick and easy to deploy - No agents or database objects required on monitored PostgreSQL servers

Key Benefits of DBTuna for PostgreSQL Monitoring

• Free up Resources that would otherwise be wasted in trying to find and fix performance problems.
• Avoid Hardware Upgrades - Use DBTuna to pro-actively tune your PostgreSQL Servers and hence offset the need for costly hardware upgrades.
• Dramatically reduce the time to fix problems - By using DBTuna you and your team can cut wasted hours of effort in getting to the root cause of a costly performance problem
• Proactively Tune Internal Applications - Improve employee efficiency by making your internal apps go faster!
• Proactively Tune Customer Facing Applications - Restore customer confidence in your company and brand by making your external apps fly!
• Use throughout the development lifecycle - Reduce the risk of introducing performance issues with new code releases by using DBTuna accross the dev lifecycle

The screenshots below show the major workspaces within the product.

Click above to view DBTuna for PostgreSQL Screenshots

Historical PostgreSQL Performance

The DBTuna Activity View is the main view within DBTuna where historical activity and performance information is displayed; including:

• Time series activity graphs showing PostgreSQL resource consumption versus number of completed database queries.
• Completely configurable views, from last 5 minutes to last 30 days.
• Breakdown of activity by Active or Waiting (e.g. Locked)
• Correlated drilldown by Server, SQL, Grouped SQL, User, Session, Database

PostgreSQL Performance Statistics

The DBTuna Statistics View displays historical statistical information on your PostgreSQL database:

• Report and analyze activity by transaction
• Report cache hit rate per database
• View tuple access type over time
• View and report on standby conflicts (version 9.0 and later)

SQL Drilldown

Once poorly performing SQL has been identified by DBTuna the DBA can drill into the SQL View to display details of the statement and explain plan:

• One click statement analysis shows the SQL Explain plan to quickly see if it has the optimum access path.
• View the performance of the SQL historically.
• Display wait states correlated with SQL.

PostgreSQL Objects View

The DBTuna Objects View displays current PostgreSQL configuration parameters and properties, as well as information related to database objects:

• One-click view to check or cross reference Database config values.
• Quickly view all information for a specific object - also displayed in correlation with a SQL Explain Plan
• Display historical config changes to your PostgreSQL instance

Comprehensive Performance Reports

DBTuna has many powerful historical reports including:

• Time Series Comparison - compare two periods of time and immediately quantify the difference in performance between them. Ideal for comparing seperate load tests, or for investigating problematic time periods in production.
• Top N SQL Report - Powerful visualizations to report on your Top SQL Statements over time

Download DBTuna Today! Download now and run a no-obligation trial for 7 days
See how a real customer is using DBTuna Find out how Betfair use DBTuna to monitor some of the worlds busiest databases.