All Products
Search

This Product

    Database Autonomy Service:Slow query logs

    Document Center

    Database Autonomy Service:Slow query logs

    Last Updated:Jul 17, 2026

    Database Autonomy Service (DAS) analyzes slow query logs to identify SQL statements that exceed a specified execution time threshold and provides optimization suggestions to help you resolve performance issues.

    Prerequisites

    The target instance must use the ApsaraDB RDS for PostgreSQL database engine.

    Note

    ApsaraDB RDS for PostgreSQL Basic Edition instances are not supported.

    Background information

    Slow query logs are generated by the database kernel. Configuration parameters and thresholds vary by database engine. For details, see the official documentation for your database engine.

    Procedure

    1. Log on to the DAS console.

    2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .

    3. Find the target instance and click the instance ID to open the instance details page.

    4. In the left-side navigation pane, click Request Analysis > Slow Logs.

    5. On the Slow Log Analysis tab, select a time range and view the Slow Log Trend, Event Distribution, Slow Log Statistics, and Slow Log Details for that time range.

      • In the Slow Log Trend chart, you can select a specific point in time to view the corresponding Slow Log Statistics and Slow Log Details.

        Note

        If a slow SQL statement is too long to be fully displayed, hover the pointer over the statement to view the complete text in a pop-up window.

      • On the Slow Query Log Statistics and Slow Query Log Details tabs, click image to save the slow query log information to a local file.

      • Click image to go to OpenAPI Explorer and debug the API. The currently selected and entered parameters are passed automatically.

      • In the Event Distribution section, you can find slow log events within the specified time range. Click an event to view its details.

      • In the Slow Log Statistics section:

        • At the top of the list, select filter conditions to narrow down the data.

        • Click Details in the Actions column of the target SQL template to view its Slow Log Sample .

        • Click Optimize in the Actions column of the target SQL template to view the diagnosis results in the SQL Diagnostic Optimization dialog box.

          If you accept the suggestion, click Copy in the upper-right corner and paste the optimized SQL statement into your database client or Data Management (DMS) to execute it.

          Note

          DAS performs SQL diagnostics based on SQL complexity, table data volume, and current database workload. The process may take more than 20 seconds. After the diagnosis is complete, DAS provides results, optimization suggestions, and the expected performance improvement. Use these results to decide whether to accept the suggestions.

      • In the Slow Log Details section, click Optimize in the Actions column for the target SQL statement to run a SQL Diagnostic Optimization.

    FAQ

    Related documents

    You can enable automatic SQL optimization to let DAS diagnose and optimize slow SQL queries as they occur. For more information, see automatic SQL optimization.