A beginner's guide to EXPLAIN ANALYZE

TimescaleDB and PostgreSQL
, ,
1

At Timescale Community Day in October 2021, Michael Christofides, half of the team behind pgMustard explored the differences between EXPLAIN and EXPLAIN ANALYZE, looked at three common performance issues, some useful tools, and shared some resources for you to learn more.

Would you like to take part in future streaming events?

Get in touch! [email protected]

2 Likes
2

Thanks for sharing Lorraine! If anyone has any questions, let me know. For the avoidance of disappointment, we didn’t actually get to the three most common issues in this chat, but I did include them in my slides here: Timescale Community Day slides — pgMustard

1 Like
3

This got me to subscribe to pgmustard, and I can say it does save a bit of time in identifying the source of the problem with a query. Enough time to make it worth the subscription over a year.

2 Likes
4

Glad to know it’s been insightful @BenSkelton ! :pray:

5

Thank you @BenSkelton , so glad to hear it’s helping!