Show HN: PostgreSQL Index Advisor

• index_advisor

  5 1,397 2.8 PLpgSQL

  PostgreSQL Index Advisor

  

2. Copy/paste the plpgsql file:

https://github.com/supabase/index_advisor/blob/main/index_ad...

We are also developing the Trusted Language Extension with the RDS team, so at some point it should be easier to do this through database.dev:

https://database.dev/olirice/index_advisor

• hypopg

  6 1,251 5.0 C

  Hypothetical Indexes for PostgreSQL

  

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 excellent extension to determine if PostgreSQL will use a given index without spending resources to create them.

[0] pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.htm...

[1] https://github.com/HypoPG/hypopg

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• PgHero

  11 7,695 7.2 Ruby

  A performance dashboard for Postgres

I am using https://github.com/ankane/pghero/ and this is one of its features with GUI

• jopt2023

  1 0 1.5

If anyone has some background in optimization and is interested in the more technical side of things, I gave a talk at JOPT 2023, comparing MIP and CP approaches for this problem. The slides can be found here: https://github.com/PhilippeOlivier/jopt2023

• dexter

  3 1,759 7.0 Ruby

  The automatic indexer for Postgres

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project