pganalyze

What it does

pganalyze provides deep insights into Postgres. Other monitoring tools show you what happened. pganalyze tells you why. We've just introduced automated EXPLAIN plan collection, visualization and insights, so you know exactly why queries are slow.

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!

Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Drill down into detailed per-query statistics and benefit from insights into your query performance history to detect slow queries. Automatically collect your EXPLAIN plans with auto_explain, and get detailed insights based on query plans gathered from your database. Understand why a query is slow and get tuning recommendations on how to make the query faster. Identify slowdowns for specific queries over time, I/O vs CPU time spent, and buffer cache hit ratio for each query. Automatically detects missing indexes and recommends single and multi-column indexes that…from pganalyze.com

• 
  pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321

  A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame

• 
  pganalyze Index Advisor – A better way to index your Postgres database2021 · pganalyze.com · ▲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!

• PN
  PostgresML, now with analytics and project management2022 · postgresml.org · ▲444

  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

• AU
  A 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.

• 
  Postgres query lock explainer2023 · github.com · ▲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.

• 
  pganalyze Index Advisor for Postgres2021 · pganalyze.com · ▲78

  A better way to index your Postgres database

• 
  /dev/null▲468

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲340

  Hi 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 · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  Exploding Topics▲949

  Find proven topics before they take off.

  Growth · 2019 · explodingtopics.com

• AA
  Angeldust – a fast and efficient video game▲716

  After years of solo development I'm presenting: Angeldust, an omni-compatible action RPG and building game! Website: http://angeldu.st My single server hosts 250+K active players in one giant, dynamic fantasy world. Angeldust's game server is pervasively multithreaded, implementing John Carmack's dream of processing an immutable world state each tick. Both world handling and network traffic routing uses any number of threads. For networking, a typical game session only uses ~3Kbps of bandwidth, enabling decent play even over 2G/EDGE networks. The client is programmed in C++…

  Growth · 2019

• AS
  A searchable list of self-hosted software with screenshots▲656

  Dev tools · 2019 · selfhostedsource.tech

• 
  A tiny isometric city builder in JavaScript▲593

  A isometric city builder in JavaScript. Contribute to victorqribeiro/isocity development by creating an account on GitHub.

  Dev tools · 2019 · github.com

• 
  AI Dungeon 2 – AI-generated text adventure built with 1.5B param GPT-2▲584

  Play and create AI-generated adventures with infinite possibilities.

  AI · 2019 · aidungeon.io

• 
  Mailmeteor▲567

  Send hundreds of personalized emails with Gmail.

  Growth · 2019 · mailmeteor.com