diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-07-06 14:27:09 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-07-06 14:27:09 +0900 |
| commit | 321fa6a4a26c9b649a0fbec9fc8b019f19e62289 (patch) | |
| tree | e62cc9f65421381ce345259732c1bbdb7aa4a64f /doc/src | |
| parent | aa38434824c4fa52e55a9c7465b24c246caddc81 (diff) | |
| download | postgresql-321fa6a4a26c9b649a0fbec9fc8b019f19e62289.tar.gz postgresql-321fa6a4a26c9b649a0fbec9fc8b019f19e62289.zip | |
doc: Add note about possible performance overhead by enabling track_planning.
Enabling pg_stat_statements.track_plaanning may incur a noticeable
performance penalty, especially when a fewer kinds of queries are executed
on many concurrent connections. This commit documents this note.
Back-patch to v13 where pg_stat_statements.track_plaanning was added.
Suggested-by: Pavel Stehule
Author: Fujii Masao
Reviewed-by: Pavel Stehule
Discussion: https://postgr.es/m/CAFj8pRC9Jxa8r5i0TNBWLb8mzuaYzEoLq3QOvip0jVpHPOLbVA@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pgstatstatements.sgml | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml index 430d8bf07c4..cf2d25b7b22 100644 --- a/doc/src/sgml/pgstatstatements.sgml +++ b/doc/src/sgml/pgstatstatements.sgml @@ -607,6 +607,9 @@ <para> <varname>pg_stat_statements.track_planning</varname> controls whether planning operations and duration are tracked by the module. + Enabling this parameter may incur a noticeable performance penalty, + especially when a fewer kinds of queries are executed on many + concurrent connections. The default value is <literal>off</literal>. Only superusers can change this setting. </para> |