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: