Commitb7ce6de

Amit Kapila

committed

Allow autovacuum to log WAL usage statistics.

This commit allows autovacuum to log WAL usage statistics added by commitdf3b181.Author: Julien RouhaudReviewed-by: Dilip Kumar and Amit KapilaDiscussion:https://postgr.es/m/CAB-hujrP8ZfUkvL5OYETipQwA=e3n7oqHFU=4ZLxWS_Cza3kQQ@mail.gmail.com

1 parent8ef9451 commitb7ce6deCopy full SHA for b7ce6de

File tree

+12

-1

lines changed

+12

-1

lines changed

Lines changed: 12 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -410,6 +410,8 @@ heap_vacuum_rel(Relation onerel, VacuumParams *params,`
`410`	`410`	`intnindexes;`
`411`	`411`	`PGRUsageru0;`
`412`	`412`	`TimestampTzstarttime=0;`
	`413`	`+WalUsagewalusage_start=pgWalUsage;`
	`414`	`+WalUsagewalusage= {0,0,0};`
`413`	`415`	`longsecs;`
`414`	`416`	`intusecs;`
`415`	`417`	`doubleread_rate,`
`@@ -614,6 +616,9 @@ heap_vacuum_rel(Relation onerel, VacuumParams *params,`
`614`	`616`
`615`	`617`	`TimestampDifference(starttime,endtime,&secs,&usecs);`
`616`	`618`
	`619`	`+memset(&walusage,0,sizeof(WalUsage));`
	`620`	`+WalUsageAccumDiff(&walusage,&pgWalUsage,&walusage_start);`
	`621`	`+`
`617`	`622`	`read_rate=0;`
`618`	`623`	`write_rate=0;`
`619`	`624`	`if ((secs>0)\|\| (usecs>0))`
`@@ -666,7 +671,13 @@ heap_vacuum_rel(Relation onerel, VacuumParams *params,`
`666`	`671`	`(long long)VacuumPageDirty);`
`667`	`672`	`appendStringInfo(&buf,_("avg read rate: %.3f MB/s, avg write rate: %.3f MB/s\n"),`
`668`	`673`	`read_rate,write_rate);`
`669`		`-appendStringInfo(&buf,_("system usage: %s"),pg_rusage_show(&ru0));`
	`674`	`+appendStringInfo(&buf,_("system usage: %s\n"),pg_rusage_show(&ru0));`
	`675`	`+appendStringInfo(&buf,`
	`676`	`+_("WAL usage: %ld records, %ld full page writes, "`
	`677`	`+UINT64_FORMAT" bytes"),`
	`678`	`+walusage.wal_records,`
	`679`	`+walusage.wal_num_fpw,`
	`680`	`+walusage.wal_bytes);`
`670`	`681`
`671`	`682`	`ereport(LOG,`
`672`	`683`	`(errmsg_internal("%s",buf.data)));`

Comments

(0)