diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-02-14 02:03:44 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-02-14 02:03:44 +0000 |
| commit | e93b33754c69d6cdc663f320ad9d31ac21112597 (patch) | |
| tree | 303111a291fd0f313b68af00483e0276b5e29b70 | |
| parent | 2fc80b9ae6000ccf9223812b9149375abf0ee579 (diff) | |
| download | postgresql-e93b33754c69d6cdc663f320ad9d31ac21112597.tar.gz postgresql-e93b33754c69d6cdc663f320ad9d31ac21112597.zip | |
Document that xact commit/abort stats are collected if any stat variable
is set.
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 9ddfc28ff49..07d9b2a281c 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.29 2005/10/06 02:29:06 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/monitoring.sgml,v 1.30 2006/02/14 02:03:44 momjian Exp $ --> <chapter id="monitoring"> @@ -145,10 +145,15 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re overhead occurs. These respectively determine whether a server process sends its current command string, disk-block-level access statistics, and row-level access statistics to the collector. - Normally these parameters are set in <filename>postgresql.conf</> - so that they apply to all server processes, but it is possible to - turn them on or off in individual sessions using the <xref - linkend="sql-set" endterm="sql-set-title"> command. (To prevent + Additionally, per-database transaction commit and abort statistics + are collected if any of these parameters are set. + </para> + + <para> + Normally these parameters are set in <filename>postgresql.conf</> so + that they apply to all server processes, but it is possible to turn + them on or off in individual sessions using the <xref + linkend="sql-set" endterm="sql-set-title"> command. (To prevent ordinary users from hiding their activity from the administrator, only superusers are allowed to change these parameters with <command>SET</>.) |