pgMustard
@pgmustard.com
A visualisation tool for Postgres explain analyze that also gives performance advice. Posts by @michristofides.com. Site: https://pgmustard.com/
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...
www.g2.com/products/pgm...
www.g2.com
December 17, 2025 at 1:37 PM
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...
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.
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.
December 12, 2025 at 4:25 PM
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.
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 🙌
November 26, 2025 at 12:44 PM
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
* 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
November 24, 2025 at 5:37 PM
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
* 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
I think @pgmustard.com is great for actionable recommendations for EXPLAIN results. Still helps me a ton to figure things out to this day.
November 20, 2025 at 4:16 PM
I think @pgmustard.com is great for actionable recommendations for EXPLAIN results. Still helps me a ton to figure things out to this day.
Reposted by pgMustard
What are your favorite PostgreSQL-specific resources to use as part of providing some technical mentorship to a junior developer?
November 20, 2025 at 3:59 PM
What are your favorite PostgreSQL-specific resources to use as part of providing some technical mentorship to a junior developer?
Which major version of PostgreSQL are you (primarily) running in production?
November 17, 2025 at 5:08 PM
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 🎉
This change was particularly satisfying 🎉
November 11, 2025 at 9:35 AM
We're in the process of updating our EXPLAIN glossary for Postgres 18.
This change was particularly satisfying 🎉
This change was particularly satisfying 🎉
Reposted by pgMustard
Great write-up by Michael Christofides from @pgmustard.com
www.pgmustard.com/blog/what-do...
> It turns out that for the general case, boundary conditions and NULLs (of course!) always need to be considered, so you can get one or two extra Index Searches when these can’t be ruled out
#postgresql
www.pgmustard.com/blog/what-do...
> It turns out that for the general case, boundary conditions and NULLs (of course!) always need to be considered, so you can get one or two extra Index Searches when these can’t be ruled out
#postgresql
What do the new Index Searches lines in EXPLAIN mean? - pgMustard
In Postgres 18 you’ll now see “Index Searches” lines in EXPLAIN ANALYZE output. If like me you were wondering what those mean exactly, you’re in the right place.
www.pgmustard.com
November 10, 2025 at 2:21 PM
Great write-up by Michael Christofides from @pgmustard.com
www.pgmustard.com/blog/what-do...
> It turns out that for the general case, boundary conditions and NULLs (of course!) always need to be considered, so you can get one or two extra Index Searches when these can’t be ruled out
#postgresql
www.pgmustard.com/blog/what-do...
> It turns out that for the general case, boundary conditions and NULLs (of course!) always need to be considered, so you can get one or two extra Index Searches when these can’t be ruled out
#postgresql
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...
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...
What do the new Index Searches lines in EXPLAIN mean? - pgMustard
In Postgres 18 you’ll now see “Index Searches” lines in EXPLAIN ANALYZE output. If like me you were wondering what those mean exactly, you’re in the right place.
www.pgmustard.com
November 10, 2025 at 1:23 PM
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...
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
www.youtube.com/@pgMustard
October 28, 2025 at 12:54 PM
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
www.youtube.com/@pgMustard
Reposted by pgMustard
Check out the interview with Supporter sponsor @pgmustard.com posted at 2025.pgday.uk/sponsor-inte...
Interview with pgMustard – PGDay UK 2025
Interview with pgMustard – PGDay UK 2025
2025.pgday.uk
September 5, 2025 at 11:41 AM
Check out the interview with Supporter sponsor @pgmustard.com posted at 2025.pgday.uk/sponsor-inte...
The upcoming Postgres 18 is set to include some nice improvements to EXPLAIN:
* BUFFERS on by default with ANALYZE 🎉
* Fractional "actual rows" (huge in some cases)
* Quite a few new fields (including the very cool Index Searches)
We've now added support for all of them. 💛
* BUFFERS on by default with ANALYZE 🎉
* Fractional "actual rows" (huge in some cases)
* Quite a few new fields (including the very cool Index Searches)
We've now added support for all of them. 💛
August 20, 2025 at 2:40 PM
The upcoming Postgres 18 is set to include some nice improvements to EXPLAIN:
* BUFFERS on by default with ANALYZE 🎉
* Fractional "actual rows" (huge in some cases)
* Quite a few new fields (including the very cool Index Searches)
We've now added support for all of them. 💛
* BUFFERS on by default with ANALYZE 🎉
* Fractional "actual rows" (huge in some cases)
* Quite a few new fields (including the very cool Index Searches)
We've now added support for all of them. 💛
There are a couple of online #PostgreSQL events today that look like they'll be great:
16:00 UTC — 10 Costly Database Performance Mistakes (and How to Fix Them) with Andy Atkinson www.meetup.com/postgres-mee...
19:00 UTC — 12 years of Postgres Weekly with Peter Cooper aka.ms/TalkingPostg...
16:00 UTC — 10 Costly Database Performance Mistakes (and How to Fix Them) with Andy Atkinson www.meetup.com/postgres-mee...
19:00 UTC — 12 years of Postgres Weekly with Peter Cooper aka.ms/TalkingPostg...
June 18, 2025 at 2:16 PM
There are a couple of online #PostgreSQL events today that look like they'll be great:
16:00 UTC — 10 Costly Database Performance Mistakes (and How to Fix Them) with Andy Atkinson www.meetup.com/postgres-mee...
19:00 UTC — 12 years of Postgres Weekly with Peter Cooper aka.ms/TalkingPostg...
16:00 UTC — 10 Costly Database Performance Mistakes (and How to Fix Them) with Andy Atkinson www.meetup.com/postgres-mee...
19:00 UTC — 12 years of Postgres Weekly with Peter Cooper aka.ms/TalkingPostg...