aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2015-05-09 14:11:31 -0400
committerBruce Momjian <bruce@momjian.us>2015-05-09 14:11:31 -0400
commitda31c5ed79d93bb02d6ff9cd81497e5151de7b63 (patch)
treef9d074a2ad1caace8cb40eae3e23572de178b88f
parentcb9fa802b32b222b43e28866c20ebb7125779ec3 (diff)
downloadpostgresql-da31c5ed79d93bb02d6ff9cd81497e5151de7b63.tar.gz
postgresql-da31c5ed79d93bb02d6ff9cd81497e5151de7b63.zip
doc: adjust ordering of pg_stat_statement paragraphs
Clarify installation instructions Patch by Ian Barwick
-rw-r--r--doc/src/sgml/pgstatstatements.sgml26
1 files changed, 13 insertions, 13 deletions
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml
index 04b3f01ed5c..4d7a6e68ea2 100644
--- a/doc/src/sgml/pgstatstatements.sgml
+++ b/doc/src/sgml/pgstatstatements.sgml
@@ -19,12 +19,22 @@
This means that a server restart is needed to add or remove the module.
</para>
+ <para>
+ When <filename>pg_stat_statements</filename> is loaded, it tracks
+ statistics across all databases of the server. To access and manipulate
+ these statistics, the module provides a view, <structname>pg_stat_statements</>,
+ and the utility functions <function>pg_stat_statements_reset</> and
+ <function>pg_stat_statements</>. These are not available globally but
+ can be enabled for a specific database with
+ <command>CREATE EXTENSION pg_stat_statements</>.
+ </para>
+
<sect2>
<title>The <structname>pg_stat_statements</structname> View</title>
<para>
The statistics gathered by the module are made available via a
- system view named <structname>pg_stat_statements</>. This view
+ view named <structname>pg_stat_statements</>. This view
contains one row for each distinct database ID, user ID and query
ID (up to the maximum number of distinct statements that the module
can track). The columns of the view are shown in
@@ -216,19 +226,9 @@
</table>
<para>
- This view, and the functions <function>pg_stat_statements_reset</>
- and <function>pg_stat_statements</>, are available only in
- databases they have been specifically installed into by installing
- the <literal>pg_stat_statements</> extension.
- However, statistics are tracked across all databases of the server
- whenever the <filename>pg_stat_statements</filename> module is loaded
- into the server, regardless of presence of the view.
- </para>
-
- <para>
For security reasons, non-superusers are not allowed to see the SQL
- text or <structfield>queryid</structfield> of queries executed by other users. They can see
- the statistics, however, if the view has been installed in their
+ text or <structfield>queryid</structfield> of queries executed by other users.
+ They can see the statistics, however, if the view has been installed in their
database.
</para>