npm

dexter

Automatic indexer for PostgreSQL that suggests and creates indexes

brewmacoslinux
Try with needOr install directly
Source

About

Automatic indexer for Postgres

Commands

dexter

Examples

Analyze a PostgreSQL database and get index recommendations$ dexter postgresql://user:password@localhost/mydb
Create suggested indexes automatically$ dexter postgresql://user:password@localhost/mydb --create
Show index recommendations without creating them$ dexter postgresql://user:password@localhost/mydb --dry-run