Monitor performance issues & errors in your code

Optimizing PostgreSQL DB Queries with pgMustard

Episode #366, published Fri, May 20, 2022, recorded Wed, May 11, 2022

Does your app have a database? Does that database play an important role in how the app operations and users perceive its quality? Most of you probably said yes to the first, and definitely to the second. But what if your DB isn't doing as well as it should? How would you know? And once you know, what do you do about it?

On this episode, we're joined by Michael Christofides, co-creator of pgMustard, to discuss and explore the EXPLAIN command for Postgres and other databases as well as all the recommendations you might dig into as a result of understanding exactly what's happening with you queries.

Watch this episode on YouTube
Play on YouTube
Watch the live stream version


Links from the show

Michael Christofides: @michristofides
Datagrip: jetbrains.com
pgMustard: pgmustard.com
pgMustard example 1: app.pgmustard.com
pgMustard example 2: app.pgmustard.com
pgMustard example 3: app.pgmustard.com
Arctype: arctype.com
Postico: eggerapps.at/postico
Laetitia Avrot Secrets of 'psql'— Video: youtube.com
Beekeeper Studio: beekeeperstudio.io
DBeaver: dbeaver.io
SQLite Browser: sqlitebrowser.org

Michael's new Up and Running with Git course: talkpython.fm/git
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to us on YouTube: youtube.com
Follow Talk Python on Mastodon: talkpython
Follow Michael on Mastodon: mkennedy

Want to go deeper? Check out our courses

Michael Christofides
Michael Christofides
Michael Christofides is a product manager turned founder with a particular interest in database tools. Over 5 years at Redgate, he managed tools for SQL Server, Oracle, and MySQL, but now focuses 100% on Postgres. Today he runs pgMustard, a tool that helps developers learn about database performance while speeding up queries.
Episode sponsored by
Ads served ethically
Talk Python's Mastodon Michael Kennedy's Mastodon