Commit10a5b35

committed

Report resource usage at the end of recovery

Reporting this has been rather useful in some recent recovery speedupwork. It also seems like something that will be useful to the average DBAtoo.Author: David RowleyReviewed-by: Thomas MunroDiscussion:https://postgr.es/m/CAApHDvqYVORiZxq2xPvP6_ndmmsTkvr6jSYv4UTNaFa5i1kd%3DQ%40mail.gmail.com

1 parent62e221e commit10a5b35Copy full SHA for 10a5b35

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -76,6 +76,7 @@`
`76`	`76`	`#include"utils/memutils.h"`
`77`	`77`	`#include"utils/ps_status.h"`
`78`	`78`	`#include"utils/relmapper.h"`
	`79`	`+#include"utils/pg_rusage.h"`
`79`	`80`	`#include"utils/snapmgr.h"`
`80`	`81`	`#include"utils/timestamp.h"`
`81`	`82`
`@@ -7169,6 +7170,9 @@ StartupXLOG(void)`
`7169`	`7170`	`{`
`7170`	`7171`	`ErrorContextCallbackerrcallback;`
`7171`	`7172`	`TimestampTzxtime;`
	`7173`	`+PGRUsageru0;`
	`7174`	`+`
	`7175`	`+pg_rusage_init(&ru0);`
`7172`	`7176`
`7173`	`7177`	`InRedo= true;`
`7174`	`7178`
`@@ -7435,8 +7439,9 @@ StartupXLOG(void)`
`7435`	`7439`	`}`
`7436`	`7440`
`7437`	`7441`	`ereport(LOG,`
`7438`		`-(errmsg("redo done at %X/%X",`
`7439`		`-(uint32) (ReadRecPtr >>32), (uint32)ReadRecPtr)));`
	`7442`	`+(errmsg("redo done at %X/%X system usage: %s",`
	`7443`	`+(uint32) (ReadRecPtr >>32), (uint32)ReadRecPtr,`
	`7444`	`+pg_rusage_show(&ru0))));`
`7440`	`7445`	`xtime=GetLatestXTime();`
`7441`	`7446`	`if (xtime)`
`7442`	`7447`	`ereport(LOG,`

Comments

(0)