On Thu, Dec 20, 2018 at 8:48 PM Yotsunaga, Naoki <yotsunaga.na...@jp.fujitsu.com> wrote: > If so, is not that the number of wait events is useful information?
My theory is that the number of wait events is NOT useful information, or at least not nearly as useful the results of a sampling approach. The data that LWLOCK_STATS produce are downright misleading -- they lead you to think that the bottlenecks are in different places than they really are, because the locks that produce the most waiting can be 5th or 10th in terms of the number of wait events. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
