Commit6a71bf6

committed

doc: warn pg_stat_reset() can cause vacuum/analyze problems

1 parent65c1106 commit6a71bf6Copy full SHA for 6a71bf6

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3339,6 +3339,17 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i`
`3339`	`3339`	`</tgroup>`
`3340`	`3340`	`</table>`
`3341`	`3341`
	`3342`	`+ <warning>`
	`3343`	`+ <para>`
	`3344`	`+ Using <function>pg_stat_reset()</function> also resets counters that`
	`3345`	`+ autovacuum uses to determine when to trigger a vacuum or an analyze.`
	`3346`	`+ Resetting these counters can cause autovacuum to not perform necessary`
	`3347`	`+ work, which can cause problems such as table bloat or out-dated`
	`3348`	`+ table statistics. A database-wide <command>ANALYZE</command> is`
	`3349`	`+ recommended after the statistics have been reset.`
	`3350`	`+ </para>`
	`3351`	`+ </warning>`
	`3352`	`+`
`3342`	`3353`	`<para>`
`3343`	`3354`	`<function>pg_stat_get_activity</function>, the underlying function of`
`3344`	`3355`	`the <structname>pg_stat_activity</structname> view, returns a set of records`

Comments

(0)