Commitcedffbd

committed

Report wait event for cost-based vacuum delay.

1 parent496ee64 commitcedffbdCopy full SHA for cedffbd

File tree

-1

lines changed

-1

lines changed

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1515,6 +1515,8 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser`
`1515`	`1515`	`(<filename>pg_wal</filename>, archive or stream) before trying`
`1516`	`1516`	`again to retrieve WAL data, at recovery.`
`1517`	`1517`	`</entry>`
	`1518`	`+ <entry><literal>VacuumDelay</literal></entry>`
	`1519`	`+ <entry>Waiting in a cost-based vacuum delay point.</entry>`
`1518`	`1520`	`</row>`
`1519`	`1521`	`<row>`
`1520`	`1522`	`<entry morerows="68"><literal>IO</literal></entry>`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2019,7 +2019,9 @@ vacuum_delay_point(void)`
`2019`	`2019`	`if (msec>VacuumCostDelay*4)`
`2020`	`2020`	`msec=VacuumCostDelay*4;`
`2021`	`2021`
	`2022`	`+pgstat_report_wait_start(WAIT_EVENT_VACUUM_DELAY);`
`2022`	`2023`	`pg_usleep((long) (msec*1000));`
	`2024`	`+pgstat_report_wait_end();`
`2023`	`2025`
`2024`	`2026`	`VacuumCostBalance=0;`
`2025`	`2027`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3830,6 +3830,9 @@ pgstat_get_wait_timeout(WaitEventTimeout w)`
`3830`	`3830`	`caseWAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL:`
`3831`	`3831`	`event_name="RecoveryRetrieveRetryInterval";`
`3832`	`3832`	`break;`
	`3833`	`+caseWAIT_EVENT_VACUUM_DELAY:`
	`3834`	`+event_name="VacuumDelay";`
	`3835`	`+break;`
`3833`	`3836`	`/* no default case, so that compiler will warn */`
`3834`	`3837`	`}`
`3835`	`3838`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -850,7 +850,8 @@ typedef enum`
`850`	`850`	`WAIT_EVENT_BASE_BACKUP_THROTTLE=PG_WAIT_TIMEOUT,`
`851`	`851`	`WAIT_EVENT_PG_SLEEP,`
`852`	`852`	`WAIT_EVENT_RECOVERY_APPLY_DELAY,`
`853`		`-WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL`
	`853`	`+WAIT_EVENT_RECOVERY_RETRIEVE_RETRY_INTERVAL,`
	`854`	`+WAIT_EVENT_VACUUM_DELAY`
`854`	`855`	`}WaitEventTimeout;`
`855`	`856`
`856`	`857`	`/* ----------`

Comments

(0)