Database Autonomy Service (DAS) provides the slow query log analysis feature. You can use this feature to view slow query trends, information about slow query executions, and suggestions on how to optimize slow queries.

Procedure

  1. In the left-side navigation pane, choose Request Analysis > Slow Logs.
    mongo
    Note By default, the Slow Log Trend chart shows slow query logs within the latest 15 minutes. You can specify the time range and click Search to view slow query logs. The maximum time range is one day.
  2. View the details of slow query logs by using one of the following methods:
    • Method 1:
      1. Click the Slow Log Details tab under the Slow Log Trend chart.
      2. On the Slow Log Details tab, select the database that you want to query.
        Note If the request content is hidden, you can move the pointer over the request content and view the full request content in the window that appears.
    • Method 2:
      1. In the Slow Log Trend chart, click the point in time at which a slow query log is generated. On the Slow Log Statistics tab, view the details of the slow query log.
      2. On the Slow Log Statistics tab, click Sample in the Actions column. In the Slow Log Sample dialog box, view the details of the slow query log.
        Note If the request content is hidden, you can move the pointer over the request content and view the full request content in the window that appears.