@@ -101,6 +101,19 @@ in-memory hash table.
101
101
102
102
pg_wait_sampling_reset_profile() function resets the profile.
103
103
104
+ The work of wait event statistics collector worker is controlled by following
105
+ GUCs.
106
+
107
+ | Parameter name| Data type| Description|
108
+ | -------------------------------| ---------| -------------------------------------------|
109
+ | pg_wait_sampling.history_size| int4| Size of history in-memory ring buffer|
110
+ | pg_wait_sampling.history_period| int4| Period for history sampling in milliseconds|
111
+ | pg_wait_sampling.profile_period| int4| Period for profile sampling in milliseconds|
112
+
113
+ These GUCs are allowed to be changed by superuser. Also, they are placed into
114
+ shared memory. Thus, they could be changed from any backend and affects worker
115
+ runtime.
116
+
104
117
See
105
118
[ PostgreSQL documentation] ( http://www.postgresql.org/docs/devel/static/monitoring-stats.html#WAIT-EVENT-TABLE )
106
119
for list of possible wait events.