pgMustard
@pgmustard.com
A visualisation tool for Postgres explain analyze that also gives performance advice. Posts by @michristofides.com. Site: https://pgmustard.com/
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...