# Explore insights and improve app performance with Prisma Optimize

URL: https://www.prisma.io/blog/prisma-optimize-early-access
Published: 2024-05-15
Updated: 2026-10-13
Authors: Søren Bramer Schmidt
Tags: announcement
Description: Explore insights into your database operations to diagnose performance problems and enhance your application's performance and user experience.

> [!WARNING]
> **Update:** Prisma Optimize has been sunset and replaced by Query Insights in Prisma Postgres. This post is kept for reference. See [Optimize has been sunset](#optimize-has-been-sunset) for how to remove it and what to use instead.

Introducing Prisma Optimize, a whole new way to debug performance-related issues, make your app faster, and learn about the Prisma ORM internals!

Have you ever wondered about the SQL queries that Prisma ORM crafts behind the scenes? Or perhaps you've aimed to enhance your application's performance and user experience? Prisma Optimize is here to transform how you understand and improve your project.

Prisma Optimize provides unprecedented access into the inner workings of the Prisma ORM, offering complete transparency over the generated SQL and operational efficiency.

We are launching Optimize in Early Access today and will add several exciting new features over the coming months.

## A real-world example [#a-real-world-example]

To demonstrate the power of Prisma Optimize, I've taken [Dub.co](https://dub.co/), a prominent open-source project utilizing the Prisma ORM, and created a video walkthrough showcasing how Prisma Optimize helps me get a handle on what is going on under the hood.

[Watch the video on YouTube](https://www.youtube.com/watch?v=gWROOjjEiM0)

## Why database performance bottlenecks cause apps to slow down [#why-database-performance-bottlenecks-cause-apps-to-slow-down]

Slow applications frustrate users and can hinder business growth. Often, the root cause lies within database interactions, which can be complex and opaque. Inefficient queries, excessive data fetching, and poorly optimized database schemas are common culprits that degrade performance.

Prisma Optimize addresses these issues head-on by providing clear insights into your database operations. It enables developers to pinpoint slow queries, recognize over-fetching of data, and identify inefficient relationships in your database schema. With Prisma Optimize, you can streamline your database interactions to significantly speed up your application, ensuring a smoother and more responsive user experience.

Prisma Optimize not only helps you diagnose performance problems but also educates you on the intricacies of database management, making it an indispensable tool for developers looking to excel at optimizing application speed while learning new skills and knowledge.

## A comprehensive tool for data-driven application development [#a-comprehensive-tool-for-data-driven-application-development]

Optimize is a [Client Extension](https://www.prisma.io/docs/orm/v7/prisma-client/client-extensions) that can be enabled in any app that uses the Prisma ORM. It seamlessly collects performance information from your app by integrating with Prisma ORM's robust [observability and logging](https://www.prisma.io/docs/orm/v7/prisma-client/observability-and-logging/logging) infrastructure. This data is then transmitted and displayed in an intuitive dashboard providing clear and actionable insights. Moving forward, as we grow the product features for Optimize, we will include features that make recommendations on how to address the issues we uncover. Stay tuned!

Prisma Optimize is a tool you use during development, and the general workflow looks something like this:

* You identify an aspect of your app that you want to analyze. This could be a UI interaction or a background processing job.
* You then enable Optimize and activate this part of the app - for example, by clicking around on the website or hitting an API endpoint.
* Optimize will actively collect all executed Prisma ORM queries along with crucial performance metrics such as query latency, frequency, and any associated errors. It also provides visibility into the exact SQL generated for each query.

## Optimize has been sunset [#optimize-has-been-sunset]

We announced the sunset of Prisma Optimize on March 23, 2026, and the `@prisma/extension-optimize` package is now deprecated. Its replacement is [Query Insights](https://www.prisma.io/docs/query-insights), which is built into Prisma Postgres and shows query latency, the full SQL of each query, and suggested fixes without a client extension or a recording step.

If a project still uses Optimize, you can safely remove it:

1. Uninstall the package:

#### bun

```bash
bun remove @prisma/extension-optimize
```

#### pnpm

```bash
pnpm remove @prisma/extension-optimize
```

#### yarn

```bash
yarn remove @prisma/extension-optimize
```

#### npm

```bash
npm uninstall @prisma/extension-optimize
```

2. Remove the `withOptimize` import and the `.$extends(withOptimize())` call from your Prisma Client setup.

For the background, read [Sunsetting Prisma Optimize](https://www.prisma.io/blog/sunsetting-prisma-optimize).