| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | 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 14:54:31 |
| Message-ID: | 1313679271.19987.18.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-08-18 15:13:13 | Re: Displaying accumulated autovacuum cost |
| Previous Message | Robert Haas | 2011-08-18 14:21:29 | Re: Change format of FDW options used in \d* commands |