pgsql: Add per-index stats information in verbose logs of autovacuum
От | Michael Paquier |
---|---|
Тема | pgsql: Add per-index stats information in verbose logs of autovacuum |
Дата | |
Msg-id | E1lOYeE-0001Wg-Kj@gemulon.postgresql.org обсуждение исходный текст |
Ответы |
Re: pgsql: Add per-index stats information in verbose logs of autovacuum
|
Список | pgsql-committers |
Add per-index stats information in verbose logs of autovacuum Once a relation's autovacuum is completed, the logs include more information about this relation state if the threshold of log_autovacuum_min_duration (or its relation option) is reached, with for example contents about the statistics of the VACUUM operation for the relation, WAL and system usage. This commit adds more information about the statistics of the relation's indexes, with one line of logs generated for each index. The index stats were already calculated, but not printed in the context of autovacuum yet. While on it, some refactoring is done to keep track of the index statistics directly within LVRelStats, simplifying some routines related to parallel VACUUMs. Author: Masahiko Sawada Reviewed-by: Michael Paquier, Euler Taveira Discussion: https://postgr.es/m/CAD21AoAy6SxHiTivh5yAPJSUE4S=QRPpSZUdafOSz0R+fRcM6Q@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/5aed6a1fc214913de9ac69c1717dc64a2483e16d Modified Files -------------- src/backend/access/heap/vacuumlazy.c | 133 +++++++++++++++++++++-------------- 1 file changed, 81 insertions(+), 52 deletions(-)
В списке pgsql-committers по дате отправления: