The wait event information in PostgreSQL is very helpful for troubleshooting. I always reference the PostgreSQL docs first, and when people ask me about wait events that where I send them first. The list of wait events there is comprehensive, but the descriptions are a bit terse and often use vocabulary that requires some familiarity with the internals to understand.
AWS created some wait event documentation for Aurora with PostgreSQL compatibility which takes a slightly different approach. It's a lot more words... but it tries to give useful suggestions about how to improve (or fix) the system when a particular wait event is encountered.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.html#AuroraPostgreSQL.Reference.Waitevents Something like this would be really valuable for open source PostgreSQL too. While somebody's personal blog is one solution, it doesn't seem wholly inappropriate to live on a community resource. I'd be happy to seed the content and continue making updates it as I regularly helping people solve problems on open source community PostgreSQL (and hopefully others contribute too).
Could we create a new wiki page as a starting point, and we could draft up and maintain something there for a little while? Maybe a place like
https://wiki.postgresql.org/wiki/Wait_Events ?
If it does turn out to be useful for a lot of people then maybe it could even get into the PG docs someday. :)
-Jeremy
P.S. my wiki username is "Jer"
https://wiki.postgresql.org/wiki/User:Jer--
Jeremy Schneider
Database Engineer
Amazon Web Services
