Обсуждение: pg_stat_statements doc tweaks
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
Вложения
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 <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
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