Theo's Typesafe Cult•2y ago

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

Lois•2y ago

@jiasheng

Neto•2y ago

https://www.prisma.io/docs/concepts/components/prisma-client/working-with-prismaclient/logging#event-based-logging

Prisma

Configuring logging (Concepts)

Learn how to configure Prisma Client to log the raw SQL queries it sends to the database and other information.

Neto•2y ago

Query: SELECT "public"."User"."id", "public"."User"."email", "public"."User"."name" FROM "public"."User" WHERE 1=1 OFFSET $1
Params: [0]
Duration: 3ms

Query: SELECT "public"."User"."id", "public"."User"."email", "public"."User"."name" FROM "public"."User" WHERE 1=1 OFFSET $1
Params: [0]
Duration: 3ms

if prisma isnt enough to analyse you will have to enter heavy db t3ggHeh

Gaming

Programming

Efficiently find slow queries?