diff options
| author | Stephen Frost <sfrost@snowman.net> | 2021-03-16 14:46:48 -0400 |
|---|---|---|
| committer | Stephen Frost <sfrost@snowman.net> | 2021-03-16 14:46:48 -0400 |
| commit | 94d13d474dc61800e8a17cc1959c55815b050ecd (patch) | |
| tree | d64934303dc5b781cc221f30482deb241ebdca09 /doc/src | |
| parent | 1ea396362be1615e926ea69d666c770081a0d3ef (diff) | |
| download | postgresql-94d13d474dc61800e8a17cc1959c55815b050ecd.tar.gz postgresql-94d13d474dc61800e8a17cc1959c55815b050ecd.zip | |
Improve logging of auto-vacuum and auto-analyze
When logging auto-vacuum and auto-analyze activity, include the I/O
timing if track_io_timing is enabled. Also, for auto-analyze, add the
read rate and the dirty rate, similar to how that information has
historically been logged for auto-vacuum.
Stephen Frost and Jakub Wartak
Reviewed-By: Heikki Linnakangas, Tomas Vondra
Discussion: https://www.postgresql.org/message-id/VI1PR0701MB69603A433348EDCF783C6ECBF6EF0%40VI1PR0701MB6960.eurprd07.prod.outlook.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index a218d78bef4..5e551b9f6d6 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7457,9 +7457,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; I/O timing information is displayed in <link linkend="monitoring-pg-stat-database-view"> <structname>pg_stat_database</structname></link>, in the output of - <xref linkend="sql-explain"/> when the <literal>BUFFERS</literal> option is - used, and by <xref linkend="pgstatstatements"/>. Only superusers can - change this setting. + <xref linkend="sql-explain"/> when the <literal>BUFFERS</literal> option + is used, by autovacuum for auto-vacuums and auto-analyzes, when + <xref linkend="guc-log-autovacuum-min-duration"/> is set and by + <xref linkend="pgstatstatements"/>. Only superusers can change this + setting. </para> </listitem> </varlistentry> |