hypopg

PostgreSQL extension for creating hypothetical indexes without disk space

brewmacoslinux

Try with needOr install directly

About

Hypothetical Indexes for PostgreSQL

hypopg

Create a hypothetical index to test query performance impact$ SELECT * FROM hypopg_create_index('CREATE INDEX ON table_name (column_name)');

List all hypothetical indexes that have been created$ SELECT * FROM hypopg_list_indexes();

Reset all hypothetical indexes and start fresh$ SELECT hypopg_reset();