HypoPG/hypopg

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1696 stars · 61 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

HypoPG is a PostgreSQL extension written in C that adds support for hypothetical (virtual) indexes. It lets you test whether an index would improve query plans via EXPLAIN without actually creating it, saving CPU, disk, and time.

Use cases

• test if an index would speed up a slow query before creating it
• simulate CREATE INDEX statements and check EXPLAIN plans
• tune PostgreSQL query performance without index build overhead
• evaluate hypothetical partial indexes for specific queries
• check whether the PostgreSQL planner would use a proposed index

When to choose

• you need to evaluate index benefits on a live PostgreSQL database without resource cost
• you are doing query plan analysis and index tuning
• you want per-backend virtual indexes that don't affect concurrent sessions

When to avoid

• you use a database other than PostgreSQL
• you need actual persistent indexes rather than plan simulation
• you need extension upgrade scripts or persisted index metadata

Facets

library · maturity stable

database developer-tools benchmarking databases developer-tools performance windows self-hosted postgresql-extension hypothetical-indexes query-optimization explain index-tuning c-extension linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="HypoPG/hypopg")