From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Greg Smith <greg(at)2ndquadrant(dot)com>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Displaying accumulated autovacuum cost |
Date: | 2011-08-18 15:31:07 |
Message-ID: | CABUevEyxUQO2Y6KMwabb1p+UN9GDxnK1eE+n4ooH18ObP-3oWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Aug 18, 2011 at 17:23, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Thu, Aug 18, 2011 at 11:14 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Thu, Aug 18, 2011 at 17:13, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>> On Thu, Aug 18, 2011 at 10:54 AM, Peter Eisentraut <peter_e(at)gmx(dot)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.
That's what I'd like to have. We could also have aggregate counters on
the table/database level of course.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-08-18 15:41:35 | Re: Displaying accumulated autovacuum cost |
Previous Message | Robert Haas | 2011-08-18 15:23:58 | Re: Displaying accumulated autovacuum cost |