Re: Displaying accumulated autovacuum cost
От | Robert Haas |
---|---|
Тема | Re: Displaying accumulated autovacuum cost |
Дата | |
Msg-id | CA+TgmoYh=GFXBH6BUqRzEHMWVD8o0LZSKfWNuR5LyCX0zmsANQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Displaying accumulated autovacuum cost (Magnus Hagander <magnus@hagander.net>) |
Ответы |
Re: Displaying accumulated autovacuum cost
|
Список | pgsql-hackers |
On Thu, Aug 18, 2011 at 11:14 AM, Magnus Hagander <magnus@hagander.net> wrote: > On Thu, Aug 18, 2011 at 17:13, Robert Haas <robertmhaas@gmail.com> wrote: >> On Thu, Aug 18, 2011 at 10:54 AM, Peter Eisentraut <peter_e@gmx.net> wrote: >>> On tor, 2011-08-18 at 08:39 +0200, Magnus Hagander wrote: >>>> Also, unrelated to that, wouldn't this information be interesting for >>>> non-autovacuum queries as well? >>> >>> Last year we were discussing some details on progress reporting, and >>> some people suggested that instead of printing a single percentage, we >>> should let each type of activity print out whatever metrics it has that >>> would allow an experienced DBA to track the progress. Effectively, this >>> is what this patch is trying to do. >>> >>> So how about adding a column to pg_stat_activity, progress_metrics or >>> something like that, and add that information there. >> >> That might be a good way to go. I don't think we want something like >> pg_stat_all_tables for this, because it seems that Greg's use case is >> to be able to see how a *particular* autovacuum process is doing >> *while it's running*, not to look at aggregate statistics over time. >> Putting it in pg_stat_activity would be good for that. > > It's also good to have it broken down into multiple columns, and not > just a freetext column in the view - if tools should be able to parse > it as well. True. We could have a separate system view that only shows the status of currently-running vacuum proceses. That wouldn't bother me either. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: