Query insights
AI-powered insights
built into Prisma Postgres
Understand why your database queries are slow, see their real impact in production, and generate a structured AI prompt to improve them.
Query Insights is included with Prisma Postgres at no additional cost.Average Latency
15Milliseconds
Average Latency
15Milliseconds
| Latency | Executions | Reads | Last seen | |
|---|---|---|---|---|
| 15ms | SELECT p.id, p.title, p.content, p.published, p.authorId, p.createdAt, u.id as author_id, u.name, u.email FROM Post p INNER JOIN User u ON p.authorId = u.id WHERE p.published = true ORDER BY p.createdAt DESC LIMIT 10; | 7 | 10 | 12:32:31 |
| 22ms | post.findMany({ where: { published: true }, include: { author: true }, orderBy: { createdAt: 'desc' }, take: 10 }) | 18 | 13 | 12:32:31 |
Actionable query visibility
Query Insights groups your queries, tracks execution time and read volume, and shows you which query shapes are driving performance issues, in one single overview page.
From application query to SQL impact
See which code-level query is causing slow responses or increased load. Prisma ORM queries get exclusive attribution. All other SQL queries are visible too.
Coming soon
Generate an AI prompt to fix it
Query Insights generates an optimization prompt for each query group, covering likely causes like missing indexes or excessive reads. Works with any AI coding assistant.
