Description

Nikolay and Michael discuss wait events — what they are, why we have them, and how to use them to help diagnose performance issues.
 
Here are links to a few things we mentioned: 

• Wait events table (docs)
• 9.6 release notes
• PostgreSQL Scalability (blog post by Alexander Korotkov)
• Wait event analysis in pganalyze
• auto_explain
• Database Lab Engine
• track_io_timing
• pg_test_timing
• pgBadger
• Coroot
• Okmeter
• pgwatch2 Postgres.ai Edition
• pg_wait_sampling
• pgsentinel
• Datadog
• AWS RDS docs for PostgreSQL wait events
• pgMustard newsletter
• PASH Viewer
• pgCenter
• Intro to query optimisation episode
• Monitoring checklist episode

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork