Re: Add mode column to pg_stat_progress_vacuum

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: Add mode column to pg_stat_progress_vacuum
Дата
Msg-id CAA5RZ0t5hrrYik1wrBK0EN19tkTcDvxy73mcFNoM92PgFhwHcg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add mode column to pg_stat_progress_vacuum  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: Add mode column to pg_stat_progress_vacuum
Список pgsql-hackers
> >  I wonder if we could be even more granular
> > for the "normal autovacuum" case and point to the reason the table was
> > chosen.  For example, was it the insert threshold, the update/delete
> > threshold, etc.?
>
> Sounds like reasonable information. I guess we might want to have such
> information in a cumulative statistics view but do you think it's
> better to have it in a dynamic statistics view?

+1 for this information in cumulative stats, on a per table level for sure.
I do think however the pg_stat_all_tables views is getting too wide
and moving new relation vacuum stats to a separate stats view will
be very useful.

--
Sami



В списке pgsql-hackers по дате отправления: