Databases page: View operations, throughput, response time

In New Relic APM, the Databases page shows an application's database and cache data. The page will show individual database transactions as a sortable table, and operations, throughput, and response time as charts. If slow queries have been reported, they are shown when you select a transaction.

Access to this feature depends on your subscription level.

Agent version requirements

Additional features on the Databases page are available with following agent versions. For more information, see Update the New Relic agent.

  • C SDK 1.0.0 or higher
  • Go 1.4 or higher
  • Java 3.14.0 or higher
  • .NET 4.1.134 or higher
  • Node.js 1.17.0 or higher
  • PHP 4.19.0 or higher
  • Python 2.44.0 or higher
  • Ruby 3.11.0 or higher

These features include:

  • Multiple database and cache types
  • Labels for different types in the operations list, charts, and slow queries
  • Filtering operations and charts for a specific database vendor or cache type
  • Viewing a table of all database operations
  • Ability to view the databases on Service maps

In addition, if your APM agent supports host and instance level details, you can view both the query details and the specific instance where the query was executed.

View Databases page details

To get a high-level overview of all your applications and services, use the entity explorer in New Relic One.

To view information about database performance:

In New Relic One

Go to > Entity explorer > (select an app) > Explore performance > Databases.

For more information, see the documentation about navigating core UI components in New Relic One.

In New Relic APM
  1. Go to > (select an app) > Monitoring > Databases.
  2. To show details about an individual operation or query, select the row in the database operations list to expand it. If slow query details have been reported, they will be displayed under the Slow queries section.
  3. To exit the selected item, select its Close (X) button, or select another row in the list.
APM Databases page > (select an app) > Monitoring > Databases: Use this page to view and sort detailed information about database performance and slow queries (if applicable).

For more information, check out the New Relic University tutorial APM database dashboard. Or, go directly to the full online course APM for power users.

Use any of New Relic's standard user interface functions to drill down into detailed information.

The All databases overview shows:

  • Top five database operations by wall-clock time
  • Database response time
  • Database throughput (operation requests per minute or rpm)

The details for individual operations show:

  • Query time
  • Throughput
  • Time consumption by caller

The Time consumption by caller chart displays a list of the transactions calling the selected operation, with color bars indicating the percentage of time consumed by each caller. To view the Transactions page for a caller transaction, select the color bar for that transaction in the chart.

Filter operations by database vendor

If available: Above the list of database operations, buttons allow you to filter down to a specific database vendor.

  • To filter the contents by database vendor, select its name.
  • To remove the filter, select All.

Display all database operations

To show all database operations if available:

  • At the bottom of the operations list, select the Show all database operations table... link.
  • To sort the table by any column, select the column's header.
  • To filter the list of operations, use the search box at the top of the table.
  • To view details on a specific operation, select the operation name.

Delete traces

Owner, Admins, or add-on managers

To delete all traces for your app permanently:

  1. Select the Delete all traces button below the database operations list.
  2. Select the confirmation prompt.

If you are doing general record cleanup, you may also want to delete transaction traces or error traces. This will remove potentially sensitive data while retaining your other application data (such as Apdex, deployment information, etc.).

For more help

Recommendations for learning more: