Help Center > > User Guide> Intelligent O&M> Intelligent O&M for GaussDB(for openGauss) DB Instance> SQL> Slow Query Logs

Slow Query Logs

Updated at: Jun 09, 2021 GMT+08:00

Procedure

  1. Log in to the GaussDB(for openGauss) console.
  2. Apply for Intelligent O&M according to Intelligent O&M.
  3. Locate your desired instance and click Details to go to the Intelligent O&M overview page.
  4. On the SQL tab page, click Slow Query Logs to view the slow SQL trend of the current instance.
  5. Set your desired time range or select Last 1 hour, Last 6 hours, or Last 1 day to view the corresponding slow query logs, CPU usage, and archived slow query logs.

    Figure 1 Log Archiving

  6. Click Enable DAS Slow Query Log. In the displayed dialog box, read and agree to the security agreement, and click OK.
  7. On the lower part of the Log Trends tab page, view the statistics and details of slow query logs.

    • Query and view slow query logs by database name.
    • Click Export Slow Query Log to export the slow query logs.
    • Click Export History to view the export history of slow query logs.

  8. In the slow query log list, click Download to download and view log data.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel