So far I've had the best luck with pg_stat_statements + auto explain + Claude Code to go digging through those.