Efficiently find slow queries?
Slow query performance is one of the leading bottlenecks for slow application performance.
Is there any tool / library, which allows you to track down which exact queries, i.e. with reference to the code itself, similar to sentry, lead to a slow query performance?
(Or rather show the performance for each query, so you can determine yourself, if the performance is acceptable or not)
I'm aware, that database hosts itself show the performance of queries, but linking their query performance to the code is still a hurdle.
3 Replies
@jiasheng
Prisma
Configuring logging (Concepts)
Learn how to configure Prisma Client to log the raw SQL queries it sends to the database and other information.
if prisma isnt enough to analyse
you will have to enter heavy db