Top all-time · #7460
pgMustard
Company blog · pgmustard.com/blogdataprogramming
pgMustard is the company blog at pgmustard.com, writing about data and programming. Since 2019, 10 different Hacker News readers have linked it 22 times, most often “Show HN: A user interface for Postgres EXPLAIN that also gives tips”. It is still writing: the last post was on 2026-02-13, and you can follow it by feed.
Too few sampled comments (9) to say how often HN recommends it.?
Why HN links it
A site offering a tool for analysing Postgres EXPLAIN query plans, plus Postgres performance articles and a newsletter. Commenters mostly describe using the tool to debug slow queries.
Summarised by Claude from a sample of 9 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
Most-linked posts?
- Show HN: A user interface for Postgres EXPLAIN that also gives tips3 people · 3 mentions · first linked 2019-07-03
- Postgres Explain – Explained2 people · 2 mentions · first linked 2020-07-06
What Hacker News says?
I have a table with over a billion rows and most full-text searches still respond in around a few milliseconds. I think this will depend on a lot of factors, such as proper indexing, and filtering down the dataset as much as possible before performing the full-text ops. I've spent a considerable amount of time on optimizing these queries, thanks to tools like PgMustard [0]. Granted, I do still have a couple slow que…
Comment linking /
on “Postgres Full-Text Search: A search engine in a database”Submitted Show HN: A user interface for Postgres EXPLAIN that also gives tips as a story · 50 points
HN discussionMeanwhile there are a number of products emerging in the Postgres space that are focused on SaaS business models. - https://pganalyze.com/ - https://www.crunchybridge.com - https://www.pgmustard.com/ - https://supabase.io/ The Postgres consulting/support services landscape may be consolidating some, but I'm not even sure that is a broader trend. Meanwhile there are more tools and services popping up regularly.
Comment linking /
on “PostgreSQL community impact of 2nd Quadrant purchase”Submitted Postgres Explain – Explained as a story · 5 points
HN discussionThere's also https://www.pgmustard.com , which gives you a bit more hints and information on the possible optimizations.
Comment linking /
on “What's new in the Postgres 16 query planner”Submitted Why isn’t Postgres using my index? as a story · 4 points
HN discussionGreat extension, yes. There is overhead when enabling the timing and buffers options, but sometimes it's not big [1] But auto_explain solves only part of the task – you can see what happened, but cannot see the answers to "what if" questions. ("What if I used this index?") [1] https://www.pgmustard.com/blog/auto-explain-overhead-with-ti...
Comment linking /blog/auto-explain-overhead-with-timing
on “PostgreSQL EXPLAIN Output Explained”Submitted What do index searches mean in Postgres 18's explain analyze? as a story · 3 points
HN discussionI use an awesome service called PgMustard [0] for parsing and debugging slow queries. It has saved me a lot of time, and has helped me resolve some pretty big (and complicated) bottlenecks. [0]: https://pgmustard.com
Comment linking /
on “PostgreSQL EXPLAIN Output Explained”Submitted Just because you're getting an index scan, doesn't mean you can't do better as a story · 3 points
HN discussionhttps://www.pgmustard.com/ is a great tool. There are some free alternatives for the actual tool, but their documentation is pretty great. For example, https://www.pgmustard.com/docs/explain/heap-fetches provides clarity that isn't obvious from the official pg docs. Beyond those resources, here are a few useful things I've learned: 1. `explain (analyze, buffers)` is useful. It will tell you about hot vs cold data. O…
Comment linking /docs/explain/heap-fetches
on “Pg_hint_plan: Force PostgreSQL to execute query plans the way you want”Submitted Using BUFFERS for Postgres query optimization as a story · 3 points
HN discussionYou can't go wrong with https://pgmustard.com . It's helped me so many times. All you need is the output of EXPLAIN (ANALYZE, VERBOSE, BUFFERS, FORMAT JSON).
Comment linking /
on “Bloom Filter Indexes in PostgreSQL”Submitted Read efficiency issues in Postgres queries as a story · 2 points
HN discussionCheck out https://www.pgmustard.com/ if you haven't already. It has helped me optimize queries as much as possible when querying large datasets.
Comment linking /
on “Ask HN: 120M rows Postgres – how can I speed up queries?”Submitted In depth documentation for terms in Postgres EXPLAIN as a story · 2 points
HN discussion- https://www.pgmustard.com/newsletter (For Postgres news)
Comment linking /newsletter
on “Ask HN: What tech newsletters are you currently subscribing?”Submitted Postgres query plan visualization tools as a story · 1 points
HN discussionSubmitted Stop Trigger Time as a story · 1 points
HN discussionSubmitted Detailed Description of Postgres Plans as a story · 1 points
HN discussionSubmitted PostgreSQL Explain Glossary as a story · 1 points
HN discussion
