Monitoring

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
m (pg_buffercache: formatting fail)
(new outline)
Line 28: Line 28:
 
<tt>[http://www.postgresql.org/docs/current/static/pgbuffercache.html pg_buffercache]</tt> gives you introspection into Postgres' [http://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-SHARED-BUFFERS shared buffers], showing how many pages of which relations are currently held in the cache.
 
<tt>[http://www.postgresql.org/docs/current/static/pgbuffercache.html pg_buffercache]</tt> gives you introspection into Postgres' [http://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-SHARED-BUFFERS shared buffers], showing how many pages of which relations are currently held in the cache.
  
== Monitoring PostgreSQL with [http://munin-monitoring.org Munin] ==
+
== External projects ==
 +
 
 +
=== Checkers ===
 +
 
 +
==== check_postgres ====
 +
 
 +
=== Interfaces & collectors ===
 +
 
 +
==== pgsnmpd ====
 +
 
 +
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
 +
 
 +
 
 +
==== pganalyze-collector ====
 +
 
 +
 
 +
=== Generic monitoring solutions with plugins ===
 +
 
 +
==== 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_.
 
* 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_.
Line 34: Line 54:
 
* [http://highperfpostgres.com/guides/postgresql-monitoring-with-munin/ PostgreSQL Monitoring With Munin].  Detailed setup instructions for common Linux platforms.
 
* [http://highperfpostgres.com/guides/postgresql-monitoring-with-munin/ PostgreSQL Monitoring With Munin].  Detailed setup instructions for common Linux platforms.
  
== Cacti ==
+
==== NewRelic ====
 +
 
 +
==== Cacti ====
  
 
* [[Cacti]]
 
* [[Cacti]]
  
== SNMP agent ==
 
  
Useful for network management systems which are limited to SNMP protocol.
+
=== Postgres-centric monitoring solutions ===
 +
 
 +
==== EnterpriseDB Postgres Enterprise Manager ====
 +
 
 +
==== pganalyze ====
 +
 
 +
==== pgwatch ====
  
* [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 14:29, 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_statements tracks all queries that are executed on the server and records average runtime per query "class" among other parameters.

pg_stat_plans

pg_stat_plans extends on pg_stat_statements and records query plans for all executed quries. This is very helpful when you're experiencing performance regressions due to inefficient query plans due to changed parameters or table sizes.

pgstattuple

pgstattuple can generate statistics for tables and indexes, showing how much space in each table & index is consumed by live tuples, deleted tuples as well as how much unused space is available in each relation.

pg_buffercache

pg_buffercache gives you introspection into Postgres' shared buffers, showing how many pages of which relations are currently held in the cache.

External projects

Checkers

check_postgres

Interfaces & collectors

pgsnmpd

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


pganalyze-collector

Generic monitoring solutions with plugins

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.

NewRelic

Cacti


Postgres-centric monitoring solutions

EnterpriseDB Postgres Enterprise Manager

pganalyze

pgwatch

Personal tools