hypopg ☆

« Back to VersTracker

Description:
Hypothetical Indexes for PostgreSQL

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql database indexing performance optimization

Install: brew install hypopg

About:
Hypopg is a PostgreSQL extension that allows users to create and test hypothetical indexes without affecting actual database performance or storage. It enables DBAs and developers to simulate index creation to analyze query execution plans and estimate performance improvements. This tool is invaluable for optimizing database performance in production environments where creating real indexes is costly or disruptive.

Key Features:

Create hypothetical B-tree, GiST, and GIN indexes
Non-invasive testing that doesn't modify database files
Integration with EXPLAIN ANALYZE for query plan analysis
Support for partial and expression indexes

Use Cases:

Testing index impact on query performance before production deployment
Analyzing query optimization opportunities without downtime
Capacity planning and database performance tuning

Alternatives:

pg_qualstats – Provides index suggestions based on actual query patterns rather than hypothetical testing
pg_stat_statements – Monitors query performance statistics but doesn't allow index simulation

Version History

Detected	Version	Rev	Change	Commit