NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit6e20f46

committed

VACUUM VERBOSE: tweak scanned_pages logic.

Commit872770f taught VACUUM VERBOSE and autovacuum logging todisplay the total number of pages scanned by VACUUM. This informationwas also displayed as a percentage of rel_pages in parenthesis, whichmakes it easy to spot trends over time and across tables.The instrumentation displayed "0 scanned (0.00% of total)" for totallyempty tables. Tweak the instrumentation: have it show "0 scanned(100.00% of total)" for empty tables instead. This approach is clearerand more consistent.

1 parent7e12256 commit6e20f46Copy full SHA for 6e20f46

File tree

1 file changed

-1

lines changed

src/backend/access/heap
- vacuumlazy.c

1 file changed

-1

lines changed

`‎src/backend/access/heap/vacuumlazy.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -676,7 +676,7 @@ heap_vacuum_rel(Relation rel, VacuumParams *params,`
`676`	`676`	`vacrel->removed_pages,`
`677`	`677`	`vacrel->rel_pages,`
`678`	`678`	`vacrel->scanned_pages,`
`679`		`-orig_rel_pages==0 ?0 :`
	`679`	`+orig_rel_pages==0 ?100.0 :`
`680`	`680`	`100.0*vacrel->scanned_pages /orig_rel_pages);`
`681`	`681`	`appendStringInfo(&buf,`
`682`	`682`	`_("tuples: %lld removed, %lld remain, %lld are dead but not yet removable\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!

Commit6e20f46

File tree

1 file changed

1 file changed

`‎src/backend/access/heap/vacuumlazy.c`

0 commit comments