Re: Displaying accumulated autovacuum cost - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Displaying accumulated autovacuum cost
Date
Msg-id 1313679271.19987.18.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Displaying accumulated autovacuum cost  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Displaying accumulated autovacuum cost
Re: Displaying accumulated autovacuum cost
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Change format of FDW options used in \d* commands
Next
From: Robert Haas
Date:
Subject: Re: Displaying accumulated autovacuum cost