• English日本語한국어
  • Log inStart now

View slow query details

In APM, when transaction traces are collected, there may be additional Slow query data available on the Databases page. Let's look at what slow query data is, where to find it, and how to configure it.

You can also use histograms and heatmaps to visualize the distribution of values for different metrics. This is useful to understand slow page performance. To learn how, watch this short video (4:18 minutes).

Slow query data samples

When transaction traces are reported, the slow queries feature samples the slowest database queries in those traces and reports data about them on the Databases page. Slow query data can include:

View slow query data

Tip

To get a high-level overview of all your applications and services, use our entity explorer.

To see your slow query data:

  1. Go to one.newrelic.com > All capabilities > APM & Services. Select an app, then under the Monitor section, click Databases.
  2. Select a database transaction.
  3. If available, select any available slow queries listed on the page.

If you do not see expected slow query data, follow the troubleshooting tips.

Configuration

In general, you can configure your slow query settings either of these ways:

Agent configuration gives you more options than server-side configuration does. How you choose to configure slow queries will depend on your own setup and preferences. For more information, see the documentation for the specific agent:

Slow queries metrics

The slow queries list contains the following metrics:

Metric

Description

Response time

The average response time (in milliseconds) for the statements sampled.

Sample count

The number of slow queries identified in the sample.

To view additional details, select an individual slow query:

Metric

Description

Start time

When the stack trace began collecting the data shown.

Max time

The maximum time for all similar query statements in the sample.

Action

The action or process invoking the query.

Query

The query that is being reported as slow. Depending on your configuration, some parts of the query may be obfuscated.

Stack trace

Where in the code the statement was called.

For MySQL, we provide a query analysis, which explains what happened in your query and what you might do to speed it up. Other databases display an explain plan whenever possible.

Troubleshooting: No slow query data

If you do not see slow query data, it may be for any of these reasons:

  • The slow query feature has been disabled.
  • The threshold is set to too high a duration and no slow queries are being reported.
  • The query obfuscation setting (usually record_sql or similar) may be set to Off.

To solve the problem, try adjusting the configuration options.

Copyright © 2024 New Relic Inc.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.