Dev tools · alternatives · 2026
24 alternatives to Pg_insights – Convenient SQL for monitoring Postgres database health
A collection of convenient SQL for monitoring Postgres database health. - lob/pg_insights
Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Pg_insights – Convenient SQL for monitoring Postgres database health launched in 2019; newer entries below may have overtaken it.
- 1
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
- 2PN
We've been hard at work for a few weeks and thought it's time for another update. In case you missed our first post, PostgresML is an end-to-end machine learning solution, running alongside your favorite database. This time we have more of a suite offering: project management, visibility into the datasets and the deployment pipeline decision making. Let us know what you think! Demo link is on the page, and also here: https://demo.postgresml.org
2022 · postgresml.org · its alternatives →
- 3
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 →
- 4
The AI that knows your Postgres database
2024 · chat-with-your-database.vercel.app · its alternatives →
- 5
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an…
2024 · github.com · its alternatives →
- 6
pganalyze▲84Automated EXPLAIN Plan Visualization & Insights for Postgres
2019 · pganalyze.com · its alternatives →
- 7
- 8
hi hn, hydra ceo here hydra is an open source, column-oriented postgres. you can set up remarkably fast aggregates on your project in minutes to query billions of rows instantly. postgres is great, but aggregates can take minutes to hours to return results on large data sets. long-running analytical queries hog database resources and degrade performance. use hydra to run much faster analytics on postgres without making code changes. data is automatically loaded into columnar format and compressed. connect to hydra with your preferred postgres client (psql, dbeaver, etc). following 4 months…
2023 · hydra-so.notion.site · its alternatives →
- 9
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 10
- 11
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 12
SQL Chat▲166ChatGPT powered SQL client for Postgres, MySQL & SQL Server
2023 · bytebase.com · its alternatives →
- 13
A look at modern database approaches and how Citus scales PG
2016 · softwareengineeringdaily.com · its alternatives →
- 14
- 15HO
hi hn, hydra ceo here hydra is an open-source extension that adds columnar tables to Postgres for efficient analytical reporting. With Hydra, you can analyze billions of rows instantly without changing code. demo video (5 min): https://youtu.be/1yzxgb0Oyrw github repo: https://github.com/hydradatabase/hydra For 1.0 GA release, aggregate queries are over *60% faster* than Hydra beta due to aggregate vectorization. Spatial indexes (gin, gist, spgist, and rum indexes) and pg_hint_plan are now enabled for performance optimization. postgres is great, but…
2023 · hydra.so · its alternatives →
- 16
I created this small guide for people starting with postgresql. I added some queries I commonly used as well. Any feedback?
2023 · github.com · its alternatives →
- 17
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
- 19
A better way to index your Postgres database
2021 · pganalyze.com · its alternatives →
- 20
Easy postgres codebase injection - aka postgres non data live reload - oelmekki/pgrebase
2016 · github.com · its alternatives →
- 21
Postgres extension that speeds up analytics queries by upto 90% - sushrut141/pg_analytica
2024 · github.com · its alternatives →
- 22AU
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 →
- 23
Hi HN, we're excited to share our open source tool with the community! We previously posted here with the tagline “real-time events for Postgres” [0]. But after feedback from early users and the community, we’ve shifted our focus to working on tooling for manual database changes. We've consistently heard teams describe challenges with the way manual data updates are handled. Seemingly every engineer we spoke with had examples of errant queries that ended up causing significant harm in production environments (data loss/service interruptions). We’ve seen a few different approaches to how…
2023 · github.com · its alternatives →
- 24
Also compare
- pg_flame – flamegraph visualizations of PostgreSQL query plans alternatives
- PostgresML, now with analytics and project management alternatives
- pg_netstat, a Postgres extension to monitor database network traffic alternatives
- Chat With Your Database alternatives
- PostgreSQL index advisor alternatives
- pganalyze alternatives
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 →