nowfound

Dev tools · September 23, 2021

pganalyze Index Advisor for Postgres

A better way to index your Postgres database

pganalyze Index Advisor for Postgres launched on September 23, 2021 with 78 votes, #798 of 2,941 launches that month and more than 50% of that year's launches. The site was still online in September 2026, 5 years on.

Visit pganalyze.com ↗Alternatives

What it does

The index advisor makes recommendations for creating the best indexes for your Postgres queries, based on the schema and table statistics information. Improve query performance and save developer time by quickly getting the right CREATE INDEX command.

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!

Does a similar job

all alternatives →
  • PostgreSQL index advisor2024 · github.com · ▲417

    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…

  • 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!

  • Chat With Your Database2024 · chat-with-your-database.vercel.app · ▲198

    The AI that knows your Postgres database

  • pganalyze2019 · pganalyze.com · ▲84

    Automated EXPLAIN Plan Visualization & Insights for Postgres

  • Postgres Playground2022 · crunchydata.com · ▲161

    Hands-on tutorials to learn Postgres

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

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

More dev tools this month

the category →
  • /dev/null▲482

    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▲343

    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 · 28d ago · corespeed.io

Source: Product Hunt launch ↗

Launched alongside, September 2021

the whole month →