Has anyone successfully tried sql-tap? (https://github.com/mickamy/sql-tap) It basically sits between you and the database and would help to debug long running queries locally as it can capture the actual queries with parameters (our queries are complex and often have 10s of parameters).
The problem is that it would need to sit between postgrest and postgres but those containers and their configurations are managed by supabase when you run it locally (supabase start).
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.