pglockanalyze - See the locks your Postgres migrations will acquire
Hello! I created this tool to make reasoning about Postgres locks a bit easier. Given a database[1] and a set of DDL statements/migrations you want to check, pglockanalyze will open a transaction, execute the statements, read the pg_locks view to analyze the locks they acquire and rollback (or commit, depending on the flags you passed) the transaction. Then, it will output the results for each statement. I think there's merit in this idea, that said it's very much an experiment so there could be flaws and/or corner cases that this strategy won't work well for. It's meant to act as…
pglockanalyze - See the locks your Postgres migrations will acquire launched on May 31, 2025 with 8 votes, #2,977 of 7,905 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 1 year on.
What it does
See what PostgreSQL locks your migrations acquired - agis/pglockanalyze
See what locks your Postgres migrations will acquire—before you run them in production. To be used in CI and development environments; see pglockanalyze-action for integration with GitHub Actions. This software is in alpha stage - expect breaking changes between releases and a lot of rough edges. Understanding the locks your migrations will acquire is crucial to avoiding downtime in production traffic. Tools like the official Postgres docs and strong_migrations are invaluable; however, reasoning your way through complex DDL statements is not always practical. pglockanalyze is meant to complement, not replace such tools, by executing your migrations against a test database (that you have to…from github.com
In the maker’s words, at launch
Hello! I created this tool to make reasoning about Postgres locks a bit easier. Given a database[1] and a set of DDL statements/migrations you want to check, pglockanalyze will open a transaction, execute the statements, read the pg_locks view to analyze the locks they acquire and rollback (or commit, depending…
Does a similar job
all alternatives →
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.
- AUA user interface for Postgres EXPLAIN that also gives tips2019 · pgmustard.com · ▲50
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
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…
pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
SQL-tap – Real-time SQL traffic viewer for PostgreSQL and MySQLFeb 2026 · github.com · ▲233sql-tap is a transparent proxy that captures SQL queries by parsing the PostgreSQL/MySQL wire protocol and displays them in a terminal UI. You can run EXPLAIN on any captured query. No application code changes needed — just change the port.
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 28d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 26d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 23d ago · openbot.run
Talanoa▲346Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 21d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 28d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, May 2025
the whole month →
Tapflow 2.0▲1,125We built Tapflow for devs, designers, PMs, and tech folks who’ve been sitting on internal docs, templates, and systems — but never productized them. Upload a PDF, notes, or workshop deck, and Tapflow drafts a structured product (with chapters, teaser and pricing plans). It’s good for AI kits, onboarding guides, design systems, and frameworks. You can sell through Stripe, LemonSqueezy, or PayPal. Real-time collaboration is in early beta. No site builder, no LMS — clean design and just focused tools to ship. Fully bootstrapped and just launched on PH today →…
Work · 2025 · tapflow.ai
- C9
Life & fun · 2025 · felixrieseberg.github.io
Appwrite Sites▲990Appwrite 2.0 brings a new engine, a rebuilt Console, five database types, an S3 API, an OAuth 2.1 server, and organization-level Domains and Firewall.
Dev tools · 2025 · appwrite.io
