Monitoring

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Link to new Munin setup article)
(Start work on postgres contrib extensions)
Line 1: Line 1:
== Statistics collector ==
+
== PostgreSQL builtin & contrib ==
 +
 
 +
=== Statistics collector ===
 +
 
 +
PostgreSQL collects lots of data on its own and offers it via the <tt>pg_stat(io)_</tt> system views
  
 
* 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]
 +
 +
=== contrib extensions ===
 +
 +
The following extensions offer access to Postgres internals which may be of interest or collect additional information. Most of them are shipped with Postgres (the <tt>-contrib</tt> packages may need to be installed) and can be activated via the [http://www.postgresql.org/docs/current/static/sql-createextension.html extension interface].
 +
 +
==== pg_stat_statements ====
 +
 +
 +
==== pg_stat_plans ====
 +
 +
==== pgstattuple ====
 +
 +
==== pg_buffercache ====
  
 
== Monitoring PostgreSQL with [http://munin-monitoring.org Munin]  ==
 
== Monitoring PostgreSQL with [http://munin-monitoring.org Munin]  ==

Revision as of 13:47, 22 October 2013

Contents

PostgreSQL builtin & contrib

Statistics collector

PostgreSQL collects lots of data on its own and offers it via the pg_stat(io)_ system views

contrib extensions

The following extensions offer access to Postgres internals which may be of interest or collect additional information. Most of them are shipped with Postgres (the -contrib packages may need to be installed) and can be activated via the extension interface.

pg_stat_statements

pg_stat_plans

pgstattuple

pg_buffercache

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.
  • PostgreSQL Monitoring With Munin. Detailed setup instructions for common Linux platforms.

Cacti

SNMP agent

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

Personal tools