Commit320545b

committed

Add information about WAL buffers being full to EXPLAIN (WAL)

This is similar toce5bcc4, relying on the addition ofwal_buffers_full to WalUsage. This time, the information is added tothe output generated by EXPLAIN (WAL).Author: Bertrand DrouvotReviewed-by: Ilia EvdokimovDiscussion:https://postgr.es/m/Z6SOha5YFFgvpwQY@ip-10-97-1-34.eu-west-3.compute.internal

1 parentce5bcc4 commit320545bCopy full SHA for 320545b

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -242,8 +242,9 @@ ROLLBACK;`
`242`	`242`	`<listitem>`
`243`	`243`	`<para>`
`244`	`244`	`Include information on WAL record generation. Specifically, include the`
`245`		`- number of records, number of full page images (fpi) and the amount of WAL`
`246`		`- generated in bytes. In text format, only non-zero values are printed.`
	`245`	`+ number of records, number of full page images (fpi), the amount of WAL`
	`246`	`+ generated in bytes and the number of times the WAL buffers became full.`
	`247`	`+ In text format, only non-zero values are printed.`
`247`	`248`	`This parameter may only be used when <literal>ANALYZE</literal> is also`
`248`	`249`	`enabled. It defaults to <literal>FALSE</literal>.`
`249`	`250`	`</para>`

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4242,7 +4242,7 @@ show_wal_usage(ExplainState es, const WalUsage usage)`
`4242`	`4242`	`{`
`4243`	`4243`	`/* Show only positive counter values. */`
`4244`	`4244`	`if ((usage->wal_records>0)\|\| (usage->wal_fpi>0)\|\|`
`4245`		`-(usage->wal_bytes>0))`
	`4245`	`+(usage->wal_bytes>0)\|\| (usage->wal_buffers_full>0))`
`4246`	`4246`	`{`
`4247`	`4247`	`ExplainIndentText(es);`
`4248`	`4248`	`appendStringInfoString(es->str,"WAL:");`
`@@ -4256,6 +4256,9 @@ show_wal_usage(ExplainState es, const WalUsage usage)`
`4256`	`4256`	`if (usage->wal_bytes>0)`
`4257`	`4257`	`appendStringInfo(es->str," bytes="UINT64_FORMAT,`
`4258`	`4258`	`usage->wal_bytes);`
	`4259`	`+if (usage->wal_buffers_full>0)`
	`4260`	`+appendStringInfo(es->str," buffers full=%lld",`
	`4261`	`+ (long long)usage->wal_buffers_full);`
`4259`	`4262`	`appendStringInfoChar(es->str,'\n');`
`4260`	`4263`	`}`
`4261`	`4264`	`}`
`@@ -4267,6 +4270,8 @@ show_wal_usage(ExplainState es, const WalUsage usage)`
`4267`	`4270`	`usage->wal_fpi,es);`
`4268`	`4271`	`ExplainPropertyUInteger("WAL Bytes",NULL,`
`4269`	`4272`	`usage->wal_bytes,es);`
	`4273`	`+ExplainPropertyInteger("WAL Buffers Full",NULL,`
	`4274`	`+usage->wal_buffers_full,es);`
`4270`	`4275`	`}`
`4271`	`4276`	`}`
`4272`	`4277`

Comments

(0)