All Tools
H
DataFreeOpen Source
HYPOPG
Hypothetical indexes for PostgreSQL query planning
PostgreSQL
ABOUT
Choosing indexes for RAG metadata tables, feature stores, and agent event logs usually means CREATE INDEX, wait, EXPLAIN, DROP. HypoPG lets you inject virtual indexes into a single backend so EXPLAIN shows whether Postgres would use them, with no disk cost and no impact on other sessions.
INSTALL
brew install hypopgINTEGRATION GUIDE
1. Test whether a btree on embedding_id would change a slow RAG lookup plan
2. Compare hypothetical composite indexes on a feature-store fact table
3. Teach query planning in notebooks without mutating a shared Postgres
4. Screen index ideas before running CREATE INDEX CONCURRENTLY in production
TAGS
postgresqlindexesquery-planningextensionperformanceexplain