I made this tool - it’s kind of like “explain” but it tells you about what locks would be required by the query.

I was making it as part of a larger tool that would try to prevent deadlocks during migrations at my last company, I never finished it.