In APM, the Databases page shows an application's database and cache data. The page shows 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.
We divide the database information into three parts:
- All-databases overview (main page)
- Top five database operations by wall-clock time
- Database response time
- Database throughput (operation requests per minute or rpm)
- Top database operations (subpage)
- Query time
- Time consumption by caller
- Table with all database operations (subpage)
As of June 30, 2022, we're discontinuing support for several capabilities, including the classic APM Databases page that you could toggle on and off in the UI. For more details, including how you can easily prepare for this transition, see our Support Forum post.
Choose one of the following to open the page:
- Go to one.newrelic.com > All capabilities > All entities > (select an app) > Monitor > Databases.
- Go to one.newrelic.com > All capabilities > APM & services > (select an app) > Monitor > Databases.
To get a high-level overview of all your applications and services, use our entity explorer.
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.
Review top database operations
The main Databases page shows a list of top database operations that you can sort in a variety of ways.
To get details about an operation, you can either hover over the record, or you can click on it to see additional charts.
When you click on a record, you can see the Time consumption by caller chart. This 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.
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.
To delete all traces for your app permanently:
- Select the Delete all traces button below the database operations list.
- 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.).
Additional features based on agent version
Additional features on the Databases page are available with following agent versions. For more information, see Update the New Relic agent.
- 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.