public inbox for [email protected]
help / color / mirror / Atom feedpg_stat_statements doc tweaks
4+ messages / 3 participants
[nested] [flat]
* pg_stat_statements doc tweaks
@ 2015-05-05 23:42 Ian Barwick <[email protected]>
2015-05-09 18:11 ` Re: pg_stat_statements doc tweaks Bruce Momjian <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Ian Barwick @ 2015-05-05 23:42 UTC (permalink / raw)
To: pgsql-docs
Hi
I noticed that the pg_stat_statement docs [*] seem to imply that if you load
pg_stat_statements via 'shared_preload_libraries', a "system view"
named 'pg_stat_statements' will be created, presumably in the pg_catalog
schema. However the requirement to install the extension to access the
(non-system) view isn't mentioned until after the (lengthy) view description.
[*] http://www.postgresql.org/docs/devel/static/pgstatstatements.html
I've refactored this slightly to put the installation details at the top, and
remove the term "system view".
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml
new file mode 100644
index 04b3f01..4d7a6e6
*** a/doc/src/sgml/pgstatstatements.sgml
--- b/doc/src/sgml/pgstatstatements.sgml
***************
*** 19,30 ****
This means that a server restart is needed to add or remove the module.
</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
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
--- 19,40 ----
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
! 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,234 ****
</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
database.
</para>
--- 226,234 ----
</table>
<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
database.
</para>
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/plain] pgss-doc.patch (2.9K, 2-pgss-doc.patch)
download | inline diff:
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml
new file mode 100644
index 04b3f01..4d7a6e6
*** a/doc/src/sgml/pgstatstatements.sgml
--- b/doc/src/sgml/pgstatstatements.sgml
***************
*** 19,30 ****
This means that a server restart is needed to add or remove the module.
</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
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
--- 19,40 ----
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
! 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,234 ****
</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
database.
</para>
--- 226,234 ----
</table>
<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
database.
</para>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_stat_statements doc tweaks
2015-05-05 23:42 pg_stat_statements doc tweaks Ian Barwick <[email protected]>
@ 2015-05-09 18:11 ` Bruce Momjian <[email protected]>
2015-05-10 21:57 ` Re: pg_stat_statements doc tweaks Ian Barwick <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2015-05-09 18:11 UTC (permalink / raw)
To: Ian Barwick <[email protected]>; +Cc: pgsql-docs
On Wed, May 6, 2015 at 08:42:02AM +0900, Ian Barwick wrote:
> Hi
>
> I noticed that the pg_stat_statement docs [*] seem to imply that if you load
> pg_stat_statements via 'shared_preload_libraries', a "system view"
> named 'pg_stat_statements' will be created, presumably in the pg_catalog
> schema. However the requirement to install the extension to access the
> (non-system) view isn't mentioned until after the (lengthy) view description.
>
> [*] http://www.postgresql.org/docs/devel/static/pgstatstatements.html
>
> I've refactored this slightly to put the installation details at the top, and
> remove the term "system view".
Patch applied, thanks.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_stat_statements doc tweaks
2015-05-05 23:42 pg_stat_statements doc tweaks Ian Barwick <[email protected]>
2015-05-09 18:11 ` Re: pg_stat_statements doc tweaks Bruce Momjian <[email protected]>
@ 2015-05-10 21:57 ` Ian Barwick <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Ian Barwick @ 2015-05-10 21:57 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; Ian Barwick <[email protected]>; +Cc: pgsql-docs
On 10/05/15 03:11, Bruce Momjian wrote:
> On Wed, May 6, 2015 at 08:42:02AM +0900, Ian Barwick wrote:
>> Hi
>>
>> I noticed that the pg_stat_statement docs [*] seem to imply that if you load
>> pg_stat_statements via 'shared_preload_libraries', a "system view"
>> named 'pg_stat_statements' will be created, presumably in the pg_catalog
>> schema. However the requirement to install the extension to access the
>> (non-system) view isn't mentioned until after the (lengthy) view description.
>>
>> [*] http://www.postgresql.org/docs/devel/static/pgstatstatements.html
>>
>> I've refactored this slightly to put the installation details at the top, and
>> remove the term "system view".
>
> Patch applied, thanks.
Thanks!
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* pg_stat_statements doc tweaks
@ 2015-05-06 00:45 Ian Barwick <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Ian Barwick @ 2015-05-06 00:45 UTC (permalink / raw)
To: pgsql-docs
Hi
I noticed that the pg_stat_statement docs [*] seem to imply that if you load
pg_stat_statements via 'shared_preload_libraries', a "system view"
named 'pg_stat_statements' will be created, presumably in the pg_catalog
schema. However the requirement to install the extension to access the
(non-system) view isn't mentioned until after the (lengthy) view description.
[*] http://www.postgresql.org/docs/devel/static/pgstatstatements.html
I've refactored this slightly to put the installation details at the top, and
remove the term "system view".
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml
new file mode 100644
index 04b3f01..4d7a6e6
*** a/doc/src/sgml/pgstatstatements.sgml
--- b/doc/src/sgml/pgstatstatements.sgml
***************
*** 19,30 ****
This means that a server restart is needed to add or remove the module.
</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
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
--- 19,40 ----
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
! 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,234 ****
</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
database.
</para>
--- 226,234 ----
</table>
<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
database.
</para>
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/plain] pgss-doc.patch (2.9K, 2-pgss-doc.patch)
download | inline diff:
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml
new file mode 100644
index 04b3f01..4d7a6e6
*** a/doc/src/sgml/pgstatstatements.sgml
--- b/doc/src/sgml/pgstatstatements.sgml
***************
*** 19,30 ****
This means that a server restart is needed to add or remove the module.
</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
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
--- 19,40 ----
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
! 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,234 ****
</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
database.
</para>
--- 226,234 ----
</table>
<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
database.
</para>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2015-05-10 21:57 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-05-05 23:42 pg_stat_statements doc tweaks Ian Barwick <[email protected]>
2015-05-09 18:11 ` Bruce Momjian <[email protected]>
2015-05-10 21:57 ` Ian Barwick <[email protected]>
2015-05-06 00:45 pg_stat_statements doc tweaks Ian Barwick <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox