PG Extras – a set of tools for debugging PostgreSQL performance issues

In plain words

PG Extras is a debugging toolkit for PostgreSQL performance optimization. It helps developers and database administrators identify and resolve performance issues in PostgreSQL databases. The tool provides utilities designed to analyze query execution, index usage, and system bottlenecks. It is suitable for anyone managing PostgreSQL databases who needs diagnostic insights to improve database efficiency and troubleshoot slow queries or other performance problems.

written from the facts on this page · September 2026

From the sources

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 present a step by step guide on using PG Extras library to spot and resolve common PostgreSQL database per

hotpath-rs profiles CPU, memory, SQL, async execution, channels and lock contention. 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. PG Extras is a tool that allows you to spot common PostgreSQL pitfalls. Rails , Rust and Elixir implementations are currently available. In this blog post, I present a step by step guide on using PG Extras library to spot and resolve common PostgreSQL database performance issues. Please refer to READMEs of respective implementations for…from pawelurbanek.com

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

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

• 
  PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲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…

• 
  Postgres as a VectorDB GUI2024 · github.com · ▲162

  Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.

• 
  PgCat, Postgres pooler with sharding, load balancing and failover2022 · github.com · ▲233

  PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat

• PE
  Pg-extend-rs – Easy Postgres extensions in Rust2018 · bluejekyll.github.io · ▲244
• 
  pg_netstat, a Postgres extension to monitor database network traffic2022 · github.com · ▲158

  pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.

• 
  /dev/null▲472

  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

• 
  Magic Sidebar by BlackMagic.so▲1,084

  Powerful enhanced experience for Twitter

  Life & fun · 2021 · blackmagic.so

• 
  I made a modern web UI for Wikipedia▲979

  A beautiful, clean, modern web UI for Wikipedia. Enhance your Wikipedia experience with a redesigned look, new features and customization.

  Life & fun · 2021 · modernwiki.app

• 
  thirdweb▲897

  Build web3 apps and games, easily

  Dev tools · 2021 · thirdweb.com

• 
  Emoji to Scale▲713

  Your favorite emojis. To scale (more or less).

  Life & fun · 2021 · javier.xyz

• 
  Alfread▲641

  Actually read articles saved for later

  Work · 2021

• 
  BitsForDigits▲624

  A partial buyout marketplace free for bootstrapped founders

  Commerce · 2021 · flippa.com