A beginners guide to EXPLAIN ANALYZE – Michael Christofides
Learn from Michael Christofides, the half of the team behind pgMustard, the differences between EXPLAIN and EXPLAIN ANALYZE, three common performance issues, useful tools, and resources to learn more. Resources 📌 Follow Michael on Twitter ⇒ / michristofides 📌 Learn more about pgMustard ⇒ https://www.pgmustard.com/ 📌 pgMustard documentation ⇒ pgmustard.com/docs/explain 📌 session slides ⇒ pgmustard.com/timescale-day-slides 🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲 At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry. 💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲! 🔍 Website ⇒ https://tsdb.co/homepage 🔍 Slack ⇒ https://slack.timescale.com 🔍 GitHub ⇒ https://github.com/timescale 🔍 Twitter ⇒ / timescaledb 🔍 Twitch ⇒ / timescaledb 🔍 LinkedIn ⇒ / timescaledb 🔍 Timescale Blog ⇒ https://tsdb.co/blog 🔍 Timescale Documentation ⇒ https://tsdb.co/docs

PostgresOpen 2019 Explain Plans And You

Timescale Community Day 2021

PostgreSQL performance tips you have never seen before | Citus Con: An Event for Postgres 2023

Postgres, MVCC, and you or, Why COUNT(*) is slow (David Wolever)

Claire Giordano: Beginner's Guide to Partitioning vs. Sharding in Postgres (PGConf.EU 2023)

Postgres Explain Explained - How Databases Prepare Optimal Query Plans to Execute SQL

Explain Explained - Josh Berkus

Karen Jex: Tuning PostgreSQL to work even better (PGConf.EU 2023)

Solving one of PostgreSQL's biggest weaknesses.

Postgres Open 2016 - Identifying Slow Queries and Fixing Them!

Explaining the Postgres Query Optimizer | Citus Con: An Event for Postgres 2022

The French Do Not Care About Work

Analyzing NFL play-by-play data using PostgreSQL and TimescaleDB – Miranda Auhl

Optimize Your SQL Queries | Postgres Edition

PGConf NYC 2022 Understanding PostgreSQL Query Plans (aka EXPLAIN) by Stephen Frost

Explain Analyze in PostgreSQL - My Own Little World

Webinar: Explaining the Postgres Query Optimizer

They Enabled Postgres Partitioning and their Backend fell apart

99% of Developers Don't Get PostgreSQL

