diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2017-03-03 19:18:25 +0530 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2017-03-03 19:18:25 +0530 |
| commit | 9eb344faf54a849898d9be012ddfa8204cfeb57c (patch) | |
| tree | dd22f4e6c238ceabacdc1415e9cfa6300339687b /src | |
| parent | 19dc233c32f2900e57b8da4f41c0f662ab42e080 (diff) | |
| download | postgresql-9eb344faf54a849898d9be012ddfa8204cfeb57c.tar.gz postgresql-9eb344faf54a849898d9be012ddfa8204cfeb57c.zip | |
Allow vacuums to report oldestxmin
Allow VACUUM and Autovacuum to report the oldestxmin value they
used while cleaning tables, helping to make better sense out of
the other statistics we report in various cases.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/commands/vacuumlazy.c | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c index 005440eb392..5d47f16ee4a 100644 --- a/src/backend/commands/vacuumlazy.c +++ b/src/backend/commands/vacuumlazy.c @@ -380,10 +380,11 @@ lazy_vacuum_rel(Relation onerel, int options, VacuumParams *params, vacrelstats->pinskipped_pages, vacrelstats->frozenskipped_pages); appendStringInfo(&buf, - _("tuples: %.0f removed, %.0f remain, %.0f are dead but not yet removable\n"), + _("tuples: %.0f removed, %.0f remain, %.0f are dead but not yet removable, oldest xmin: %u\n"), vacrelstats->tuples_deleted, vacrelstats->new_rel_tuples, - vacrelstats->new_dead_tuples); + vacrelstats->new_dead_tuples, + OldestXmin); appendStringInfo(&buf, _("buffer usage: %d hits, %d misses, %d dirtied\n"), VacuumPageHit, @@ -1329,8 +1330,8 @@ lazy_scan_heap(Relation onerel, int options, LVRelStats *vacrelstats, */ initStringInfo(&buf); appendStringInfo(&buf, - _("%.0f dead row versions cannot be removed yet.\n"), - nkeep); + _("%.0f dead row versions cannot be removed yet, oldest xmin: %u\n"), + nkeep, OldestXmin); appendStringInfo(&buf, _("There were %.0f unused item pointers.\n"), nunused); appendStringInfo(&buf, ngettext("Skipped %u page due to buffer pins.\n", |