Database Autonomy Service (DAS) provides the log analysis feature for slow queries. You can use this feature to view the trend, statistics, and details of slow queries. This helps you identify, analyze, and track slow query logs.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. On the page that appears, click the ID of the database instance that you want to manage. The instance details page appears.
  4. In the left-side navigation pane, choose Request Analysis > Slow Logs.
  5. On the Slow Log Analysis tab, specify a time range and view the trend, statistics, and details of the slow queries within the time range.
    Note When you specify the time range, the end time must be later than the start time and the time range cannot exceed 24 hours. You can query the slow query logs within the latest month at most.
    • Click a time point in the trend chart and view the statistics and details of the slow queries around that time point.
      Note If the request content is hidden, move the pointer over the request content and view the full request content in the window that appears.
    • In the Nodes section, view the number of slow queries of each node.
    • Click Export Slow Log to download slow query logs.
    • On the Slow Log Statistics tab, click Sample in the Actions column corresponding to the SQL template that you want to manage. In the Slow Log Sample dialog box, view the details of the slow query log.
    Slow query logs