Wait events | Postgres.FM 036 | #PostgreSQL #Postgres podcast

Michael and Nikolay 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) https://www.postgresql.org/docs/curre... 9.6 release notes https://www.postgresql.org/docs/relea... PostgreSQL Scalability (blog post by Alexander Korotkov) https://akorotkov.github.io/blog/2016... Postgres Wait Event Analysis in pganalyze https://pganalyze.com/blog/postgres-c... auto_explain https://www.postgresql.org/docs/curre... Database Lab Engine https://github.com/postgres-ai/databa... track_io_timing https://pgpedia.info/t/track_io_timin... pg_test_timing https://postgresql.org/docs/current/p... pgBadger https://github.com/darold/pgbadger Coroot https://coroot.com/ Okmeter https://okmeter.io/ pgwatch2 (Postgres.ai Edition) https://gitlab.com/postgres-ai/pgwatch2 pg_wait_sampling https://github.com/postgrespro/pg_wai... pgsentinel https://github.com/pgsentinel/pgsentinel Datadog https://www.datadoghq.com/ AWS RDS docs for PostgreSQL wait events https://docs.aws.amazon.com/AmazonRDS... pgMustard newsletter https://www.pgmustard.com/newsletter PASH Viewer https://github.com/dbacvetkov/PASH-Vi... pgCenter https://github.com/lesovsky/pgcenter Intro to query optimisation episode https://postgres.fm/episodes/intro-to... Monitoring checklist episode https://postgres.fm/episodes/monitori... ------------- What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides   ~~~ Postgres FM is brought to you by: Nikolay Samokhvalov, founder of Postgres.ai Michael Christofides, founder of pgMustard ~~~ This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.