A user interface for Postgres EXPLAIN that also gives tips
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
A user interface for Postgres EXPLAIN that also gives tips launched on July 3, 2019 with 50 votes, #691 of 3,007 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 7 years on.
In plain words
PG Mustard is a user interface designed to help developers analyze PostgreSQL query performance through the EXPLAIN command. It visualizes query execution plans and provides optimization tips to improve database efficiency. The tool is intended for developers and database administrators working with PostgreSQL who want a more accessible way to understand and debug slow queries.
written from the facts on this page · September 2026
From the sources
Even if you know how, Postgres includes so much useful information, it is easy to miss something important. And for queries that do a lot, the plans are even more useful-yet-time-consuming. pgMustard speeds up your journey from knowing which query is a problem to working out what can be done about it . You’ll be able to see at a glance where the time is going, as well as jump straight to the important statistics. If you need a refresher on what something means, or want to read up on how it works, those are there for you too. We have also put effort into minimizing red-herrings, helping you avoid distractions like a sequential scan on a small table, or a bad row estimate on a fast subplan.…from pgmustard.com
Does a similar job
all alternatives →
pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲376PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
PgCat, Postgres pooler with sharding, load balancing and failover2022 · github.com · ▲233PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
Postgres query lock explainer2023 · github.com · ▲143This is like 4 years old, but I’m braver now and ready to share stuff with this community. I’ve been a lurker for a while. I made this tool - it’s kind of like “explain” but it tells you about what locks would be required by the query. I was making it as part of a larger tool that would try to prevent deadlocks during migrations at my last company, I never finished it.
PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
More life & fun this month
the category →
A free city-building game in your browser. You are the mayor. You know what the city needs. Now get it past the zoning board, the neighbors, the appeals court and the next election.
Life & fun · 23h ago · permit.petercai.com
- IV
Life & fun · 13d ago · tanzaniaeducationproject.org
Turn a phone, tablet or TV into a sign. Type a message and it fills the screen: welcome signs, timers, Wi-Fi passwords and more. No app, no account, free.
Life & fun · 14d ago · bigwords.page
Play a free virtual guitar online with your keyboard or by touch. Slow songs down and see every chord, string and strum. Acoustic, classic, electric and bass.
Life & fun · 8d ago · guitoro.com
Carrier settings from iPhone, Pixel and Galaxy firmware, decoded and compared: APNs, VoLTE, 5G and Wi-Fi Calling per carrier, and what each build changed.
Life & fun · 12d ago · carrierexplode.com
Life & fun · 22d ago · space.bl2.net
Source: Show HN post ↗
Launched alongside, July 2019
the whole month →
Poolside FM 2.0▲676Super-summer music website inspired by a '90s OS
Life & fun · 2019 · v2.poolside.fm
Really good curated email design and code inspiration
Dev tools · 2019 · reallygoodemails.com