# HypoPG/hypopg

Hypothetical Indexes for PostgreSQL

Repository: https://github.com/HypoPG/hypopg
Canonical: https://ross.abutalabs.com/products/hypopg
Homepage: https://hypopg.readthedocs.io
Language: C
License: NOASSERTION
License Family: other
Topics: postgresql, hypothetical-indexes, database, c, extension, indexing, index
Last push: 2026-06-19T23:40:27+00:00

## Health v2 (maintenance only)
Score: 80/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 88, release rhythm 57, longevity 100
- inputs: {"age_days": 4100, "days_push": 75, "days_rel": 75, "gap_med": 355, "n_releases_24m": 2}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1696, forks 61 (observed 2026-08-28T04:05:23.933530+00:00)

## What it is
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
- artifact type: library
- maturity: stable
- function: database, developer-tools, benchmarking
- domain: databases, developer-tools, performance
- platform: windows, self-hosted
- tags: postgresql-extension, hypothetical-indexes, query-optimization, explain, index-tuning, c-extension, linux, macos

## Member repositories
- HypoPG/hypopg (main) score 80

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:23.933530+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:37:52.919682+00:00, confidence not recorded.
  - readme: https://github.com/HypoPG/hypopg (fetched 2026-08-28T04:05:23.933530+00:00, sha 66dd6757e608)
- Data as of 2026-08-30T08:39:29.467469+00:00.