pgMustard
A visualisation tool for Postgres explain analyze that also gives performance advice. Posts by @michristofides.com. Site: pgmustard.com
- Our Read Efficiency tips are now more efficient to read! 📝 Better wording, mostly for clarity 🔬 More specific to the scan type, and therefore shorter in most cases 🌟 Improved scoring, especially for Bitmap Heap Scans More details: www.pgmustard.com/changelog
- Reposted by pgMustardIf you have any Postgres performance issues, I'd love to hear about them and try to help: pgmustard.com/office-hours
- If pgMustard has made your life easier this year, we'd love a review on G2! It does take a few minutes, but we like that it is verified, and are already using the feedback to shape what we work on next. www.g2.com/products/pgm...
- Bad row count estimates are a common cause of slow queries. We've had a tip for them in pgMustard from the start, but we've just finished a revamp of it, mostly to make the advice in several common cases clearer. We also now report the ratios a little more naturally.
- It was a very small sample size, but we were impressed with the number of people running newer Postgres versions in our recent poll 🙌
- We've revamped our "Operation on Disk" tips ✨ * Made them clearer * Made them more succinct (in most cases) * Improved the scoring * Mention hash_mem_multiplier (when relevant) * Show "Operation in Memory" in more cases, with the memory used * Updated the linked blog post
- Reposted by pgMustard[Not loaded yet]
- Reposted by pgMustard[Not loaded yet]
- Which major version of PostgreSQL are you (primarily) running in production?
- We're in the process of updating our EXPLAIN glossary for Postgres 18. This change was particularly satisfying 🎉
- Reposted by pgMustard[Not loaded yet]
- New blog post: "What do the new Index Searches lines in EXPLAIN mean?" In Postgres 18 you'll start seeing things like "Index Searches: 1" on each of your index scans. We looked into what they mean, and how that information can be helpful. www.pgmustard.com/blog/what-do...
- The next chapter in our 7-year battle with EXPLAIN formatting: new demo videos showing how to get nicely formatted query plans in your tool of choice. www.youtube.com/@pgMustard
- Reposted by pgMustard[Not loaded yet]
