|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.29 2005/10/06 02:29:06 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.30 2006/02/14 02:03:44 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <chapter id="monitoring"> |
@@ -145,10 +145,15 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re |
145 | 145 | overhead occurs. These respectively determine whether a server |
146 | 146 | process sends its current command string, disk-block-level access |
147 | 147 | statistics, and row-level access statistics to the collector. |
148 | | - Normally these parameters are set in <filename>postgresql.conf</> |
149 | | - so that they apply to all server processes, but it is possible to |
150 | | - turn them on or off in individual sessions using the <xref |
151 | | - linkend="sql-set" endterm="sql-set-title"> command. (To prevent |
| 148 | + Additionally, per-database transaction commit and abort statistics |
| 149 | + are collected if any of these parameters are set. |
| 150 | + </para> |
| 151 | + |
| 152 | + <para> |
| 153 | + Normally these parameters are set in <filename>postgresql.conf</> so |
| 154 | + that they apply to all server processes, but it is possible to turn |
| 155 | + them on or off in individual sessions using the <xref |
| 156 | + linkend="sql-set" endterm="sql-set-title"> command. (To prevent |
152 | 157 | ordinary users from hiding their activity from the administrator, |
153 | 158 | only superusers are allowed to change these parameters with |
154 | 159 | <command>SET</>.) |
|