Commit34e9e47

Alexander Korotkov

committed

Mention that pg_wait_sampling should be in shared_preload_libraries.

1 parentcf5449b commit34e9e47Copy full SHA for 34e9e47

File tree

-1

lines changed

-1

lines changed

Lines changed: 8 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,14 @@ PostgreSQL 9.6+ provides an information about current wait event of particular`
`8`	`8`	`process. However, in order to gather descriptive statistics of server`
`9`	`9`	`behavior user have to sample current wait event multiple times.`
`10`	`10`	`pg\_wait\_sampling is an extension for collecting sampling statistics of wait`
`11`		`-events. It collects two kinds of statistics.`
	`11`	`+events.`
	`12`	`+`
	`13`	`+The module must be loaded by adding pg\_wait\_sampling to`
	`14`	`+shared\_preload\_libraries in postgresql.conf, because it requires additional`
	`15`	`+shared memory and launches background worker. This means that a server restart`
	`16`	`+is needed to add or remove the module.`
	`17`	`+`
	`18`	`+When pg\_wait\_sampling is enabled, it collects two kinds of statistics.`
`12`	`19`
`13`	`20`	`* History of waits events. It's implemented as in-memory ring buffer where`
`14`	`21`	`samples of each process wait events are written with given (configurable)`

Comments

(0)