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

SQL Explorer

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. Click Change Node to change the instance node if needed.
  5. Set your desired time range or select Last 1 hour, Last 6 hours, or Last 1 day, enter a keyword (multiple fields are separated by spaces), or enter a username for the query.
  6. On the SQL tab page, click SQL Explorer to view the full SQL details of the current instance.
  7. On the SQL Statements tab page, click Enable DAS SQL Explorer. Query the SQL statements executed by the current instance by different criteria, including time range, user, keyword, and database.

    A maximum of 10,000 SQL statements can be displayed. If you need to view more, click Export to export them.

    A maximum of 100,000 records can be exported.

  8. Click Export History to view the all SQL statements exported.
  9. On the SQL Templates tab page, select a time range as required to view SQL templates and their statistical information, such as the average execution duration.

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