Recommendations
Query Pattern
Query patterns are used to group similar queries together and analyze their performance.
await prisma.product.findMany({ where: { quantity: { lt: 50 } }, include: { orderItems: { include: { order: { include: { user: true } } } } } });
Schema Recommendations
For optimizing this query, consider enabling the `relationJoins` preview feature in your Prisma schema. This feature optimizes nested queries by using SQL joins, potentially improving performance for complex queries.
Proposed Schema
generator client {
provider = "prisma-client-js"
- // previewFeatures = []
+ previewFeatures = ["relationJoins"]
}Performance
Metrics
These are your key database performance metrics in the selected time range.
Average total duration
256.22msAVG
260msP50
293.5msP99
294.39msMAX
Queries per second
14.66-2%
vs. prior 7 days
Error rate
0.001%-2%
vs. prior 7 days
Overall status
Regression
vs. prior 7 days
Latencies
The following graph shows the time it takes for prisma queries to complete
Errors
The following graph shows the query failures and successes over time.