This extension allows the creation of hypothetical indexes for automatic analysis of query optimization. https://github.com/HypoPG/hypopg

Prerequisite for Dexter, the automatic indexer for Postgres: