Databases don’t get anymore advanced than PostgreSQL. However just like any other database, PostgreSQL needs to be managed closely to keep the database up and running. The group of monitoring tools for PostgreSQL is slightly more narrow than many other leading database providers.
That’s why in this article we’re going to look at the nine best PostgreSQL Monitoring tools. However if you only have time for a quick summary, here is our list of the best PostgreSQL monitoring tools:
- SolarWinds Server & Application Monitor (FREE TRIAL) An extensive database monitor for PostgreSQL, MySQL, Apache, MongoDBM, Tomcat, and Cassandra databases.
- Paessler PRTG Network Monitor (FREE TRIAL) Network, server, and application monitor that includes a specialist sensor for PostgreSQL databases.
- AppOptics APM (FREE TRIAL) Cloud-based application performance monitor that includes a utility for PostgreSQL optimization.
- AppDynamics Database monitor that can watch PostgreSQL, among others, and allows a full view of database transactions right down to code efficiency.
- ManageEngine Applications Manager Part of a suite of infrastructure management tools, this facility monitors a range of RDMSs, including PostgreSQL.
- ClusterControl A database monitoring tool that can supervise PostgreSQL databases. Available in free and paid versions.
- pgAdmin Free, open source PostgreSQL management tool available online or downloadable for Windows, Mac OS, and Linux.
- Pganalyze A low-cost query optimizer for PostgreSQL.
- pgCluu Free, open source PostgreSQL performance and auditing tool.
- Nagios Core and Nagios XI Free and paid versions of an extendible infrastructure monitor that will monitor PostgreSQL database statuses.
The best PostgreSQL monitoring tools
SolarWinds Server & Application Monitor is an application monitoring tool that monitors PostgreSQL databases. The software can measure database size, table size, active database and server connections, indexes, locks, triggers, successful transaction rates, and more. Postgres shows them on the dashboard. The dashboard is comprised of a range of visual displays ranging from performance dials to more complex charts and graphs.
Out-of-the-box, SolarWinds Server & Application Monitor includes over 200 monitoring templates for PostGreSQL, MySQL, MongoDBm Apache, Tomcat, Cassandra and many other providers. There are also over 800 monitoring templates that have been created by the users and shared on Thwack (SolarWinds’ online user community).
Intelligent alerts update you on changes to PostgreSQL performance. If CPU usage is higher than normal you will be sent an alert. Alerts are configured based on thresholds where a performance baseline is established and alerts are sent when there is a deviation from that baseline. The system has been built to minimize false positives.
SolarWinds Server & Application Monitor is ideal for small to midsize enterprises looking for a Postgre monitoring solutions that’s easy to install and manage. SolarWinds Server & Application Monitor starts at a price of $2,995 (£2,404). You can also download the free trial.
Paessler PRTG Network Monitor is a network monitoring tool that includes a sensor designed for PostgreSQL. The PostgreSQL Sensor monitors databases on a PostgreSQL server and queries it for metrics. The sensor can monitor the execution time of the request, execution time of the query, the number of rows that were addressed by the query, and access data table information. The information is broken down into dials and can be viewed as Live Data, Historic Data or over the past 2, 30, or 365 days.
To help you monitor sensors when you’re not at your desk, PRTG Network Monitor uses notifications. Notifications are sent to you by email, SMS, or push notifications (to Android and IOS devices) when thresholds are breached. For example if the execution time of a query was unusually long, then the program will send you a notification to tell you there’s a problem.
One of the biggest selling points of PRTG Network Monitor is that it’s a free tool (providing you use less than 100 sensors!). If you’re looking to start out in PostgreSQL then this tool is a great entry point that provides a premium monitoring experience.
Paid versions of PRTG Network Monitor start at $1600 (£1,284) for 500 sensors and go up to $14,500 (£11,643) for unlimited sensors with one server installation – there is also a version that supports five server installations for $60,000 (£48,180). You can download the 30-day free trial.
AppOptics APM is a cloud-based application performance monitor that includes tools to improve performance as well as monitoring alerts that head off performance impairment.
Included in the AppOptics APM service are specialized database optimization utilities that are able to interface to the Postgres database management system. The database optimizer focuses on analyzing the SQL queries that extract data. The queries that seem to take a long time to complete get examined with an automatic trace. The trace file details all of the database transactions that the SQL query caused to be executed.
The analysis of each inefficient query results in recommendations for rewriting SQL to create more efficient queries. Database performance can also be improved by adding or removing indexes on the database tables.
The database optimization features in AppOptics APM are not limited to working with PostgreSQL. It is able to interact with many other DBMSs, including Oracle, MySQL, Microsoft SQL Server, and Apache DBMSs.
Applications that rely on database fetches and insertions could have imperfections higher up in their code. The optimization utilities in AppOptics APM can also analyze all code and recommend improvements in programs to speed up processing. Once code and database interactions have been improved, other delivery impairments, such as server performance and network device health can also be improved by the infrastructure monitoring tools in AppOptics.
AppOptics is charged for by subscription with fees charged in advance per year. You can get a 14-day free trial of AppOptics to be sure of its usefulness before you commit to a subscription.
AppDynamics is a premium application performance monitor that is compatible with PostgreSQL. AppDynamics provides you with an in-depth perspective of PostgreSQL performance. Data the software monitors includes transaction activity, tuple access types, cache hit rates, and more. If you see something you’re unsure about, at the click of a button you can visualize the historical performance of an individual query.
To tackle the issue of visibility AppDynamics displays PostgresQL instance objects. Viewing objects from this perspective helps you to understand your current configurations much better. Table Details and Index Information are just some of the details you can take a closer look at.
The alerts system on AppDynamics works off of baselines. AppDynamics collects performance data and establishes baselines to detect anomalous behaviour. Alerts and baselines are sophisticated enough that the software can minimize false alerts so that you only receive legitimate notifications.
Overall, if you require a PostgreSQL monitoring tool that provides deep visibility there are few tools as comprehensive as AppDynamics. AppDynamics can monitor versions 8 and higher of Postgres databases. In order to view the pricing information of the product you will have to contact the company directly. You can download the free trial.
ManageEngine Applications Manager is another top of the line applications monitoring solution that supports PostgreSQL. ManageEngine Applications Manager can monitor information like buffer statistics, connection statistics, disk usage details, query statistics, table scan details, and more. All of this information can be viewed in charts to track how the metric changes over time. All graphs are easy to read at a glance.
The software also offers a responsive alerts system. ManageEngine Applications Manager allows the user to configure dynamic baselines to help identify performance anomalies when they occur. The root cause analysis feature enables you to take a closer look beneath the surface. Likewise, APM Insight actually allows you to view application code and SQL queries to find what started the problem.
Reports allows the user to take a retrospective look at any performance issues that were found. You can view the historic performance and performance trends of Postgres databases. Looking at performance trends in reports is extremely useful when it comes to capacity planning long term.
ManageEngine Applications Manager delivers an accessible but advanced Postgres monitoring experience. ManageEngine Applications Manager is available as a Free tool or as paid versions (Professional and Enterprise versions). In order to view the pricing information of the product you will have to contact the company directly. You can download the 30-day free trial version.
ClusterControl is an advanced database monitoring platform that supports PostgreSQL. ClusterControl combines performance monitoring with database automation to assist users in monitoring their databases. The database automation capabilities of the software automatically deploy and configure PostgreSQL instances so you can manage them. The PostgreSQL streaming replication allows you to configure new or existing replication slaves.
When managing PostgreSQL, visibility is one of the most difficult challenges to address. ClusterControl confronts this issue head-on by including a topology viewer. The topology viewer allows you to display how your database is functioning in one pane of glass.
The automatic failover and recovery feature helps to keep your database secure.The product will automatically promote a new master node when a failure occurs. In the aftermath of a database event, you also have the ability to recover your databases back to an earlier point in time. These features help to make sure that your service stays available no matter what happens.
ClusterControl is available as a community version or as two paid versions. The Community version is available for free with real-time monitoring and community support. The Advanced version includes failure detection and recovery features. The Enterprise version adds role-based access control and reports to the mix as well. In order to view the pricing information of the product you will have to contact the company directly. You can download the free version.
pgAdmin is a widely-used open source PostgreSQL management tool. The tool offers a GUI to manage Postgre databases, an SQL query tool, and a code debugger. There is also a monitoring dashboard and live SQL query tool which you can use to edit queries. The combination of management and monitoring functionalities included with pgAdmin makes the product very versatile.
There are additional features that you can access by using the adminpack contrib (a library) module for PostgreSQL. As part of the expansion you can view server log files in the Server status dialogue view. Information you can monitor through the Server Status dialogue includes the client address, start time, current query, and query start time.
The cross-platform potential and accessibility of pgAdmin makes it a compelling choice no matter how your local environment is structured. The platform is available on Windows, Mac OS, and Linux. The tool itself is available as a web or desktop application. You can download the program for free.
Pganalyze is PostgreSQL performance monitoring software that has been tailor-made to improve visibility into queries. You can use this tool to help discover why a query is running slowly. To do this, you can view statistics such as the I/O cvs CPU time and buffer cache hit ratio to help find the root cause. To help you improve performance, pganalyze tells you whether a query needs an index to boost performance.
You also have complete transparency over your database’s performance history. You can search through queries and view the Query, Role, AVG TIME (MS), CALLS/MIN, I/O%, CACHED %, % of All Runtime to find problematic queries. How far in the past you can do this depends on the version you’re using (see below).
There are three versions of pganalyze available to purchase: Production, Scale, and Enterprise Edition. The Production version costs $99 (£79.50) per month for up to three database servers and 14 days of historic data. The scale version costs $250 (£200) per month for six database servers and 30 days of historic data.
The Enterprise Edition offers an option of on-premises installation with unlimited database servers (but you need to contact the sales team to know the price.) You can download the 14-day free trial version.
pgCluu is a PostgreSQL performance monitor and auditing tool that collects data from your databases cluster. The product is broken down into two parts: a PostgreSQL cluster statistics collector that operates through a command line and a Perl grapher that displays performance data.
Metrics you can monitor with pgCluu include shared buffers utilization per database, the size of all databases, shared buffers usage count distribution, and CPU utilization. This information can be viewed on simple, color-coded charts so there is no ambiguity. You can also generate utilization reports as well.
As an open-sourced alternative, pgCluu is worth considering if you want a PostgreSQL monitoring experience on a budget. You can access the source code from this link.
Nagios Core and Nagios XI are infrastructure monitoring platforms that can measure Postgres performance metrics. The software can monitor PostgreSQL database availability, database size, table size, cache rations, and more. There is also a range of Nagios plugins for monitoring Postgres. For example the check_pgactivity plugin allows you to view the connectivity, streaming replication lag, database hit-ratio, index bloat, and more.
Nagios Core is a free but more limited version of Nagios XI. Nagios XI has the advantage over the two because it has a web-based GUI and other convenient features like monitoring wizards to make configuration easier. If budget is a priority then Nagios Core is the obvious choice but if you want a more convenient monitoring experience then you should opt for Nagios XI.
Nagios XI starts at a price of $1,995 (£1,601) for the Standard Edition which includes configuration wizards and advanced reporting. The Enterprise Edition costs $3,495 (£2,806) with capacity planning reports and audit logging. You can download the free trial.
Choosing a PostgreSQL tool for you
Out of all the tools on this list, AppDynamics, SolarWinds Server & Application Monitor, and Paessler PRTG Network Monitor are our top picks. Each tool has something unique to offer. AppDynamics is a top pick based on its deep-visibility, where as SolarWinds Server & Application Monitor offers a detailed but more accessible user experience.
On the other hand, PRTG Network Monitor strikes the balance between a low price tag and a high value monitoring experience. If you want to go the open-source route then PGadmin is great if you to mix performance monitoring with administration as well.