NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit9eb344f

committed

Allow vacuums to report oldestxmin

Allow VACUUM and Autovacuum to report the oldestxmin value theyused while cleaning tables, helping to make better sense out ofthe other statistics we report in various cases.

1 parent19dc233 commit9eb344fCopy full SHA for 9eb344f

File tree

1 file changed

-4

lines changed

src/backend/commands
- vacuumlazy.c

1 file changed

-4

lines changed

`‎src/backend/commands/vacuumlazy.c`

Lines changed: 5 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -380,10 +380,11 @@ lazy_vacuum_rel(Relation onerel, int options, VacuumParams *params,`
`380`	`380`	`vacrelstats->pinskipped_pages,`
`381`	`381`	`vacrelstats->frozenskipped_pages);`
`382`	`382`	`appendStringInfo(&buf,`
`383`		`-_("tuples: %.0f removed, %.0f remain, %.0f are dead but not yet removable\n"),`
	`383`	`+_("tuples: %.0f removed, %.0f remain, %.0f are dead but not yet removable, oldest xmin: %u\n"),`
`384`	`384`	`vacrelstats->tuples_deleted,`
`385`	`385`	`vacrelstats->new_rel_tuples,`
`386`		`-vacrelstats->new_dead_tuples);`
	`386`	`+vacrelstats->new_dead_tuples,`
	`387`	`+OldestXmin);`
`387`	`388`	`appendStringInfo(&buf,`
`388`	`389`	`_("buffer usage: %d hits, %d misses, %d dirtied\n"),`
`389`	`390`	`VacuumPageHit,`
`@@ -1329,8 +1330,8 @@ lazy_scan_heap(Relation onerel, int options, LVRelStats *vacrelstats,`
`1329`	`1330`	`*/`
`1330`	`1331`	`initStringInfo(&buf);`
`1331`	`1332`	`appendStringInfo(&buf,`
`1332`		`-_("%.0f dead row versions cannot be removed yet.\n"),`
`1333`		`-nkeep);`
	`1333`	`+_("%.0f dead row versions cannot be removed yet, oldest xmin: %u\n"),`
	`1334`	`+nkeep,OldestXmin);`
`1334`	`1335`	`appendStringInfo(&buf,_("There were %.0f unused item pointers.\n"),`
`1335`	`1336`	`nunused);`
`1336`	`1337`	`appendStringInfo(&buf,ngettext("Skipped %u page due to buffer pins.\n",`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit9eb344f

File tree

1 file changed

1 file changed

`‎src/backend/commands/vacuumlazy.c`

0 commit comments