[Shipped] Connecting your DB Query to the Exact Line of Code

[ishkebab]

Back in September, Sentry launched the new Queries workflow as an addition to our Performance product. This was an exciting new feature, giving developers precise visibility into the impact of slow database queries on their application performance, but we aren't stopping there...

Today we are proud to launch an update to Queries that will lead developers from the SQL query directly to the source code. Our continuing goal with Sentry Performance is to help developers drive solutions, and connecting back to the code is part of that effort. Many modern applications rely on ORMs (e.g., SQLAlchemy) to interact with the DB, so identifying the code context is essential to resolving performance problems.

The precise line of application code triggering the query will be surfaced to the user on the Query Summary page:

Furthermore, if your Github repo is linked to the project, clicking on this will take you straight to the exact line of code in the UI!

For our initial feature release, we will be supporting Laravel and Django. Additional platforms will be supported in the future. Take a look at the documentation to get started.

Note: Our current implementation limits this feature to "slow queries" with a minimum duration that is configurable in your application. This is to ensure that any overhead involved in fetching the stack trace is insignificant compared to the query duration. The default threshold will be 100ms.

Please let us know your thoughts on this new feature:

• What additional platforms would you like to see supported in the future?
• What further capabilities might be useful for your application?
• Does the 100ms default query threshold work for you?

Please Note: To use the Queries tool, you will need to set up our Performance product. Please take a look at our setup guide.