1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>Monitoring Database Activity</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="Server Administration"
16
HREF="admin.html"><LINK
18
TITLE="Standby Server Settings"
19
HREF="standby-settings.html"><LINK
21
TITLE="Standard Unix Tools"
22
HREF="monitoring-ps.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="Standby Server Settings"
57
HREF="standby-settings.html"
66
TITLE="Recovery Configuration"
67
HREF="recovery-config.html"
80
TITLE="Monitoring Disk Usage"
89
TITLE="Standard Unix Tools"
90
HREF="monitoring-ps.html"
105
>Chapter 27. Monitoring Database Activity</H1
111
>Table of Contents</B
115
HREF="monitoring-ps.html"
116
>Standard Unix Tools</A
120
HREF="monitoring-stats.html"
121
>The Statistics Collector</A
127
HREF="monitoring-stats.html#MONITORING-STATS-SETUP"
128
>Statistics Collection Configuration</A
132
HREF="monitoring-stats.html#MONITORING-STATS-VIEWS"
133
>Viewing Collected Statistics</A
139
HREF="monitoring-locks.html"
144
HREF="dynamic-trace.html"
151
HREF="dynamic-trace.html#COMPILING-FOR-TRACE"
152
>Compiling for Dynamic Tracing</A
156
HREF="dynamic-trace.html#TRACE-POINTS"
161
HREF="dynamic-trace.html#USING-TRACE-POINTS"
166
HREF="dynamic-trace.html#DEFINING-TRACE-POINTS"
167
>Defining New Probes</A
174
> A database administrator frequently wonders, <SPAN
177
doing right now?"</SPAN
179
This chapter discusses how to find that out.
182
> Several tools are available for monitoring database activity and
183
analyzing performance. Most of this chapter is devoted to describing
187
>'s statistics collector,
188
but one should not neglect regular Unix monitoring programs such as
202
Also, once one has identified a
203
poorly-performing query, further investigation might be needed using
208
HREF="sql-explain.html"
212
HREF="using-explain.html"
218
and other methods for understanding the behavior of an individual
227
SUMMARY="Footer navigation table"
238
HREF="standby-settings.html"
256
HREF="monitoring-ps.html"
266
>Standby Server Settings</TD
280
>Standard Unix Tools</TD
b'\\ No newline at end of file'