Dev tools · alternatives · 2026

24 alternatives to 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…

Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes.

1
Postgres query lock explainer▲143
This 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.
2023 · github.com · its alternatives →
2AU
A user interface for Postgres EXPLAIN that also gives tips▲50
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
2019 · pgmustard.com · its alternatives →
3
PgDog – Scale Postgres without changing the app▲326
Hey 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…
Feb 2026 · github.com · its alternatives →
4
pganalyze▲84
Automated EXPLAIN Plan Visualization & Insights for Postgres
2019 · pganalyze.com · its alternatives →
5
pg_flame – flamegraph visualizations of PostgreSQL query plans▲321
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
6
PgQueuer – Transform PostgreSQL into a Job Queue▲376
PgQueuer 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!
2024 · github.com · its alternatives →
7
SQL-tap – Real-time SQL traffic viewer for PostgreSQL and MySQL▲233
sql-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.
Feb 2026 · github.com · its alternatives →
8
pg_netstat, a Postgres extension to monitor database network traffic▲158
pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.
2022 · github.com · its alternatives →
9
Pg_yregress, Structured Testing for Postgres▲56
Originally inspired by pg_regress, pg_yregress provides a TAP-compatible test executor that allows for better test organization, easier instance management, native JSON handling and so on.
2023 · github.com · its alternatives →
10
PgCat, Postgres pooler with sharding, load balancing and failover▲233
PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
2022 · github.com · its alternatives →
11
Speeding up PostgreSQL through vectorized execution▲332
Vectorized executor to speed up PostgreSQL. Contribute to citusdata/postgres_vectorization_test development by creating an account on GitHub.
2014 · github.com · its alternatives →
12
Postgres as a VectorDB GUI▲162
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
13IB
I built this Postgres logger▲94
Hey HN, Some of you were really interested in Postgres logging with pgAudit in my previous post here: https://news.ycombinator.com/item?id=37082827 So I built this logger: https://rocketgraph.io/logger-demo using pgAudit to show you what can be done with Postgres auditing. It offers some powerful features like "get me all the CREATE queries that ran in the past hour". These are generated by AWS RDS Instance running on my Rocketgraph account. Then they are forwarded to Cloudwatch for complex querying. In the future we can connect these logs to slack so you can…
2023 · rocketgraph.io · its alternatives →
14
BemiDB – Postgres read replica optimized for analytics▲209
Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…
2024 · github.com · its alternatives →
15
DBOS Java – Postgres-Backed Durable Workflows▲114
Hi HN - I’m Peter, here with Harry (devhawk), and we’re building DBOS Java, an open-source Java library for durable workflows, backed by Postgres. https://github.com/dbos-inc/dbos-transact-java Essentially, DBOS helps you write long-lived, reliable code that can survive failures, restarts, and crashes without losing state or duplicating work. As your workflows run, it checkpoints each step they take in a Postgres database. When a process stops (fails, restarts, or crashes), your program can recover from those checkpoints to restore its exact state and continue from where…
Nov 2025 · github.com · its alternatives →
16
Open source, logical multi-master PostgreSQL replication▲151
Logical multi-master PostgreSQL replication. Contribute to pgEdge/spock development by creating an account on GitHub.
2025 · github.com · its alternatives →
17
PG Extras – a set of tools for debugging PostgreSQL performance issues▲12
PostgreSQL database queries are a common performance bottleneck for web apps. Before you resort to more complex optimization techniques like caching or read replicas, you should double-check if your database engine does not need tuning and queries are not underperforming. In this blog post, I presen
2021 · pawelurbanek.com · its alternatives →
18
PG-Capture – a better way to sync Postgres with Algolia (or Elastic)▲56
Hello HN! Keeping Elasticsearch or Algolia in sync with Postgres is a pain when your data spans multiple tables. Traditional CDC tools like Debezium capture table-level events but don’t help when you need to index a full entity composed of related records. That's why I built PG-Capture. PG-Capture lets you define a schema as complex as you need, aggregate table-level events, and reconstruct structured objects spanning multiple tables. It then publishes them as meaningful domain-level events to any queue (RabbitMQ, SQS, etc.). PG-Capture does NOT replace Debezium, it works on top of it (or…
2025 · pg-capture.onrender.com · its alternatives →
19
Diesel-guard – Lint Diesel migrations for unsafe PostgreSQL patterns▲18
Linter for dangerous Postgres migration patterns in Diesel and SQLx. Prevents downtime caused by unsafe schema changes. - ayarotsky/diesel-guard
Dec 2025 · github.com · its alternatives →
20
SQLite Transaction Benchmarking Tool▲128
I wanted to make my own evaluation of what kind of performance I could expect from SQLite on a server and investigate the experimental `BEGIN CONCURRENT` branch vs the inbuilt `DEFERRED` and `IMMEDIATE` behaviors. Explanatory blog post: https://reorchestrate.com/posts/sqlite-transactions/
2024 · github.com · its alternatives →
21
Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL▲48
Hi HN, Been hacking on a simple way to run agents entirely inside of a Postgres database, "an agent per row". Things you could build with this: * Your own agent orchestrator * A personal assistant with time travel * (more things I can't think of yet) Not quite there yet but thought I'd share it in its current state.
Feb 2026 · github.com · its alternatives →
22
PgRebase, codebase management for Postgres▲66
Easy postgres codebase injection - aka postgres non data live reload - oelmekki/pgrebase
2016 · github.com · its alternatives →
23
pganalyze Index Advisor – A better way to index your Postgres database▲14
DBAs and developers use pganalyze to identify the root cause of performance issues, optimize queries and to get alerts about critical issues. Sign up for free!
2021 · pganalyze.com · its alternatives →
24RA
RedixDB – a fast persistent key-value store with the Redis protocol▲75
a very simple pure key => value storage system that speaks Redis protocol with Postgres as storage engine and more
2018 · alash3al.github.io · its alternatives →

Also compare

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →