Help Center/ GaussDB(DWS)/ Management Guide/ Monitoring and Alarms/ Databases Monitoring (DMS)/ Typical Scenarios/ SQL Diagnosis
Updated on 2024-09-05 GMT+08:00
View PDF

SQL Diagnosis

Symptom

The execution of SQL statements takes a long time, resulting in great resource consumption.

Troubleshooting Process

If the execution efficiency of SQL statements is low, optimization suggestions are provided after the kernel executes the SQL statements. You can query the execution history to retrieve optimization suggestions and further optimize SQL statements to improve query efficiency.

Troubleshooting Procedure

  1. On the SQL Diagnosing page, select a time period that does not seem right.
  2. Search for SQL statements based on indicators such as the start time, end time, and running duration of the statement.
  3. Click Details to view SQL optimization suggestions.
  4. Optimize the SQL statement based on suggestions.
Parent topic: Typical Scenarios