Postgres has some pretty great tooling around understanding slow queries — you can just ask the database to tell you what’s taking it so long.| pgMustard
