Antony T.
CTO
The breakdown and prioritization by estimated time-saving potential is great. We run a multi-service application with several PostgreSQL databases, and as our data has grown, query performance has become more important. As a non-expert in DB optimization, pgMustard has done a great job boiling down the large amount of info Postgres gives you into genuinely useful visualizations.
Antony T.
CTO
The breakdown and prioritization by estimated time-saving potential is great. We run a multi-service application with several PostgreSQL databases, and as our data has grown, query performance has become more important. As a non-expert in DB optimization, pgMustard has done a great job boiling down the large amount of info Postgres gives you into genuinely useful visualizations.
Dec 4, 2025
Dec 4, 2025
Amree Zaid 🍉
@AmreeZaid
@michristofides Btw, I am a fan of @pgMustard. Awesome software, helped me couple of times before.
Amree Zaid 🍉
@AmreeZaid
@michristofides Btw, I am a fan of @pgMustard. Awesome software, helped me couple of times before.
Nov 12, 2025
Nov 12, 2025
Ben Skelton
Developer, In Store Reviews
Have you tried pgMustard? It's great for quick query optimisation
Ben Skelton
Developer, In Store Reviews
Have you tried pgMustard? It's great for quick query optimisation
Oct 28, 2025
Oct 28, 2025
Abhinav Tiwari
SQL Server & PostgreSQL DBA at Toll Group
Thank you for making such good tool. I have solved numerous problem using it. The good part is, the STAR it shows for a problem. 9.9 times out of 10 its does the best bet.
Abhinav Tiwari
SQL Server & PostgreSQL DBA at Toll Group
Thank you for making such good tool. I have solved numerous problem using it. The good part is, the STAR it shows for a problem. 9.9 times out of 10 its does the best bet.
Jun 20, 2025
Jun 20, 2025
Lukas Ender 💡👷♂️🌱
@lukasender
Learnings:
✅ Postgres has all you need
✅ FKs are not fast(er) out-of-the-box
✅ measure before *and* after adding an index!
You can't just slap an index on every column.
It may not help at all, or worse, make things slower!
✅ @pgMustard is great 😊
Lukas Ender 💡👷♂️🌱
@lukasender
Learnings:
✅ Postgres has all you need
✅ FKs are not fast(er) out-of-the-box
✅ measure before *and* after adding an index!
You can't just slap an index on every column.
It may not help at all, or worse, make things slower!
✅ @pgMustard is great 😊
Jun 19, 2024
Jun 19, 2024
Adrian
@adriangb01
I have nothing but good things to say about pgMustard. They implemented a nontrivial feature in days and it is exactly what I asked for. I was able to delete and simplify my code without reworking it. Amazing work.
cc @samuel_colvin twitter.com/pgMustard/status/1763103511951065374
Adrian
@adriangb01
I have nothing but good things to say about pgMustard. They implemented a nontrivial feature in days and it is exactly what I asked for. I was able to delete and simplify my code without reworking it. Amazing work.
cc @samuel_colvin twitter.com/pgMustard/status/1763103511951065374
Mar 12, 2024
Mar 12, 2024
sjivan
@sjivan
@tobias_petry @IndexingBook @pgMustard Yes, I've used all of them and pgMustard is great. I still like to know all the details of the workings of the plan 😃
sjivan
@sjivan
@tobias_petry @IndexingBook @pgMustard Yes, I've used all of them and pgMustard is great. I still like to know all the details of the workings of the plan 😃
Mar 8, 2024
Mar 8, 2024
ramy.co
@ramykhuffash
I was struggling with some slow DB queries and ChatGPT wasn't much help
I'm now using @pgMustard with Django Debug Toolbar and have a much better idea at what steps to take to speed things up
Great work @michristofides 👏
ramy.co
@ramykhuffash
I was struggling with some slow DB queries and ChatGPT wasn't much help
I'm now using @pgMustard with Django Debug Toolbar and have a much better idea at what steps to take to speed things up
Great work @michristofides 👏
Jan 22, 2024
Jan 22, 2024
Frank Kumro @frigidcode
PG Mustard is a great tool, well worth the very cheap cost for a year. #PostgreSQL
Frank Kumro @frigidcode
PG Mustard is a great tool, well worth the very cheap cost for a year. #PostgreSQL
Jan 14, 2024
Jan 14, 2024
Adam Johnson
@AdamChainz
✍️ New post covering a situation where I disabled the #PostgreSQL JIT to speed up some queries in a #Django project.
@pgMustard was very useful for discovering the problem and giving advice!
adamj.eu/tech/2023/11/09/django-disable-postgresql-jit
Adam Johnson
@AdamChainz
✍️ New post covering a situation where I disabled the #PostgreSQL JIT to speed up some queries in a #Django project.
@pgMustard was very useful for discovering the problem and giving advice!
adamj.eu/tech/2023/11/09/django-disable-postgresql-jit
Nov 9, 2023
Nov 9, 2023
Andrew Atkinson
@andatki
Part 1 #PostgreSQL query optimization. Started at 20s. Analyzed query plan + all tables/fields/conditions. Created around 10 hypothetical indexes, single and multi. Iterated w/ @pgMustard plans. Most plan nodes now index scans or index only scans. No query changes. Down to 3s.
Andrew Atkinson
@andatki
Part 1 #PostgreSQL query optimization. Started at 20s. Analyzed query plan + all tables/fields/conditions. Created around 10 hypothetical indexes, single and multi. Iterated w/ @pgMustard plans. Most plan nodes now index scans or index only scans. No query changes. Down to 3s.
Oct 27, 2023
Oct 27, 2023
pgcd
I tried it and found it VERY helpful, thanks - I'm sure I'm still missing some opportunities but what I understood from it was enough to bring the problem query down to a manageable time (2s vs 12s). Even more importantly; I can now explain to my colleagues *what* is wrong, instead of "heeehh this is too slow" =)
pgcd
I tried it and found it VERY helpful, thanks - I'm sure I'm still missing some opportunities but what I understood from it was enough to bring the problem query down to a manageable time (2s vs 12s). Even more importantly; I can now explain to my colleagues *what* is wrong, instead of "heeehh this is too slow" =)
Jun 24, 2023
Jun 24, 2023
Manda Putra
@_mandaputtra
Analyzing SQL performance can be hard. But, I found this website that could help read the analysis result better. Try it!
- explain.depesz.com
- app.pgmustard.com (paid service)
Manda Putra
@_mandaputtra
Analyzing SQL performance can be hard. But, I found this website that could help read the analysis result better. Try it!
- explain.depesz.com
- app.pgmustard.com (paid service)
Feb 16, 2023
Feb 16, 2023
krishan711.eth
@krishan711
@_baretto @michristofides @pgMustard @pgMustard is a must have for me these days! I remember when @michristofides first took me through it i thought i might use it once a quarter but I've found myself using it far more frequently. Could not recommend it more!
krishan711.eth
@krishan711
@_baretto @michristofides @pgMustard @pgMustard is a must have for me these days! I remember when @michristofides first took me through it i thought i might use it once a quarter but I've found myself using it far more frequently. Could not recommend it more!
Nov 9, 2022
Nov 9, 2022
Magnus Falch
If you are writing SQL queries for PostgreSQL you need to check out pgMustard.
It's saved me several hours of debugging and optimization time.
#sql #postgresql #performance
Magnus Falch
If you are writing SQL queries for PostgreSQL you need to check out pgMustard.
It's saved me several hours of debugging and optimization time.
#sql #postgresql #performance
Sep 3, 2022
Sep 3, 2022
Elizabeth Garrett Christensen
@e_g_christensen
@pgMustard Your newsletter is so good! Always read the whole thing and that's pretty special considering the number of newsletters I subscribe to.
Elizabeth Garrett Christensen
@e_g_christensen
@pgMustard Your newsletter is so good! Always read the whole thing and that's pretty special considering the number of newsletters I subscribe to.
Aug 3, 2022
Aug 3, 2022
Dorian
@dorianmariefr
So much love for @pgMustard, found a missing index and went from ~700ms to ~15ms ❤️
Dorian
@dorianmariefr
So much love for @pgMustard, found a missing index and went from ~700ms to ~15ms ❤️
Jul 11, 2022
Jul 11, 2022
RustProof Labs 🐘
@RustProofLabs
@driscollis Software I install: Sublime Text
Software someone else runs: @pgMustard
RustProof Labs 🐘
@RustProofLabs
@driscollis Software I install: Sublime Text
Software someone else runs: @pgMustard
May 7, 2022
May 7, 2022
Tobias_Petry.sql
@tobias_petry
I really like the newsletter @michristofides is sending each month. He is curating so many good articles for each issue!
I only read two (!) PostgreSQL newsletters, the other one is Postgres Weekly. That speaks for itself! pgmustard.com/newsletter
Tobias_Petry.sql
@tobias_petry
I really like the newsletter @michristofides is sending each month. He is curating so many good articles for each issue!
I only read two (!) PostgreSQL newsletters, the other one is Postgres Weekly. That speaks for itself! pgmustard.com/newsletter
May 6, 2022
May 6, 2022
Sparky
@sparkyuk11
@tobias_petry @michristofides The pgMustard tool is also amazing. Wish it worked for MySQL too.
Sparky
@sparkyuk11
@tobias_petry @michristofides The pgMustard tool is also amazing. Wish it worked for MySQL too.
May 6, 2022
May 6, 2022
Everett 🇺🇦
@retttx
@paulbiggar @michristofides @thinkx any leads?
Also try pgmustard to get a start on which parts of your queries are slow
Everett 🇺🇦
@retttx
@paulbiggar @michristofides @thinkx any leads?
Also try pgmustard to get a start on which parts of your queries are slow
Mar 16, 2022
Mar 16, 2022
jj@::1$ ☁️🛠🧯
@thejtoken
If you are a PostgreSQL person this is a handy tool to understand EXPLAIN pgMustard pgmustard.com
jj@::1$ ☁️🛠🧯
@thejtoken
If you are a PostgreSQL person this is a handy tool to understand EXPLAIN pgMustard pgmustard.com
Mar 5, 2022
Mar 5, 2022
James Jefferies
@jamesjefferies
@andycroll glad you got it sorted - I’ve found @pgMustard an absolute winner for issues with queries - deffo worth a look if you haven’t already..
James Jefferies
@jamesjefferies
@andycroll glad you got it sorted - I’ve found @pgMustard an absolute winner for issues with queries - deffo worth a look if you haven’t already..
Jan 27, 2022
Jan 27, 2022
Michael W. Arnold
@marmanold
Y’all, if you’re working with Postgres pgMustard is a must. It’s taught me so much about how Postgres works while helping me tune some pretty important queries. Worth every Euro cent! pgmustard.com
Michael W. Arnold
@marmanold
Y’all, if you’re working with Postgres pgMustard is a must. It’s taught me so much about how Postgres works while helping me tune some pretty important queries. Worth every Euro cent! pgmustard.com
Dec 17, 2021
Dec 17, 2021
Robert
@MrThePlague
@tobias_petry @mattkingshott I’ve played around with pgmustard.com a little bit too, and it’s pretty impressive (at least for someone who almost zero DB background 😆).
Robert
@MrThePlague
@tobias_petry @mattkingshott I’ve played around with pgmustard.com a little bit too, and it’s pretty impressive (at least for someone who almost zero DB background 😆).
Dec 16, 2021
Dec 16, 2021
Xoel López
@xoelipedes
The plain language tips that pgmustard.com gives you are next level, one of the best query plan visualization tools for Postgres I've seen twitter.com/pgMustard/status/1419696175347814401
Xoel López
@xoelipedes
The plain language tips that pgmustard.com gives you are next level, one of the best query plan visualization tools for Postgres I've seen twitter.com/pgMustard/status/1419696175347814401
Nov 17, 2021
Nov 17, 2021
Haki
@be_haki
@xoelipedes @pgMustard are doing great work! If you review a lot of #PostgreSQL execution plans, be sure to check their EXPLAIN glossary
pgmustard.com/docs/explain
Haki
@be_haki
@xoelipedes @pgMustard are doing great work! If you review a lot of #PostgreSQL execution plans, be sure to check their EXPLAIN glossary
pgmustard.com/docs/explain
Nov 17, 2021
Nov 17, 2021
Wilhelm Klopp
Founder, Simple Poll
Just successfully used pgMustard to turn a 200s query into a 400ms one – now our data backfill is on track to complete in a few hours instead of days – thank you! 😍 😍 😍 😍 🙏
Wilhelm Klopp
Founder, Simple Poll
Just successfully used pgMustard to turn a 200s query into a 400ms one – now our data backfill is on track to complete in a few hours instead of days – thank you! 😍 😍 😍 😍 🙏
Nov 13, 2021
Nov 13, 2021
Rémy
@Xowap
@jlongster I've got no shares there but @pgMustard is your best friend. It literally helped me slash some queries runtime by a 10x or 100x factor. Surprisingly so, without creating any index. I was amazed to discover the wiggle room from settings and other subtleties.
Rémy
@Xowap
@jlongster I've got no shares there but @pgMustard is your best friend. It literally helped me slash some queries runtime by a 10x or 100x factor. Surprisingly so, without creating any index. I was amazed to discover the wiggle room from settings and other subtleties.
Nov 6, 2021
Nov 6, 2021
Jamie Lawrence
@ideasasylum
@jmcharnes You just missed a great session with me and Basil. pgMustard said my version of the query was "a very quick query" and I've never enjoyed such validation from a machine before
Jamie Lawrence
@ideasasylum
@jmcharnes You just missed a great session with me and Basil. pgMustard said my version of the query was "a very quick query" and I've never enjoyed such validation from a machine before
Aug 24, 2021
Aug 24, 2021
Hynek Schlawack
@hynek
I have spent 2+h yesterday agonizing over postgres plans. I have shaved 200ms from a 250ms off by using pgMustard once. 😲
(I’m still getting wildly different plans in prod/on notebook on the exactly same data but meh.) twitter.com/searls/status/1402991961741545479
Hynek Schlawack
@hynek
I have spent 2+h yesterday agonizing over postgres plans. I have shaved 200ms from a 250ms off by using pgMustard once. 😲
(I’m still getting wildly different plans in prod/on notebook on the exactly same data but meh.) twitter.com/searls/status/1402991961741545479
Jul 14, 2021
Jul 14, 2021
Dan Diephouse
@dandiep
@searls @pgMustardApp @KameSameApp @heroku Thanks for this. It really made a big difference in a query I was having problems with.
Dan Diephouse
@dandiep
@searls @pgMustardApp @KameSameApp @heroku Thanks for this. It really made a big difference in a query I was having problems with.
Jun 22, 2021
Jun 22, 2021
Pat Maddox
@patmaddox
@searls @pgMustardApp the stars aligned today... I am diagnosing a slow query timeout problem. Mustard helped me find the problem and come up with a fix in a few minutes.
I've done a lot of Postgres perf and tuning work over the years. Never seen anything like this. Thanks for sharing.
Pat Maddox
@patmaddox
@searls @pgMustardApp the stars aligned today... I am diagnosing a slow query timeout problem. Mustard helped me find the problem and come up with a fix in a few minutes.
I've done a lot of Postgres perf and tuning work over the years. Never seen anything like this. Thanks for sharing.
Jun 10, 2021
Jun 10, 2021
Justin Searls
@searls
I refuse to invest the time to understand how SQL explain plans work, so I love how @pgMustardApp demystifies why my queries are slow for me.
This query was scanning every row for "where id = 123" because on a materialized view, that ID field isn't a real PK. It needed an index!
Justin Searls
@searls
I refuse to invest the time to understand how SQL explain plans work, so I love how @pgMustardApp demystifies why my queries are slow for me.
This query was scanning every row for "where id = 123" because on a materialized view, that ID field isn't a real PK. It needed an index!
Jun 10, 2021
Jun 10, 2021
Michael Koper
@michaelkoper
@heyjoshwood Pg mustard @pgMustardApp. Because it just simply told me how to improve a specific query I had trouble with.
Michael Koper
@michaelkoper
@heyjoshwood Pg mustard @pgMustardApp. Because it just simply told me how to improve a specific query I had trouble with.
May 30, 2021
May 30, 2021
Ashish “Logmaster”
@ashishlogmaster
Using Postgres? I just learn about PgMustard. pgmustard.com/#. Looks interesting enough that I think all enterprises should buy it?
Ashish “Logmaster”
@ashishlogmaster
Using Postgres? I just learn about PgMustard. pgmustard.com/#. Looks interesting enough that I think all enterprises should buy it?
May 28, 2021
May 28, 2021
Benedikt Deicke
@benediktdeicke
Can’t say this often enough, @pgMustardApp is amazing.
😩 Take a slow query
🧐 Slap `EXPLAIN (ANALYZE, FORMAT JSON, BUFFERS, VERBOSE, SETTINGS)` in front of it and run it
💪 Paste the output into the app
🤩 Get a list of todos with detailed explanations
Benedikt Deicke
@benediktdeicke
Can’t say this often enough, @pgMustardApp is amazing.
😩 Take a slow query
🧐 Slap `EXPLAIN (ANALYZE, FORMAT JSON, BUFFERS, VERBOSE, SETTINGS)` in front of it and run it
💪 Paste the output into the app
🤩 Get a list of todos with detailed explanations
Mar 26, 2021
Mar 26, 2021
Mohsin Patel
Principal Database Engineer, Auto Trader UK
pgMustard is a great product that simplifies a complicated subject area for developers and database engineers alike. It’s become a go-to product for solving query performance issues and visualising explain plans – kudos!
Mohsin Patel
Principal Database Engineer, Auto Trader UK
pgMustard is a great product that simplifies a complicated subject area for developers and database engineers alike. It’s become a go-to product for solving query performance issues and visualising explain plans – kudos!
Mar 7, 2021
Mar 7, 2021
Michael Mauger
Data Architect, Diameter Health
First, I love your tool—it has already helped us deploy PostgreSQL successfully, and I look forward to continuing to use it as part of our relational database development process.
Michael Mauger
Data Architect, Diameter Health
First, I love your tool—it has already helped us deploy PostgreSQL successfully, and I look forward to continuing to use it as part of our relational database development process.
Nov 9, 2020
Nov 9, 2020
Piotr Adamiak
Principal PostgreSQL Consultant, Oliphant Consulting
I have to say I find your "mustard" hot stuff and really user friendly.
Piotr Adamiak
Principal PostgreSQL Consultant, Oliphant Consulting
I have to say I find your "mustard" hot stuff and really user friendly.
Oct 21, 2020
Oct 21, 2020
Hugh Neale
Director, Zercurity
pgMustard has played a huge role in helping us stay on top of our API response goals, greatly reducing database load, saving us money, and improving our overall customer experience. We're extremely happy with how quickly it helps us identify issues.
Hugh Neale
Director, Zercurity
pgMustard has played a huge role in helping us stay on top of our API response goals, greatly reducing database load, saving us money, and improving our overall customer experience. We're extremely happy with how quickly it helps us identify issues.
Jul 7, 2020
Jul 7, 2020