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…
What it does
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 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 a complement, not a replacement, to things like static analysis and the official Postgres docs. Curious to see what others think; feedback is more than welcome! https://github.com/agis/pglockanalyze Thanks in advance [1] typically an ephemeral database spawned by your CI pipeline
Does the same job
all alternatives →
- AUA user interface for Postgres EXPLAIN that also gives tips2019 · pgmustard.com · ▲50
- STScript to compare Postgres data between two points in time2021 · ▲55
https://github.com/denvaar/pgdiff I cobbled together various programs into a bash script to compare how data changes between two points in time. My idea was basically to have a `git diff` but for data inside postgres. I wanted a util like this to help get to know a new code base: Interact with an app and watch how the data changes. You run the script with a given key (anything) before interacting with an app, then run it again with the same key to see the data diff. I'm not much of a bash scripter, as you can probably see from the script, but it was a fun and useful tool…
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Launched alongside, May 2025
the whole month →
- C9
Life & fun · 2025 · felixrieseberg.github.io
