Documentation → PostgreSQL 8.3

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 8.3.23 Documentation
Prev	Fast Backward		Fast Forward	Next

Chapter 26. Monitoring Database Activity

Table of Contents

26.1. Standard Unix Tools

26.2. The Statistics Collector

26.2.1. Statistics Collection Configuration
26.2.2. Viewing Collected Statistics

26.3. Viewing Locks

26.4. Dynamic Tracing

26.4.1. Compiling for Dynamic Tracing
26.4.2. Built-in Trace Points
26.4.3. Using Trace Points
26.4.4. Defining Trace Points

A database administrator frequently wonders, "What is the system doing right now?" This chapter discusses how to find that out.

Several tools are available for monitoring database activity and analyzing performance. Most of this chapter is devoted to describing PostgreSQL's statistics collector, but one should not neglect regular Unix monitoring programs such as ps, top, iostat, and vmstat. Also, once one has identified a poorly-performing query, further investigation might be needed using PostgreSQL's EXPLAIN command. Section 14.1 discusses EXPLAIN and other methods for understanding the behavior of an individual query.

Prev	Home	Next
High Availability, Load Balancing, and Replication	Up	Standard Unix Tools