因工作原因，这周开始学习Postgresql监控工具。

从最近从网上搜索的结果来看，有关Postgresql的监控工具，相关讨论并不热烈。关于Pgwatch工具的安装使用，我只看到一篇http://blog.csdn.net/lengzijian/article/details/8127207?reload#reply ，其他都是转载的这片文章。不过我到最后也是得到空的report。目前还没试出来。Pgwatch官网也只说停止目前1.0版本的开发，现正在进行2.0版本的开发。

以下是从postgresql官网得到的关于Postgresql的监控工具列表。目前计划选择 Cacti plugin，EnterpriseDB Postgres Enterprise Manager ，pgwatch 和 OPM来测试评估。

Generic monitoring solutions with plugins

Munin

Postgresql Plugins developed in Perl are included in the CoreMuninDistribution. The following plugins are included by default:postgres_bgwriter,postgres_locks_,postgres_tuples_,postgres_cache_,postgres_querylength_,postgres_users,postgres_checkpoints,postgres_scans_,postgres_xlog,postgres_connections_,postgres_size_,postgres_connections_db,postgres_transactions_

PyMuninincludes a Multigraph Munin Plugin written in Python that implements the following graphs:pg_connections,pg_diskspace,pg_blockreads,pg_xact,pg_tup_read,pg_tup_write,pg_blockreads_detail,pg_xact_commit_detail,pg_xact_rollback_detail,pg_tup_return_detail,pg_tup_fetch_detail,pg_tup_delete_detail,pg_tup_update_detail,pg_tup_insert_detail

Detailed setup instructions for common Linux platforms can be found athighperfpostgres.com

Zabbix

pg_monzis aZabbixmonitoring template for Postgres.

NewRelic

NewRelicis a commercial SaaS application monitoring solution which offers aPostgreSQL pluginmaintained by EnterpriseDB.

Cacti

There has been work done on building a Postgres template forCacti,Details can be found at theCactipage.

Postgres-centric monitoring solutions

EnterpriseDB Postgres Enterprise Manager

Postgres Enterprise Manageris a commercial application offered by EnterpriseDB which covers many aspects of Postgres operations & monitoring in large environments.

pganalyze

pganalyzeis a commercial SaaS offering which focuses on performance monitoring and automated tuning suggestions.

pgwatch

pgwatchis a PHP web application which offers interactive graphs for relevant Postgres data.

pg_statsinfo & pg_stats_reporter

pg_statsinfois a Postgres extension that collects lots of performance-relevant information inside the Postgres server which then can be aggregated by pg_stats_reporter instances which provide a web interface to the collected data. Both are FOSS software maintained by NTT.

PGObserver

PGObserveris a Python & Java-based Postgres monitoring solution developed by Zalando. It was developed with a focus on stored procedure performance but extended well beyond that.

pgCluu

pgCluuis a Perl-based monitoring solution which uses psql andsarto collect information about Postgres servers and render comprehensive performance stats.

PoWA

PoWAis a Postgresql Workload Analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your Postgresql servers.

OPM: Open Postgresql Monitoring

Open PostgreSQL Monitoring (OPM)is a free software suite designed to help you manage your Postgresql servers. It's a flexible tool that will follow the activity of each instance. It can gather stats,display dashboards and send warnings when something goes wrong. The long-term goal of the project is to provide similar features to those of Oracle Grid Control or sql Server Management Studio.