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

Background information

The slow query logs are generated by the database kernel. The parameters and thresholds vary based on the database engine. For more information, see the corresponding official documentation.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. On the page that appears, find the database instance that you want to manage and click the instance ID. 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 trends, statistics, and details of the slow queries within the specified time range.
    Note When you specify the time range, the end time must be later than the start time, and the interval between the start time and the end time cannot exceed 24 hours. You can query slow query logs within the latest month.
    • You can click a time point in the trend chart and view the statistics and details of the slow queries at the time point.
    • In the Nodes section, you can view the number of slow queries on each node.
    • Click Export Slow Log to download slow query logs to your computer.
    • On the Slow Log Statistics tab, find the SQL template that you want to view and click Sample in the Actions column. In the Slow Log Sample dialog box, view the details of the slow query log.
    Slow query logs