Monitoring

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(edit)
(SNMP)
Line 1: Line 1:
 +
== Statistics collector ==
 +
 
* Official documentation on the [http://www.postgresql.org/docs/current/static/monitoring-stats.html Statistics Collector]
 
* Official documentation on the [http://www.postgresql.org/docs/current/static/monitoring-stats.html Statistics Collector]
 
* [http://www.varlena.com/GeneralBits/107.php Interpreting pg_stat Views]
 
* [http://www.varlena.com/GeneralBits/107.php Interpreting pg_stat Views]
* Monitoring PostgreSQL with [http://munin-monitoring.org Munin]:
+
 
** PostgreSQL Plugins developed in Perl are included in the Core Munin Distribution. 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_.
+
== Monitoring PostgreSQL with [http://munin-monitoring.org Munin] ==
** [http://aouyar.github.com/PyMunin/ PyMunin - Multigraph Munin Plugins in Python] - PyMunin includes a Multigraph Munin Plugin for PostgreSQL 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.
+
 
 +
* PostgreSQL Plugins developed in Perl are included in the Core Munin Distribution. 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_.
 +
* [http://aouyar.github.com/PyMunin/ PyMunin - Multigraph Munin Plugins in Python] - PyMunin includes a Multigraph Munin Plugin for PostgreSQL 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.
 +
 
 +
== SNMP agent ==
 +
 
 +
Useful for network management systems which are limited to SNMP protocol.
 +
 
 +
* [http://pgsnmpd.projects.postgresql.org/ pgsnmpd] implements [http://www.faqs.org/rfcs/rfc1697.html RFC 1697 MIB] which is generic RDBMS MIB
 +
 
  
 
[[Category:Monitoring|!]]
 
[[Category:Monitoring|!]]
 
[[Category:Performance]]
 
[[Category:Performance]]

Revision as of 02:41, 12 October 2012

Statistics collector

Monitoring PostgreSQL with Munin

  • PostgreSQL Plugins developed in Perl are included in the Core Munin Distribution. 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_.
  • PyMunin - Multigraph Munin Plugins in Python - PyMunin includes a Multigraph Munin Plugin for PostgreSQL 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.

SNMP agent

Useful for network management systems which are limited to SNMP protocol.

Personal tools