dexter

Uses the HypoPG extension to test index recommendations without affecting the live database, ensuring no performance impact during analysis, as highlighted in the installation and usage sections.

Supports query analysis from pg_stat_statements, log files, SQL files, and live activity via pg_stat_activity, providing flexibility for different monitoring setups as described in the 'Collecting Queries' section.

Requires an explicit --create flag to apply indexes, preventing accidental changes, and offers filtering options like --min-calls and --exclude to tailor recommendations, making it safe for production use.

Can pipe log files with tail -F for continuous analysis, enabling proactive index recommendations as new slow queries appear, as shown in the log files example.