Monitoring
From PostgreSQL wiki
(Difference between revisions)
Lukas.rypl (Talk | contribs) (SNMP) |
Lukas.rypl (Talk | contribs) m |
||
| Line 8: | Line 8: | ||
* 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_. | * 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. | * [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. | ||
| + | |||
| + | == Cacti == | ||
| + | |||
| + | * [[Cacti]] | ||
== SNMP agent == | == SNMP agent == | ||
Latest revision as of 05:34, 12 October 2012
Contents |
Statistics collector
- Official documentation on the Statistics Collector
- Interpreting pg_stat Views
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.
Cacti
SNMP agent
Useful for network management systems which are limited to SNMP protocol.
- pgsnmpd implements RFC 1697 MIB which is generic RDBMS MIB
