PostgreSQL 9.0 High Performance

Chapter 11. Database Activity and Statistics

PostgreSQL includes a subsystem named the statistics collector that allows monitoring various aspects of the database internals. Each of the processes in the server send statistics messages to the collector, which then totals the results and periodically publishes the results to where you can see them. By default (the interval is a compile-time option), statistics updates are published every half second. Each of the statistics values is available using a set of functions that return the current value, all documented at http://www.postgresql.org/docs/current/static/monitoring-stats.html.

Statistics views

In practice, a series of views that organize this data are how most people access the statistics collector's ...